ACID Transaction Guarantee
Distinguish between the two database models ACID and BASE.
We'll cover the following...
Introduction
ACID is an acronym for Atomicity, Consistency, Isolation, and Durability. These are the properties of a database transaction. Therefore, any database that satisfies the above properties while running read and write operations is ACID compliant.
ACID compliant databases favor consistency and integrity of data over persisting incorrect and partial data. Atomicity, isolation, and durability are database-defined guarantees, while consistency is an application-defined guarantee.
Atomicity
An atomicity guarantee ensures the database executes a sequence of operations as one single logical unit of work. Either it completes all the operations successfully or rolls back all the operations. The act of successfully executing all the database operations is a commit, and the act of reverting all the database operations on failure is a rollback.
Atomicity ensures no partial updates in the database, and the application developers can rely on the fact that the database is always in a clean state on failure. Furthermore, this guarantee ensures that the application developers can safely retry after failure without a doubt on duplicate data creation.