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.

Write Answer

©2024 | Privacy Policy | Contact Us