Atomicity is a desired property of a transaction according to ACID

  • a transaction should be either executed completely - or not executed at all
  • If it executed - it takes database from one consistent state to another
  • if not executed - it takes database back to the consistent state it was before execution
  • It's especially important when dealing with Crash Recovery

Ways to ensure Atomicity: