[prev] 14 [next]

Transactions and Buffer Pool (cont)

Handling no forcing:
  • transaction T makes changes & commits, then system crashes
  • but what if modified page P has not yet been output?
  • must log values changed by T in P as soon as they change
  • use these to support REDO to restore changes

Above scenario may be a problem, even if we are forcing
  • e.g. system crashes immediately after requesting a WRITE()