DEV Community

Cover image for ACID Properties in DBMS
DEEPAK KUMAR B 24CB007
DEEPAK KUMAR B 24CB007

Posted on

ACID Properties in DBMS

Databases power almost every application we use daily—from banking systems to e-commerce platforms. To ensure data remains reliable, databases follow the ACID principles: Atomicity, Consistency, Isolation, and Durability.

Setup the Schema
We’ll create a Loans table that stores customer loan detail

Enter the values

Result

ATOMICITY
All operations in a transaction must succeed or none should.

Update and roll back

Consistency

Transactions must bring the database from one valid state to another. Invalid data should not enter the system.

Alter

Isolation

Concurrent transactions should not affect each other’s intermediate results.

Isolation prevents dirty reads between transactions.

Durability

Atomicity → All or nothing.
Consistency→ Data always valid.
Isolation → Transactions don’t interfere.
Durability→ Data persists after commit.
By applying ACID principles, databases remain reliable, fault-tolerant, and consistent even in high-concurrency environments like banking systems.

Top comments (0)