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
|