What is the concept of ACID properties in DBMS ?

ACID stands for Atomicity, Consisency, Isolation, and Durbility property. Multiple users can share data in a safe and secure way using these properties.

 Atomicity:

  • Atomicity is based on the principle of “either all or nothing” which means that if any updates  happens inside the database then that updates should be available for others beyond user and application.
  • If any updates happens inside the database then that updates should not be available for others beyond user and application.

Consistency:

  • Inside a database before or after any transaction takes place this ensures that consistency is maintained.

Isolation:

  • This property states that happens in isolation with other which means that any transactions that has started but not yet completed should be in isolation with others so that the other transactions are not affected by this transaction.

Durability:

  • This property states that the data should always be in a durable state i.e. any data which is in the committed state should be available in the same state even if any failure or restart occurs in the system

Transaction States in DBMS

Leave a Reply

Your email address will not be published.

You May Also Like

What is ER Model in DBMS ?

ER stands for Entity-Relationship model. It is a high level data model. If any data elements or relationship of any specified system can defined using this model. Conceptual design for…
View Answer