[prev] 46 [next]

Transaction Anomalies

What problems can occur with (uncontrolled) concurrent tx's?

The set of phenomena can be characterised broadly under:

  • dirty read:
    reading data item written by a concurrent uncommitted tx
  • nonrepeateable read:
    re-reading data item, since changed by another concurrent tx
  • phantom read:
    re-scanning result set, finding it changed by another tx