摘要 |
An "UltraLite" database development environment capable of creating a database application that is more portable across multiple devices, including ones having limited computational power, is described. The applications themselves can incorporate SQL statements and SQL cursors for use against data sources, including UltraLite databases. The UltraLite development environment generates code to process the SQL in the application. The application code and generated code are compiled and then linked with the UltraLite runtime library. The result is an UltraLite program that includes application logic and database logic together in a single program. The environment includes, at its core, an "Analyzer" which receives SQL from the pre-compiler and submits the SQL to an available database server (e.g., Sybase Adaptive Server Anywhere) for parsing and optimization. The Analyzer uses the database server's (i.e., the database server of Adaptive Server Anywhere) access plans and schema information to generate C code to execute the SQL statements. By making the footprint for an UltraLite program as small as possible, the system provides a database system with low overhead, making it easier to create an application targeting device having limited computational power.
|