[prev] 52 [next]

Logging

Three "styles" of logging
  • undo ... removes changes by any uncommitted tx's
  • redo ... repeats changes by any committed tx's
  • undo/redo ... combines aspects of both
All approaches require:
  • a sequential file of log records
  • each log record describes a change to a data item
  • log records are written first
  • actual changes to data are written later
Known as write-ahead logging