[prev] 3 [next]

Durability

What kinds of "system failures" do we need to deal with?
  • single-bit inversion during transfer mem-to-disk
  • decay of storage medium on disk (some data changed)
  • failure of entire disk device (data no longer accessible)
  • failure of DBMS processes (e.g. postgres crashes)
  • operating system crash; power failure to computer room
  • complete destruction of computer system running DBMS

The last requires off-site backup; all others should be locally recoverable.