Home Shop Service Jobs Newsletter Company Sitemap Entertainment Shopping cart Deutsch
Books | Forthcoming titles | Computer Science | Inside Symbian SQL
Browse our products
Books
 
Just published
Title search
Featured sites
Entertainment
Journals
Electronic Media
Choose your area of interest
 
Litovski, Ivan / Maynard, Richard
Inside Symbian SQL
A Mobile Developer's Guide to SQLite

1. Edition - February 2010
44.90 Euro
2010. 432 Pages, Softcover
ISBN-10: 0-470-74402-2
ISBN-13: 978-0-470-74402-4 - John Wiley & Sons


Order



Sample Chapter

Short description
Inside the Symbian SQL Database is the only up-to-date reference book on the market to get you up-to-speed using a SQL database in a mobile environment. It shows you how to design code and ease migration from an internal and external point of view, while revealing 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 fine-tune applications that use the Symbian SQL framework to ultimately improve performance. An ideal reference for Symbian OS developers, programmers, and software engineers.

From the contents
Foreword by Richard Hipp.

Foreword by Chris Dudding.

Author Biographies.

Author's Acknowledgments.

Symbian Acknowledgments.

Publisher's Acknowledgements.

1 Introduction.

1.1 Where Should You Start?

1.2 Symbian Terminology and Version Numbering.

1.3 The Relational Model and the Structured Query Language (SQL) 2.

1.4 What Is Symbian SQL?

1.5 A Well-Oiled Machine.

1.6 Tools and Troubleshooting.

1.7 Further Reading and Resources.

2 Getting Started.

2.1 Where to Get Symbian SQL.

2.2 Overview of Symbian SQL APIs.

2.3 First Database Example.

2.4 Summary.

3 The Relational Model.

3.1 Background.

3.2 The Structural Component.

3.3 The Integrity Component.

3.4 Normalization.

3.5 The Manipulative Component.

3.6 The Meaning of Relational.

3.7 Summary.

4 Everything You Ever Wanted to Know about SQL but Were Afraid to Ask.

4.1 The Relational Model.

4.2 The Example Database.

4.3 Syntax.

4.4 Creating a Database.

4.5 Querying a Database.

4.6 Modifying Data.

4.7 Data Integrity.

4.8 Transactions.

4.9 Database Administration.

4.10 Summary.

5 Database Concepts.

5.1 Database Types.

5.2 Executing SQL.

5.3 Multi-Client Access.

5.4 Summary.

6 Using Symbian SQL.

6.1 The Database Connection Class.

6.2 The Prepared Statement Class.

6.3 Working with Variable-Length Data Objects.

6.4 The Scalar Query Class.

6.5 Security Policies.

6.6 Summary.

7 SQLite Internals on Symbian.

7.1 Why SQLite Is Right for Symbian.

7.2 The SQLite Modules.

7.3 SQLite Configuration Options.

7.4 SQLite Optimizations on Symbian OS.

7.5 Summary.

8 Performance Tuning.

8.1 Design and Development Considerations.

8.2 An Introduction to Optimization.

8.3 Optimizing Applications.

8.4 Symbian SQL Optimization Tips.

8.5 Summary.

9 Using Symbian SQL: Three Case Studies.

9.1 Contacts Model.

9.2 Columbo Search Service.

9.3 Wikipedia Demo Application.

9.4 Summary.

Appendix A Troubleshooting.

Appendix B SDB Database Creation Tool.

Appendix C Symbian SQL Error Codes.

References.

Index.


 
Order
Short description
Detailed description
Author affiliation

Related Books

Designing Software and Cognitive Radios

Linear and Non-Linear Video and TV Applications
Using IPv6 and IPv6 Multicast

Information Storage and Management: Storing, Managing, and Protecting Digital Information


[more >>]

Special Offers

Zhang, Jiujun / Zhang, Lei / Liu, Hansan / Sun, Andy / Liu, Ru-Shi (eds.)

Electrochemical Technologies for Energy Storage and Conversion
199.- Euro
valid until
31 March 2012

[more offers >>]


 

        

Tell a friend          RSS Feeds             Print-Version

©2012 Wiley-VCH Verlag GmbH & Co. KGaA - Provider
http://www.wiley-vch.de - mailto: info@wiley-vch.de
Data Protection