Interface to DBMS databases

This section provides details about various interfaces available to access relational databases on Symbian platform.

• Introduction to DBMS databases
  DBMS provides a functional interface to a relational database.
• Rules for DBMS names
  Tables, indexes, columns etc. have naming restrictions such as they must begin with an alphabetic character. This document lists those rules.
• Implementation limits
  This document lists the maximum number of tables, columns, indexes and so on per database.
• Database storage overhead
  Database storage is very efficient. This document gives details of the storage overhead.
• Data safety and recovery
  Databases are very robust and will survive crashes in most situations. This document talks about the situations where data corruption or database integrity could be compromised.
• Database encryption
  Database data can be encrypted by the DBMS.
• Database compression
  A Store database can be compressed and the data is dynamically decompressed as required. A compressed database is read-only.
• Error codes
  The errors returned by DBMS functions are mostly documented with those functions, but this document summarises some of the more common/general errors.
• Transactions on store databases
  Atomicity of updates, roll backs, and what happens to indexes when a rollback happens are covered in this document.
• Indexes
  Most datatypes can be used in indexes, but there are restrictions when using LongText data types.