What is atomicity?
A transaction is an ordered set of state-changing actions
- Eg: customerAcct -= $5, merchantAcct += $5
Atomicity = “all or nothing”
- Either all actions complete (commit) or none occur (abort)
- DBMS’s typically implement atomicity by undoing all actions (aborting the transaction) if one or more actions cannot complete