This is a quick refresher on the acid properties of database system.
ACID stands for:
Atomicity
Consistency
Isolation
Durability
Let’s go over each one in detail.
ATOMICITY
This ensures that if a database transaction fails or one of its queries fails, then the whole transaction should fail and the database will be reverted to its previous state.
CONSISTENCY
This ensures that a database is in a valid state after a given transaction as per the constraints enabled in the database table.
ISOLATION
This ensures that concurrent transactions will result in the same results in the database if the same set of transactions were executed sequentially.
DURABILITY
This ensures that once a transaction has been committed to the database successfully, it will always be available irrespective of a catastrophic event such as a power cut or network failure.
