Answer to Question #246153 in Databases | SQL | Oracle | MS Access for Michael Sampson

Question

Explain the concept of ACID properties in DBMS in your own words?

Answer 1

When we wants to maintain the consistency in the database, before and after the transaction, then we used to follow some special type of characteristics, that is called as the ACID properties.

The term ACID in the DBMS is as below -

A - Atomicity

C - Consistency

I - Isolation

D - Durability

Atomicity: When we are doing any transaction in database then it ensures that the transaction will be atomic means one transaction can not be repeated or it exists only and only one time. It means transaction either will be successful or it will be aborted. So, there are two primary operations in this, that is Abort and Commit.

Consistency:

It means the integrity constraint must be maintained so that the database is consistent before and after the transaction. It relates the correctness in the database.

Isolation:

It ensures that the multiple the multiple transaction occur concurrently without leading to inconsistency in the database. The transaction occur independently without the interference.

Durability:

It ensures that once the transaction the transaction has completed the execution, the updates and the modification in the database are stored in and written in the disk even disk may crash, but it will not chane.