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,… Read more“ACID Properties – DBMS Transaction”