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)