A system, method and article of manufacture for query execution management
in a data processing system and, more particularly, for optimizing
execution of queries that are repeatedly executed against one or more
databases in a data processing system. One embodiment provides a method
for optimizing execution of a query that is repeatedly issued from an
issuing entity against a database. The method comprises executing the
query against the database to obtain an initial query result, returning
the initial query result to the issuing entity, and managing re-execution
of the query. Managing the re-execution comprises 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 re-executed against the database, returning the temporary query
result data structure to the issuing entity as query result.