Tuesday, 23 August 2011

ACID properties of databases

ACID stands for
     Atomicity
    Consistency
    Isolation
    Durability


Atomicity
Modification on the data in the database either fail or succeed. The beginning of such a modification starts with a transaction and ends when a transaction finishes (either by a commit or a rollback). A software crash entails an implicit rollback.

Consistency
Only valid data (valid according to integrity constraints) may be commited.

Isolation
One transaction does not interfere with another. The 'executor' of a transaction has the feeling that he has the entire database for himeself.

Durablity
A commited transaction will not be lost.