Patent ID: 7774357

Claim:
A computer-readable medium encoded with a computer program product for implementing enhanced query governor functions in a computer system, said computer-readable medium consisting one of a floppy disk, a hard disk, a high capacity read only memory in the form of an optically read compact disk or CD-ROM, a DVD, a tape, a read only memory (ROM), and a random access memory (RAM), said computer program product including instructions stored on the computer-readable medium, wherein said instructions, when executed by the computer system to cause the computer system to perform 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 comprise 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 a monitor being requested, setting timeout values for the requested monitor; wherein the requested monitor checks 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 an 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.