Monday, June 06, 2005

ACID rules for transactions

  • Transaction must be Atomic (it is one unit of work and does not dependent on previous and following transactions)
  • Consistent (data is either committed or roll back, no “in-between” case where something has been updated and something hasn’t)
  • Isolated (no transaction sees the intermediate results of the current transaction)
  • Durable (the values persist if the data had been committed even if the system crashes right after).