redbookcover.gif (13955 bytes) Readings in Database Systems, 3rd Edition

Stonebraker & Hellerstein, eds.

Other Log-Related State

Transaction Table:

One entry per active Xact.
Contains XID, status (running/commited/aborted), and lastLSN.

Dirty Page Table:

One entry per dirty page in buffer pool.
Contains recLSN -- the LSN of the log record which first caused the page to be dirty.

Previous slide Next slide Back to first slide View graphic version

1998, Joseph M. Hellerstein.  Last modified 08/17/98.
Feedback welcomed.