초록 ▼

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 s

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.

대표청구항 ▼

1. In a computer system, a method for creating a database application program for accessing and processing data from a database, the method comprising:receiving source code for the database application program, the source code including embedded SQL statements; examining the source code for determin

1. In a computer system, a method for creating a database application program for accessing and processing data from a database, the method comprising:receiving source code for the database application program, the source code including embedded SQL statements; examining the source code for determining information about the embedded SQL statements present in the source code; passing the information about the embedded SQL statements present in the source code to a database management system for formulating data access; based on how data access has been formulated, creating new source code which includes new source code statements replacing the embedded SQL statements, said new source code statements including program logic that provides said data access; and from the new source code, generating an executable version of the database application program.