ACID properties in SQL (Atomicity, Consistency, Isolation, Durability)
ACID(Atomicity, Consistency, Isolation, Durability) Property is the most important part of the database.
ACID stands for Atomicity, Consistency, Isolation and Durability.
Atomicity – Atomicity means that “all or nothing transaction”.All the operations in the transaction must be complete. if any one of the operation fails then all the transactions must be rolled back.
There is no midway means transactions do not occur partially.
Consistency: – Consistency guarantees that a transaction never leaves your database in a partially-finished state. If anything happens in the middle of the transaction, this property will never leave your database in half-completed state. If the database transaction is completed successfully then it will apply all the changes in the database.
Isolation: – Isolation keeps the transactions independent from each other until the transactions are finished. In Isolation Every transactionis individual and no one transaction interferes to another transaction.
Durability: – Durability property ensures that once the transaction has been completed, then all the updates and modifications in the database are stored and written to disk and they persist permanently even if a system failure occurs.