What is ACID In Database?

ACID Definition(Taken from Wikipedia)

In computer science, ACID (Atomicity, Consistency, Isolation, Durability) is a set of properties that guarantee that database transactions are processed reliably. In the context of databases, a single logical operation on the data is called a transaction. For example, a transfer of funds from one bank account to another, even involving multiple changes such as debiting one account and crediting another, is a single transaction.

ACID (an acronym for Atomicity Consistency Isolation Durability) is a concept that Database Professionals generally look for when evaluating databases and application architectures. For a reliable database all this four attributes should be achieved.

Atomicity: It is an all-or-none proposition.

Consistency:  It guarantees that a transaction never leaves your database in a half-finished state.

Isolation: It keeps transactions separated from each other until they’re finished.

Durability: It guarantees that the database will keep track of pending changes in such a way that the server can recover from an abnormal termination.