Pre-image logging for database recovery

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...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: KODAVALLA HANUMANTHA R, ZWILLING MICHAEL J
Format: Patent
Sprache:eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung: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.