ACID Properties – DBMS Transaction

ACID Properties are considered to be the desirable properties of any transactions.When in a database system more than one transaction are being executed simultaneously and in parallel then system maintains the below properties in order to ensure the data accuracy and integrity.

A-Atomicity
if something unexpected happens in the middle of the transaction, then it should be completely undone so that the system will go back to it previous known good state. If the transaction is successful, then it must be committed , so that the system will go to the new state.

C-Consistency
Ensures the system is in a consistent stage,even though the transaction is committed or rolled back completely.

I-Isolation
Isolation makes sure that the data that are being manipulated are isolated, so that no other transactions / processes can manipulate them while it is modified by another transaction.

D-Durability
Durability indicates that, once the transaction is committed, it is guaranteed to be permanent.

Leave a Reply

Your email address will not be published. Required fields are marked *