Nathan S. answered • 06/07/21
Tutor with a over a decade of IT experience
The ACID model, Atomicity, Consistency, Isolation, and Durability, is a set of properties that help guarantee the integrity of data that is accessed and updated through database transactions.
Atomicity deals with an "all or nothing" concept of transactions. All of the functions or steps of a transaction must successfully complete for the transaction to be successful. If any part of the transaction fails, then the whole transaction has failed.
Consistency ensures that only valid data is written and committed to the database. If the transaction fails, then the database must rollback or back out the uncommitted changes.
Isolation makes sure that multiple transactions aren't operating on the same data concurrently and that transactions don't interfere with one another.
Durability means that any committed data from a transaction will not be lost.
