Method and system for responding to queries

A method performed by a computer system of providing data to an application program, wherein the application program includes a structured database query to a database management system (DBMS) to request data stored in a database, comprising:

• identifying data that is at least partially responsive to at least one structured database query to be executed by the application program, and that is static over a period;
• automatically modifying a source code of the application program before the application program run time, wherein said modifying comprises:
• inserting start-up code in the source code;
• and
• inserting trap code in the source code to avoid the at least one structured database query;
• and
• executing the modified application program, wherein said executing comprises:
• at start-up, retrieving the identified data responsive to the at least one structured database query and storing the identified data in a local main memory;
• and
• at run time, avoiding executing the at least one structured database query when the at least one structured database query has a request for data that is stored in the local main memory, and directly accessing the requested data from the identified data stored in the local main memory instead of the data stored in the DBMS without executing the structured database query, and
• where the local main memory is characterized by an access latency less than the latency associated with retrieving the identified data from the DBMS using the at least one structured database query, and where the access latency is defined with respect to the application program.

A method performed by a computer system of avoiding structured database queries for requesting data from a database management system (DBMS) by an application program, the method comprising:

• prior to application program run time:
• identifying the data in the DBMS responsive to at least one structured database query to be executed by the application program,
• retrieving the identified data from the DBMS, and
• storing the identified data in a local main memory;
• automatically modifying a source code of the application program to directly access at run time the identified data stored in the local main memory, creating a modified application program;
• executing the modified application program;
• and
• while executing the modified application program, avoiding executing the at least one structured database query and directly accessing the identified data stored in the local main memory without executing the structured database query.

A method performed by a computer system of automatically modifying an application program having structured data queries that request data from a database management system (DBMS), comprising:

• identifying a subset of data in the DBMS responsive to at least one of the structured data queries, retrieving the identified subset of data from the DBMS, and storing the identified data in a local main memory prior to application program run time;
• and
• automatically modifying the application program to insert trap code to perform trapping of at least one of the structured data queries, said trapping comprising, during execution of the modified application program:
• determining whether the structured query has a request for data that is in the identified data stored in the local main memory;
• and
• when the structured query has a request for data that is in the identified data stored in the local main memory, avoiding executing the structured query by directly accessing the identified data stored in the local main memory without executing the structured query.