---
title: "what is ACID property in dbms ?"  
description: "what is ACID property in dbms ?"  
author: "Sanat Shukla"  
published: 2018-09-03  
canonical: https://answers.mindstick.com/qa/49600/what-is-acid-property-in-dbms  
category: "technology"  
tags: ["mysql", "database", "database design"]  
reading_time: 2 minutes  

---

# what is ACID property in dbms ?

## Answers

### Answer by Sangsaptak Pal

A [transaction](https://www.mindstick.com/blog/11670/transactions-and-injections-in-sqlite) is a single logical [unit of work](https://www.mindstick.com/articles/13071/generic-repository-pattern-with-unit-of-work-uow). It accesses and generally modifies the contents of a [database](https://www.mindstick.com/articles/100/windows-service-to-update-record-from-one-database-to-another-after-certain-interval-of-time). [Transactions](https://www.mindstick.com/interview/307/explain-acid-rule-of-thumb-for-transactions) access data using READ and WRITE [operations](https://www.mindstick.com/blog/304985/how-does-devops-bridge-the-gap-between-development-and-operations-teams-like-git).

In order to maintain consistency in a database, before and after the transaction, certain properties need to be followed. These properties are called [ACID properties](https://www.mindstick.com/articles/338513/acid-properties-in-database-transactions).

ACID is the short form for **A**tomicity **C**onsistency **I**solation **D**urability. More on this can be found out from the image below:

![what is ACID property in dbms ?](https://media.geeksforgeeks.org/wp-content/cdn-uploads/20191121102921/ACID-Properties.jpg)

Atomicity : By this it is meant that either the entire operation transaction takes place or no transaction takes place at all. It basically involves two operations :

- Abort : If for any reason, the transaction is aborted, the changes made to the database is not visible.
- Commit : If the transaction happens successfully, the changes are visible.

Atomicity is often [referred to as](https://answers.mindstick.com/qa/39930/at-the-turn-of-the-century-widespread-panic-occurred-that-at-midnight-all-computers-would-reset-to-zero-and-life-as-we-knew-it-would-cease-to-exist-what-was-this-doomsday-theory-commonly-referred-to-as) the "All or Nothing Rule".

Consistency : It means that the integrity constraints of the database must be preserved. It is to make sure that the database is consistent both before and after the transaction. It refers to the correctness of the database.

Isolation : This [property](https://www.mindstick.com/blog/205/property-notification-in-c-sharp) ensures that [multiple](https://www.mindstick.com/forum/2323/handling-multiple-submit-button-in-asp-dot-net-mvc) transactions can occur simultaneously without the database state being inconsistent. In other words, it takes care that that the transactions occur independently without interference.

Durability : As the name suggests, this property ensures that once the transaction has completed [execution](https://www.mindstick.com/blog/178/synchronous-and-asynchronous-command-execution-in-c-sharp-dot-net), the updates and modifications to the database are stored in and written to disk and they persist even if a system failure occurs. These updates now become permanent and are stored in the non-volatile memory. The effects of the transaction, thus, are never lost.


---

Original Source: https://answers.mindstick.com/qa/49600/what-is-acid-property-in-dbms

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.