[prev] 58 [next]

Transaction Anomalies

What problems can occur with uncontrolled concurrent transactions?

The set of phenomena can be characterised broadly under:

  • dirty read:
    reading data item currently in use by another tx
  • nonrepeateable read:
    re-reading data item, since changed by another tx
  • phantom read:
    re-reading result set, since changed by another tx