Inside Symbian SQL (eBook)
432 Seiten
Wiley (Verlag)
978-0-470-74475-8 (ISBN)
Since Symbian SQL and SQLite are relatively new additions to the Symbian platform, Inside Symbian SQL begins with an introduction to database theory and concepts, including a Structured Query Language (SQL) tutorial.
Inside Symbian SQL also provides a detailed overview of the Symbian SQL APIs. From the outset, you will 'get your hands dirty' writing Symbian SQL code. The book includes snippets and examples that application developers can immediately put to use to get started quickly.
For device creators and system software developers, Inside Symbian SQL offers a unique view into the internals of the implementation and a wealth of practical advice on how to make best and most efficient use of the Symbian SQL database. Several case studies are presented - these are success stories 'from the trenches', written by Symbian engineers.
Special Features:
- The book assumes no prior knowledge of databases
- Includes detailed and approachable explanations of database concepts
- Easy to follow SQL tutorial with SQLite examples
- Unique view into the Symbian SQL internals
- Troubleshooting section with solutions to common problems
Written by the Symbian engineers who implemented SQLite on Symbian, with more than 40 years combined Symbian C++ experience, this book is for anyone interested in finding out more about using a database on Symbian.
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.
This is the definitive guide for Symbian C++ developers looking to use Symbian SQL in applications or system software. Since Symbian SQL and SQLite are relatively new additions to the Symbian platform, Inside Symbian SQL begins with an introduction to database theory and concepts, including a Structured Query Language (SQL) tutorial. Inside Symbian SQL also provides a detailed overview of the Symbian SQL APIs. From the outset, you will get your hands dirty writing Symbian SQL code. The book includes snippets and examples that application developers can immediately put to use to get started quickly. For device creators and system software developers, Inside Symbian SQL offers a unique view into the internals of the implementation and a wealth of practical advice on how to make best and most efficient use of the Symbian SQL database. Several case studies are presented these are success stories 'from the trenches', written by Symbian engineers. Special Features: The book assumes no prior knowledge of databases Includes detailed and approachable explanations of database concepts Easy to follow SQL tutorial with SQLite examples Unique view into the Symbian SQL internals Troubleshooting section with solutions to common problems Written by the Symbian engineers who implemented SQLite on Symbian, with more than 40 years combined Symbian C++ experience, this book is for anyone interested in finding out more about using a database on Symbian.
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.
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.
| Erscheint lt. Verlag | 18.2.2010 |
|---|---|
| Sprache | englisch |
| Themenwelt | Mathematik / Informatik ► Informatik ► Datenbanken |
| Mathematik / Informatik ► Informatik ► Netzwerke | |
| Schlagworte | Computer Science • Informatik • Networking • Netzwerk • Netzwerke |
| ISBN-10 | 0-470-74475-8 / 0470744758 |
| ISBN-13 | 978-0-470-74475-8 / 9780470744758 |
| Haben Sie eine Frage zum Produkt? |
PDF (Adobe DRM)Größe: 1,6 MB
Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine
Geräteliste und zusätzliche Hinweise
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
