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.