What are properties of a transaction(ACID)?
ACID stands for atomicity, consistency, isolation, and durability.
These all process done during the Sql transaction.
Atomicity:
Atomicity means the entire transaction must complete.A transaction consists of many steps. When all the steps in a transaction gets completed, it will get reflected in DB or if any step fails, all the transactions are rolled back.
Consistency:
These rules may be broken during the time of a transaction. The database will move from one consistent state to another, if the transaction succeeds and remain in the original state, if the transaction fails.
Isolation:
Every transaction should operate as if it is the only transaction in the system.
It means No views into components of uncommitted transactions.
Durability:
Once a transaction has completed successfully, the updated rows/records must be available for all other transactions on a permanent basis.
Post a Comment