ACID Principles


Atomicity, Consistency, Isolation, Durability (ACID) are principles that exist to provide guidance for developing data systems that create complete transactions and reject partial transactions from being recorded.

  • data is validated to ensure completeness
  • typically applies to relational databases

4 Principles

  • Atomicity
    • Atomicity guarantees either all of the transaction succeeds or none of it does
    • all or nothing
    • will not create partial records or transactions
      • if one part of the transaction fails, the whole transaction fails
  • Consistency
    • ensures that all data is consistent
    • data will be valid based on all the defined rules for that data
    • If a field has properties with rules, the transaction will not save until it matches those specified rules
  • Isolation
    • means that all transactions occur isolated from other transactions
    • one transaction can’t be impacted by another
    • a transaction can’t read data from any other transaction that isn’t completed
  • Durability
    • confirms that once a transaction is committed, it will remain in the system