Define ACID Database Properties
Asked on July 30, 2015
Define ACID database properties in short but clear.
Replied on July 30, 2015
A- ATOMIC : Atomic transactions are either completely get success or completely failed.
C- CONSISTENCY : Data is inserted obeying the constrains applied on the database tables strictly.
I- ISOLATION : If more than one transaction need to happen concurrently, they are executed without affecting other transaction execution. It can be in an order but order can not be predicted.
D- DURABILITY : Once transaction is executed completely data is saved even after crash or power failure.
A database must follow ACID property.