What is ACID property in database?
ACID property is used to ensure that the data transactions are processed reliably in a database system.
A single logical operation of a data is called transaction. ACID is an acronym for Atomicity, Consistency, Isolation, Durability. Atomicity: it requires that each transaction is all or nothing. It means if one part of the transaction fails, the entire transaction fails and the database state is left unchanged. Consistency: the consistency property ensure that the data must meet all validation rules. In simple words you can say that your transaction never leaves your database without completing its state. Isolation: this property ensure that the concurrent property of execution should not be met. The main goal of providing isolation is concurrency control. Durability: durability simply means that once a transaction has been committed, it will remain so, come what may even power loss, crashes or errors. |
All times are GMT -7. The time now is 12:33 AM. |
Powered by vBulletin Copyright © 2020 vBulletin Solutions, Inc.