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.