What are ACID properties?

ACID properties

The acronym ACID stands for Atomicity, Consistency, Isolation and Durability. These are group of properties that every DBMS must satisfy. Any database is said to be reliable, if it meets all these properties. Otherwise, we consider that DBMS as not reliable.

Atomicity:

All the operations in a transaction will be completed or will not be executed at all.

Consistency:

It ensures that by the end of a transaction, the system will be in a valid state. That means only valid data will be committed.

Isolation:

It ensures that, transactions are processed without interference. That means, one transaction cannot read the data from another transaction until it executes completely.

Durability:

It ensures that a transaction which was committed to the database will be permanent.

For more information about ACID properties, Click here

Latest Comments
  1. google acquisition rumors

    What’s Going down i’m new to this, I stumbled upon this I
    have found It absolutely helpful and it has aided me
    out loads. I hope to contribute & assist other customers like
    its helped me. Good job.

  2. create gmail account for kids

    WOW just what I was looking for. Came here by searching for carrie underwood

Leave a Reply

Your email address will not be published. Required fields are marked *