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
|