|< < 21 > >|

Overview of Database System Implementation

Commit processing

Goals

Just before the commit:

  • Updates made by the transaction are private (not visible to anyone else).
  • Not durable: Crash before commit loses the updates.

Just after the commit:

  • Updates are all visible. There is no possibility of anyone seeing only some of the updates.
  • The updates are durable. A crash even 1 microsec after the commit will not lose the updates. (cf. MongoDB)

|< < 21 > >|