What
are ACID Properties in DBMS?
The full meaning of the acronym ACID is
Atomicity, Consistency, Isolation, and Durability.
Atomicity: This property states that a transaction must be treated as an atomic
unit, that is, either all of its operations are executed or none, so that there must be
no state in a database where a transaction is left partially completed.
Consistency: The database must remain in a consistent state after any transaction, so that no transaction should have any adverse effect on the data residing in the
database.
Durability: The database should be durable enough to hold all its latest updates
even if the system fails or restarts, so that if a transaction updates a chunk of data
in a database and commits, then the database will hold the modified data.
Isolation: In a database system where more than one transaction are being
executed simultaneously and in parallel, isolation states that
all the transactions will be carried out and executed as if it is the only
transaction in the system, so that no transaction will affect the existence of any
other transaction.
No comments:
Post a comment