Patent ID: 7555502

Claim:
A computer-implemented method that detects occurrence of an event in a database, comprising: restoring a copy of at least a portion of the database to a point prior to the occurrence of a beginning event of a temporal query; translating redo log records that describe changes to the database into statements that reflect database operations that are capable of causing the changes to the database; generating a first database trigger for detecting the beginning event based on execution of the statements; and causing the first database trigger to detect the beginning event by executing the statements; generating a second database trigger for detecting an end event of the temporal query based on execution of the statements; accessing a base query that is based on the temporal query; after the first database trigger detects the beginning event, performing the following: causing the second database trigger to detect the end event by executing the statements; and in response to the second database trigger detecting the end event, issuing the base query to determine a response to the temporal query, wherein results of the base query provide a response to the temporal query; wherein the steps of restoring, translating, and issuing are performed on one or more computing devices.