Data query system load optimization

A method for optimizing system resources used to execute a query that is repeatedly issued from an issuing entity against a database, the method comprising:

• tracking changes to the database;
• if a database change is detected:
• retrieving a temporary query result data structure storing a query result obtained from a previous execution of the query;
• updating the temporary query result data structure on the basis of the detected database change;
• and
• if the query is submitted for re-execution against the database, returning the temporary query result data structure as a query result to the issuing entity;
• and
• prior to the tracking:
• determining an amount of system resources required to execute the query;
• and
• tracking the changes to the database only if the determined amount exceeds a predetermined threshold value.

A computer readable medium containing a program which, when executed, performs a process for optimizing execution of a query that is repeatedly issued from an issuing entity against a database, the process comprising:

• prior to executing the query against the database to obtain an initial query result:
• determining an amount of system resources required for executing the query;
• and
• managing the re-execution of the query only 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.

A computer readable medium containing a program which, when executed, performs a process for optimizing system resources used to execute a query that is repeatedly issued from an issuing entity against a database, the process comprising:

• tracking changes to the database;
• if a database change is detected:
• retrieving a temporary query result data structure storing a query result obtained from a previous execution of the query;
• updating the temporary query result data structure on the basis of the detected database change;
• and
• if the query is submitted for re-execution against the database, returning the temporary query result data structure as a query result to the issuing entity;
• and
• prior to the tracking:
• determining an amount of system resources required to execute the query;
• and
• tracking the changes to the database only if the determined amount exceeds a predetermined threshold value.

A data processing system comprising:

• a database;
• and
• a query optimizer residing in memory for optimizing execution of a query that is repeatedly issued from an issuing entity against the database, the query optimizer being configured for:
• prior to executing the query against the database to obtain an initial query result:
• determining an amount of system resources required for executing the query;
• and
• managing the re-execution of the query only 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.

A data processing system comprising:

• a database;
• and
• a query optimizer residing in memory for optimizing system resource use for execution of a query that is repeatedly issued from an issuing entity against the database, the query optimizer being configured for:
• tracking changes to the database;
• if a database change is detected:
• retrieving a temporary query result data structure storing a query result obtained from a previous execution of the query;
• updating the temporary query result data structure on the basis of the detected database change;
• and
• if the query is submitted for re-execution against the database, returning the temporary query result data structure as a query result to the issuing entity;
• and
• prior to the tracking:
• determining an amount of system resources required to execute the query;
• and
• tracking the changes to the database only if the determined amount exceeds a predetermined threshold value.