ACID (Atomicity, Consistency, Isolation, Durability)

ACID (Atomicity, Consistency, Isolation, Durability)

ACID is an acronym that refers to the set of 4 key properties that define a transaction and when a database management system offers ACID guarantees, then the database management system applies these on every transaction performed by the database management system.

The 4 key properties of ACID are:

• Atomicity --> Atomicity ensures that a transaction is executed exactly once and that it

  must be atomic: either all the work is carried out, or no work is carried out at all. Operations within a transaction typically share a common intent and are interdependent

• Consistency --> Consistency ensures that data is consistent both before and after the transaction

• Isolation --> Isolation ensures that one transaction is not affected by another transaction

• Durability --> Durability ensures that changes to the data are permanently stored in the system. Committed data is stored by the system in such a way that even if an error occurs and the system needs to be restarted, it is available in its correct state