Patent ID: 7340448
Filing Date: 2008-03-04
Classification: G06F,Y10S

Abstract:
1. A method for implementing enhanced query governor functions using a computer system for providing enhanced performance for said computer system, said computer system performing said method comprising the steps of: receiving a query; breaking down the received query into query execution components, wherein the query execution components comprises query data retrieval processing, user defined function (UDF) processing and trigger processing; monitoring events, wherein the monitored events comprising at least an event to modify attributes and an event to execute query; responsive to the monitored event to modify attributes, performing a modify attributes routine, said performing the modify attributes routine including checking for a monitor being requested, and responsive to the monitor being requested, setting timeout values for the requested monitor, wherein the requested monitor checking the user defined function (UDF) processing and the trigger processing against the set timeout values; responsive to the monitored event to execute query, performing an execute query routine, said performing the execute query routine including checking for a timeout value for the query data retrieval and checking for the set timeout values performed by the modify attributes routine; responsive to an identified timeout value for the query data retrieval, resetting an execution time for the query; starting the requested monitor; starting the execution of the query; monitoring the execution of predefined events during the execution of the query; said predefined events including a begin or end of processing of each requested monitor; storing start and end processing time of the user defined function (UDF) processing and the trigger processing in a table; periodically checking execution status of the query; checking for an expired timeout value for the query data retrieval and for the requested monitor; and halting the execution of the query responsive to an identified expired timeout value.