Patent ID: 7127449

Claim:
A method for optimizing execution of a query that is repeatedly issued from an issuing entity against a database, the method comprising: prior to executing the query against the database to obtain an initial query result: (i) determining an amount of system resources required for executing the query; and (ii) managing the re-execution of the query if the determined amount exceeds a predetermined threshold value; executing the query against the database to obtain the initial query result; returning the initial query result to the issuing entity; and managing re-execution of the query by: storing the initial query result in a temporary query result data structure; executing a trigger procedure for tracking database changes; when the trigger procedure detects a database change, updating the temporary query result data structure on the basis of the detected database change; and when the query is submitted for re-execution against the database, returning the temporary query result data structure to the issuing entity.