UltraLite Database User's Guide
Using UltraLite Static Interfaces
To implement the UltraLite database engine for your application, the UltraLite generator must have access to an Adaptive Server Anywhere reference database. This database must contain the following information:
Database schema The database objects used in your UltraLite application, including tables and any indexes on those tables you wish to use in your application.
For more information, see Using an existing database as a reference database.
Data (Optional) You can fill your reference database with data that is similar in quantity and distribution to the data you expect your UltraLite database to hold. The UltraLite analyzer automatically uses this information to optimize the performance of your application.
For more information, see Using an existing database as a reference database.
Queries The UltraLite system tables must contain any SQL statements you wish to use in your application.
For more information, see Defining SQL statements for your application.
Publications If you wish to add multiple synchronization options to your application, you can do so using publications. You also add publications to your database if you wish to develop a C++ API application without defining queries.
For information on multiple synchronization options, see Designing sets of data to synchronize separately.
Database options Database options such as date formats and govern some aspects of database behavior that can make applications behave differently. The UltraLite database is generated with the same option settings as those in the reference database.
For many purposes, you can leave all database options at their default settings.
For more information, see Setting database options in the reference database.
Creating a reference database
Setting database options in the reference database
Using an existing database as a reference database
Optimizing query execution