4.1.04. Desirable properties of transactions
ACID test
- Atomicity
- transaction as smallest unit of processing
- transactions complete entirely or not at all
- consequences of partial completion in flight example
- Consistency
- complete execution preserves database constrained state/integrity
- e.g. Should a transaction create an entity with a foreign key then the reference entity must exist (see 4 constraints)