Home  >  Forum  >  Database
Post New Query

Define ACID Database Properties

joined on
March 22,2015
Asked on July 30,2015
Define ACID database properties in short but clear.
joined on
August 11,2014
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

Copyright ©2017 concretepage.com, all rights reserved |Privacy Policy | Contact Us