What are ACID Rules of transaction in a database? Atomicity, Consistency, Isolation, Durability
The ACID rules of transaction in any database assure the reliability of data in all transactions in the database.
Atomicity - this rule states that either the complete transaction takes place, or none. Even if a part of a transaction fails to work, the complete transaction will fail.
Consistency - this rule ensures that the database is stable, before and after the transaction, even if a transaction fails.
Isolation - this rule states that when a process is going on in a transaction, the data remains in isolation of other entities in the database.
Durability - this rule states that when a transaction completes successfully, it remains in stable state and is persisted in the database.
No comments:
Post a Comment