What is ACID Model ?
ACID stands for Atomicity Consistency Isolation Durability.
Atomicity:
Atom is considered to be smallest particle which cannot be broken into further pieces. Database transaction has to be atomic means either all steps of transaction completes or none of them. There are no partial transactions. If some part of a transaction gets failed, then the entire transaction gets failed.
Atom is considered to be smallest particle which cannot be broken into further pieces. Database transaction has to be atomic means either all steps of transaction completes or none of them. There are no partial transactions. If some part of a transaction gets failed, then the entire transaction gets failed.
Consistency:
A transaction maintains the consistent copy of the data. It maintains both committed as well as uncommitted image of data.
A transaction maintains the consistent copy of the data. It maintains both committed as well as uncommitted image of data.
Isolation:
The effect of a transaction is not visible to other transactions until the transaction is committed. For example, one user updating the test.employee table does not see the uncommitted changes to employee made concurrently by another user.
The effect of a transaction is not visible to other transactions until the transaction is committed. For example, one user updating the test.employee table does not see the uncommitted changes to employee made concurrently by another user.
Durability:
Once the
transaction is successfully completed, then the changes made to the database
will be permanent even if there is a system failure, or any abnormal changes.
i.e. A committed transaction will never be lost.
Thanks for reading this post ! Please comment if you like the post !
Great work bro
ReplyDelete