Showing posts with label dbms. Show all posts
Showing posts with label dbms. Show all posts

Friday, 11 July 2014

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.