ACID
Sep 5, 2018 · 1 min read
A transaction, in any domain, whether a database or not, needs to comply with four properties, collectively
known as ACID:
➤➤ Atomic —
The contents of the transaction are done as a whole, or not at all. It is not possibleto view the database in a state where only half of the transaction is applied.
➤➤ Consistent —
After the transaction, the database meets all the requirements for your domain. For instance, when making a payment between two parties, the amount debited from one party should match the amount credited to the other.➤➤ Isolated —
Transactions running in parallel should each behave as though they are the only transaction running on the database.➤➤ Durable —
Once the transaction has been committed, it is committed permanently. Any subsequent database change, such as an update or a crash, will have no effect on the committed transaction.