METHOD OF RETRIEVING DATA FROM A RELATIONAL DATABASE

A computerized method of retrieving data from a relational database stored in a computer memory, using SQL queries, which give rise to result sets derived from data objects in the database. The method includes the steps of capturing an SQL query and corresponding result set, and saving the SQL query and result set. In another feature of the invention, the method includes, before the step of capturing an SQL query and corresponding result set, the step of monitoring the SQL queries. In another feature of the invention, the method includes, before the step of saving the SQL result set, the steps of comparing the SQL query with prior saved SQL queries, determining if an identical prior SQL query already exists in cache, and if an identical prior SQL query does not already exists, saving the SQL query and result set. In another feature of the invention, each data object used by the saved result sets has an associated data object time stamp, and the method of the invention monitors the data object time stamps of all data objects used by the result sets.