Data Property - ACID (atomicity, consistency, isolation, durability)
Table of Contents
1 - About
They defines a concurrency model.
Traditional database (ie non distributed database) follows this rules. In a distributed database, traditional database would be categorize as the AC type of the cap theorem. Conventional databases assume no network partitioning and are not distributed.
2 - Articles Related
3 - ACID rules
Ideally, the software should enforce the ACID rules, summarized here:
- Isolation: Two simultaneous transactions cannot interfere with one another. Intermediate results within a transaction must remain invisible to other transactions. The intermediate state of a series of database operations cannot be seen by other series of database operations.
- Durability: Completed transactions cannot be aborted later or their results discarded. They must persist through (for instance) restarts of the DBMS after crashes. A series of database operations that have committed are guaranteed to survive permanently.
4 - Weaker concurrency model
In practice, many DBMSs allow the selective relaxation of most of these rules — for better performance or on a distributed system