Method and apparatus for audit trail logging and data base recov

Details Method and apparatus for audit trail logging and data base recov Method and apparatus for audit trail logging and data base recov

1994-05-13

1996-10-01

Black, Thomas G.

Boots, shoes, and leggings

364DIG1, 3642219, 36422281, 36422282, 395445, G06F 710, G06F 720, G06F 1730, G06F 1200

Patent

active

055617956

ABSTRACT:
The disclosure relates to a transaction processing system where audit information for database updates and the status of transactions in process is sequentially written in audit records in an audit file, where the audit file may be used to restore the database to a consistent state following a system failure. The invention decreases the overhead processing required for auditing, and at the same time minimizes the impact the auditing has on the processing time required for restoring the database. A value which references the location in the audit file at which recovery of the database may begin is conditionally updated each time a page of the database which is cached in the main memory of the data processing system is written to non-volatile storage, based upon the position of the earliest written audit record which is associated with the cached page. In addition, when processing of a transaction is complete, the transaction identifier of the oldest incomplete transaction is saved in the audit record for the completed transaction. When restoring the database to a consistent state, the value which is maintained according to the earliest written audit record and the transaction identifier of the oldest incomplete transaction are used as reference points in the audit file to minimize the processing required to restore the database.

REFERENCES:
patent: 4819150 (1989-04-01), DeLorme et al.
patent: 4819156 (1989-04-01), DeLorme et al.
patent: 4878167 (1989-10-01), Kapulka et al.
patent: 5032979 (1991-07-01), Hecht et al.
patent: 5043866 (1991-08-01), Myre et al.
patent: 5193162 (1993-03-01), Bordsen et al.
patent: 5253361 (1993-10-01), Thurman et al.
patent: 5280612 (1994-01-01), Lorie et al.
patent: 5381545 (1995-01-01), Baker et al.
patent: 5404508 (1995-04-01), Konrad et al.

Affiliated with

Also associated with

Rating

Method and apparatus for audit trail logging and data base recov does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for audit trail logging and data base recov, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for audit trail logging and data base recov will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1509478