DEV Community

Tharani Tharan
Tharani Tharan

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)