Detecting database events using recovery logs

Details Detecting database events using recovery logs Detecting database events using recovery logs

2006-03-10

2009-06-30

Trujillo, James (Department: 2159)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

07555502

ABSTRACT:
A method and apparatus for determining when an event occurred in a database is provided. At least a portion of the database is restored to a point in time that is prior to the event. Recovery logs are translated to database operations (e.g., SQL) that are capable of causing the changes described in the recovery logs. A mechanism is created for detecting the event based on execution of the statements. For example, a database trigger is created to detect the event. The database operations are executed against the restored database to cause the mechanism to detect the event.

REFERENCES:
patent: 6353835 (2002-03-01), Lieuwen
patent: 6427146 (2002-07-01), Chu
patent: 2005/0097149 (2005-05-01), Vaitzblit et al.
patent: 2005/0289187 (2005-12-01), Wong et al.
patent: 2006/0004794 (2006-01-01), Pizzo et al.
patent: 2006/0259518 (2006-11-01), Lomet et al.
patent: 2007/0130226 (2007-06-01), Banerjee et al.
Using LogMiner to Analyze Redo Log Files, Oracle 9i Database Administrator's Guide, published May 8, 2005, http://webarchive.org/web/20050508055130/http://www.cs.uvm.edu/oracle9doc/.
Joris Mihaeli and Opher Etzion, Event Database Processing, IBM Haifa Research Lab, 2004.
Manish Bhide, Ajay Gupta, Mukul Joshi and Mukesh Mohania, Optimal Deployment of Triggers for Detecting Events, IBM India Research Labratory, DEXA 2004, pp. 66-76.
European Patent Office, “Notification of Transmittal of the International Search Report and the Written Opinion of the International Searching Authority, or the Declaration”, international application No. PCT/US2007/005351, dated Jul. 26, 2007, 12 pages.
Claims, international application No. PCT/US2007/005351, 3 pages.
Prescott, William, “Database Triggers”, Oracle, XP-002924136, 2001, 14 pages.
Snodgrass, Rick, “Temporal Support in Standard SQL”, Database Programming & Design Online, DBPD: Temporal Support in Standard SQL, Retrieved from website: <http://www.dbpd.com/vault/9810snod.html>, Oct. 1998, 9 pages.
Chen, Kevin, et al., “ECF- Event Correlation For Forensics”, 1stAustralian Computer, Network & Information Forensics Conference 2003, XP-002441540, Retrieved from website: http://scissec.scis.ecu.edu.au/conference—proceedings/2003/forensics/pdf/11—final.pdf , dated Nov. 25, 2003, 10 pages.
Snodgrass, Richard T., “Developing Time-Oriented Database Applications in SQL,” Morgan Kaufmann Publishers—2000, 504 pages.
Terry, Douglas et al., “Continuous Queries over Append Only Databases,” ACM SIGMOND, Jun. 1992, pp. 321-330.

Affiliated with

Also associated with

Rating

Detecting database events using recovery logs does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Detecting database events using recovery logs, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Detecting database events using recovery logs will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4107721