ACID Properties

ACID properties refer to properties a database transaction must follow in order to maintain consistency in a database. Those properties are as follows:

  • Atomicity: The entire transaction must occur, or none of it does. There are no partial transactions.
  • Consistency: The database must remain consistent before and after the transaction.
  • Isolation: Transactions are independent of one another, and do not interfere with each other.
  • Durability: A transaction, once completed, is permanent and persists even if a system failure occurs.

Contributors

Interested in helping build Docs? Read the Contribution Guide or share your thoughts in this feedback form.

Learn More on Codecademy