Automatic generation of database queries

A system for automatically generating queries for and retrieving data from a database, comprising:

• a database management system (DBMS) operating on a computer wherein data held in the DBMS is organized and maintained in related data structures and wherein the relationship and organization of the data structures is specified by a schema, and wherein the DBMS receives and executes queries written in a code of a query language;
• an application program executing on a computer;
• query generating program executing on a computer to perform the tasks of:
• a) receiving from the application program a specification of a schema of a DBMS from which data is to be retrieved,
• b) receiving from the application program a specification of a structure for holding data retrieved from the DBMS,
• c) receiving from the application program a specification of the data sought to be retrieved from the DBMS,
• d) using the specification of the schema and the specification of data sought to be retrieved automatically generating query language code to carry out two or more queries of the DBMS which will retrieve the sought after data, a first one of the queries being a primary query for retrieving a first set of data, and a second one of the queries being a secondary query for retrieving a second set of data, the secondary query using data retrieved in the primary query to obtain the second set of data,
• e) automatically sending at least the first and second queries to the DBMS at different successive times and retrieving the associated data;
• f) organizing at least some of the retrieved data into the specified structure for holding data retrieved from the DBMS;
• and
• g) sending the data held in the specified structure to the application program.

An article of manufacture comprising computer program code recorded on a computer-readable media, the computer program code executable on a computer for automatically generating queries for and retrieving data from a database management system (DBMS) wherein the data held in the DBMS is organized and maintained in related data structures and wherein the relationship and organization of the data structures is specified by a schema, and wherein the DBMS receives and executes queries written in a code of a query language, the computer program code operating a computer to:

• g) receive a specification of a schema of a DBMS from which data is to be retrieved;
• h) receive a specification of a structure for holding data retrieved from the DBMS;
• i) receive a specification of the data sought to be retrieved from the DBMS;
• j) use the specification of the schema and the specification of data sought to be retrieved to automatically generate query language code to carry out two or more queries of the DBMS which will retrieve the sought after data, a first one of the queries being a primary query for retrieving a first set of data, and a second one of the queries being a secondary query for retrieving a second set of data, the secondary query using data retrieved in the primary query to obtain the second set of data;
• k) automatically send at least the first and second queries to the DBMS at different successive times and retrieving the associated data;
• and
• l) organize at least some of the retrieved data into the specified structure for holding data retrieved from the DBMS.