ACID Properties in DBMS

ACID Properties:

A transaction expects to contain certain properties that says ACID Properties of Transactions. There are four properties of ACID Properties of Transactions:

  • Atomicity
  • Consistency
  • Isolation
  • Durability

ACID Properties in DBMS

Atomicity:

The atomicity of a transaction implies that it will run to completion as an individual unit (atomic unit). At the end of a unit of the transaction either there is no change to the database or the database has been changed consistently. No changes will be reflected in the database in the middle of the execution of an atomic unit of transaction.

Consistency:

Consistency property of a transaction implies that if a database was in the consistent state before the execution of the transaction. Then after the execution of the transaction also, the database will be in a consistent state.

Isolation:

Isolation property of a transaction process implies that actions performed by a database. It will isolate or hide from other transactions or processes until it is either execute or terminate. This property gives the transaction a measure of relative independence.

Durability:

Durability property of a database transaction implies that the updates made by a transaction. It will reflect in the database on the termination of committed action. Therefore, any loss or failure after the committed action will not cause loss of updates made by the transaction. Rollback of the transaction can’t be performed, if the transaction has Durability property.