Muutke küpsiste eelistusi

E-raamat: Inside Symbian SQL: A Mobile Developer's Guide to SQLite

,
  • Formaat: PDF+DRM
  • Ilmumisaeg: 18-Feb-2010
  • Kirjastus: John Wiley & Sons Ltd
  • Keel: eng
  • ISBN-13: 9780470744758
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 43,21 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Inside Symbian SQL: A Mobile Developer's Guide to SQLiteSuurem pilt
  • Formaat: PDF+DRM
  • Ilmumisaeg: 18-Feb-2010
  • Kirjastus: John Wiley & Sons Ltd
  • Keel: eng
  • ISBN-13: 9780470744758
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

The only up-to-date reference covering the Symbian SQL smartphones

Symbian OS smartphones are synonymous with advanced communications and multimedia features. To create Symbian SQL, Symbian has implemented SQLite-the most deployed SQL database engine in the world, currently used in a wide range of commercial software products and electronic devices from leading manufacturers such as Mozilla's Firefox.

Inside the Symbian SQL Database is the only up-to-date reference book on the market to cover the Symbian SQL database. The author team-members of the Symbian engineering team responsible for the implementation of the code-shows you how to design code and ease migration from an internal and external point of view, plus they reveal the dos and don'ts of writing high-performance database applications. Packed with resources and sample code, this timely book reveals how to design and tune applications that use the Symbian SQL framework to ultimately improve performance.

  • Serves as the only current guide on the market to get you up-to-speed using a SQL database in a mobile environment
  • Written by members of the Symbian engineering team responsible for the implementation of the code
  • Contains a Foreword by D. Richard Hipp, creator and lead developer of SQLite
  • SQLite is a hot, new technology to keep up with in the fast-moving mobile world

With its sample code and insider expertise, Inside the Symbian SQL Database has everything you need to keep you ahead of the curve.

Foreword xiii
Richard Hipp
Foreword xvii
Chris Dudding
Author Biographies xxi
Author's Acknowledgments xxv
Symbian Acknowledgments xxvii
Publisher's Acknowledgements xxviii
Introduction
1(8)
Where Should You Start?
1(1)
Symbian Terminology and Version Numbering
2(1)
The Relational Model and the Structured Query Language (SQL)
2(1)
What Is Symbian SQL?
3(3)
A Well-Oiled Machine
6(1)
Tools and Troubleshooting
6(1)
Further Reading and Resources
6(3)
Getting Started
9(10)
Where to Get Symbian SQL
9(1)
Overview of Symbian SQL APIs
9(1)
First Database Example
10(7)
Project Setup
11(1)
Creating a Database
11(1)
Creating a Table
12(1)
Creating an Index
12(1)
Inserting Records
13(1)
Selecting Records
13(2)
Updating a Record
15(1)
Updating Records Using Column Binding and Streaming
15(1)
Deleting a Record
16(1)
Closing a Database
17(1)
Summary
17(2)
The Relational Model
19(32)
Background
20(1)
The Three Components
20(1)
SQL and the Relational Model
21(1)
The Structural Component
21(13)
The Information Principle
21(2)
The Sanctity of the Logical Level
23(1)
The Anatomy of the Logical Level
24(1)
Tuples
25(1)
Relations
26(4)
Tables: Relation Variables
30(2)
Views: Virtual Tables
32(1)
The System Catalog
33(1)
The Integrity Component
34(5)
Primary Keys
34(1)
Foreign Keys
35(2)
Constraints
37(1)
Null Values
38(1)
Normalization
39(6)
Normal Forms
39(1)
First Normal Form
40(1)
Functional Dependencies
40(1)
Second Normal Form
41(2)
Third Normal Form
43(2)
The Manipulative Component
45(3)
Relational Algebra and Calculus
45(1)
The Relational Query Language
46(1)
The Advent of SQL
47(1)
The Meaning of Relational
48(1)
Summary
49(2)
Everything you Ever Wanted to Know about SQL but Were Afraid to Ask
51(112)
The Relational Model
52(2)
Query Languages
53(1)
Growth of SQL
53(1)
The Example Database
54(2)
Installation
55(1)
Running the Examples
55(1)
Syntax
56(4)
Commands
58(1)
Literals
58(1)
Keywords and Identifiers
59(1)
Comments
60(1)
Creating a Database
60(2)
Creating a Table
60(2)
Altering a Table
62(1)
Querying a Database
62(48)
Relational Operations
63(1)
The Operational Pipeline
64(5)
Filtering Rows
69(7)
Limiting and Ordering
76(2)
Functions and Aggregates
78(3)
Grouping
81(4)
Removing Duplicates
85(1)
Joining Tables
85(9)
Column Names and Aliases
94(2)
Subqueries
96(4)
Compound Queries
100(3)
Conditional Results
103(1)
The Thing Called NULL
104(4)
Set Operations
108(2)
Modifying Data
110(5)
Inserting Records
110(4)
Updating Records
114(1)
Deleting Records
115(1)
Data Integrity
115(22)
Entity Integrity
116(5)
Domain Integrity
121(4)
Storage Classes
125(4)
Manifest Typing
129(2)
Type Affinity
131(6)
Transactions
137(6)
Transaction Scope
138(1)
Conflict Resolution
139(3)
Transaction Types
142(1)
Database Administration
143(18)
Views
143(2)
Indexes
145(7)
Triggers
152(6)
Attaching Databases
158(1)
Cleaning Databases
159(1)
The System Catalog
160(1)
Viewing Query Plans
160(1)
Summary
161(2)
Database Concepts
163(16)
Database Types
163(3)
Public Databases
164(1)
Private Databases
164(1)
Secure Shared Databases
164(2)
Executing SQL
166(5)
How the Database Processes SQL
166(1)
One-shot Execution
167(1)
Prepared Statements
168(3)
Multi-Client Access
171(6)
Transactions
171(2)
Connections
173(1)
Locking
173(3)
Connections, Transactions and Locking
176(1)
Prepared Statements and Locking
177(1)
Summary
177(2)
Using Symbian SQL
179(26)
The Database Connection Class
179(10)
Connecting and Disconnecting
179(3)
Creating and Deleting Databases
182(1)
Attaching Additional Databases
182(1)
Executing SQL
183(1)
Copying and Deleting a Database File
184(1)
Managing Disk Usage
185(3)
Transaction APIs
188(1)
Retrieving the Security Policy
189(1)
The Prepared Statement Class
189(7)
Preparing and Executing SQL Statements
189(2)
Retrieving Column Values
191(3)
Parameterized Queries
194(2)
Working with Variable-Length Data Objects
196(4)
Retrieving Data
196(1)
Retrieving Large Amounts of Data
197(1)
Streaming Data
198(2)
The Scalar Query Class
200(2)
Security Policies
202(1)
Summary
203(2)
SQLite Internals on Symbian
205(74)
Why SQLite is Right for Symbian
206(1)
The SQLite Modules
207(43)
Public Interface
209(12)
Compiler
221(7)
Virtual Machine
228(1)
B-Tree Module
228(13)
Pager
241(6)
OS Interface
247(3)
SQLite Configuration Options
250(4)
Auto-vacuum
251(1)
Page Size
252(1)
Maximum Cache Size
252(1)
Database Encoding
253(1)
SQL Statement Encoding
254(1)
SQLite Optimizations on Symbian OS
254(24)
Sharing the Cache
256(1)
Retaining Page Cache Contents
256(2)
Imposing a Soft Heap Limit
258(1)
Increasing the Maximum Cache Size
258(4)
Avoiding Unnecessary Reads
262(2)
Avoiding Unnecessary Writes
264(2)
Minimizing the Cost of Using Journal Files
266(2)
Mass Storage and Fast Retrieval of Binary Data (BLOBs)
268(7)
Background Database Compaction
275(3)
Summary
278(1)
Performance Tuning
279(70)
Design and Development Considerations
280(4)
Identify Key Use Cases
281(1)
Set Performance Objectives
282(1)
Measure Performance
282(2)
Develop Performance Tests
284(1)
Follow up Test Results
284(1)
An Introduction to Optimization
284(2)
Understand the Operation of the Application
285(1)
Identify Bottlencks Before Optimizing
285(1)
Avoid Early Optimization
285(1)
Maintain Performance Test Records
286(1)
Carry Out One Optimization at a Time
286(1)
Optimize in the Right Environment
286(1)
Optimizing Applications
286(12)
Application Layer
287(1)
Data Model
288(1)
Indexing
289(4)
SQL Queries
293(1)
Memory Usage
294(2)
System Tuning
296(2)
Symbian SQL Optimization Tips
298(50)
Data Organization
298(5)
Expressions
303(8)
Statements
311(7)
Indexing
318(14)
Using the Optimizer
332(4)
Resource Usage
336(12)
Summary
348(1)
Using Symbian SQL: Three Case Studies
349(20)
Contacts Model
349(6)
Contacts Model on DBMS
350(1)
Aims of Migration
351(1)
Contacts Model on Symbian SQL
352(2)
Possible Future Improvements
354(1)
Case Study Summary
354(1)
Columbo Search Service
355(8)
Why Symbian SQL?
355(2)
Developing with SQLite
357(5)
Case Study Summary
362(1)
Wikipedia Demo Application
363(4)
Downloading the Symbian Wikipedia Demo Application
363(1)
Storing Wikipedia on a Phone
363(1)
Designing the Schema (the Wrong Way)
364(1)
Designing the Schema (the Right Way)
365(1)
Displaying the List of Articles
366(1)
Retrieving the Content of Articles
367(1)
Case Study Summary
367(1)
Summary
367(2)
Appendix A Troubleshooting
369(12)
Executing SQL Statements
369(4)
SQL Language
373(4)
Memory and Disk Usage
377(1)
Transactions
378(2)
Error Handling
380(1)
Appendix B SDB Database Creation Tool
381(6)
Obtaining and Installing SDB
381(1)
Using SDB
381(2)
SDBv1 Configuration Files
383(4)
Appendix C Symbian SQL Error Codes
387(2)
References 389(2)
Index 391
Richard Maynard joined Symbian in 2002 working in the System Libraries team. After leading the team's transition to Platform Security in Symbian OS v9, he moved to head up the newly-formed Persistent Data Services team which had been created in order to introduce a new standards-compliant SQL database to the platform. Prior to working at Symbian, Richard worked in the fields of 3G telecommunications and radar design. Ivan Litovski first joined Symbian in 2002 working first in the Java Team and later with System Libraries, Persistent Data Services and Product Creation Tools teams. Ivan has eleven years of professional experience with Java, embedded software, information security, networking, scalable servers and internet protocols. He enjoys solving difficult problems and R&D work, and has authored several patents and papers in peer reviewed international journals. Ivan holds a BSc Electronics and Telecommunications from University of Nis, Serbia. He is an Accredited Symbian Developer.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97804707447582e.html
Märksõnad: