Overview

Full Product Details

Author:   Ivan Litovski ,  Richard Maynard
Publisher:   John Wiley and Sons Ltd
Imprint:   John Wiley & Sons Ltd
Dimensions:   Width: 19.00cm , Height: 2.70cm , Length: 23.40cm
Weight:   0.808kg
ISBN:  

9780470744024

ISBN 10:   0470744022
Pages:   432
Publication Date:   26 February 2010
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Out of Print
Availability:   In Print  
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.

Table of 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.

Reviews

Author Information

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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions