Pre-image logging for database recovery

Details Pre-image logging for database recovery Pre-image logging for database recovery

2005-06-30

2009-11-17

Alam, Hosain T (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07620660

ABSTRACT:
In order to provide recovery for a database stored on storage not meeting the WAL protocol requirements, for example, storage including a temporary cache and a second storage (e.g. an IDE disk with a temporary cache and a hard disk), a log is created including, for each changed page, a pre-image of the page before changes were effected. The log also includes one or more change log records logging changes made to the page. Periodic checkpoints occur in which the cached pages are flushed to the disk. Recovery proceeds with a redo pass through the active log and then with an undo pass, undoing any transactions that have not been committed.

REFERENCES:
patent: 5832508 (1998-11-01), Sherman et al.
patent: 6173292 (2001-01-01), Barber et al.
patent: 6651077 (2003-11-01), East et al.
patent: 7107292 (2006-09-01), Hrle et al.
patent: 2002/0091718 (2002-07-01), Bohannon et al.
patent: 2006/0129611 (2006-06-01), Adkins et al.
patent: 2008/0005191 (2008-01-01), Lashley et al.
Mohan, C. et al., ARIES: A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbakcs Using Write-Ahead Logging,ACM Transactions on Database Systems, 1992, 17(1), 94-162.

Affiliated with

Also associated with

Rating

Pre-image logging for database recovery does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Pre-image logging for database recovery, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Pre-image logging for database recovery will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4088849