🎁 New User? Get 20% off your first purchase with code NEWUSER20 Register Now →
Menu

Categories

Databases Intermediate

What is ACID?

A set of four properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable database transactions.

ACID properties ensure database reliability. Atomicity means transactions are all-or-nothing. Consistency ensures data moves from one valid state to another. Isolation prevents concurrent transactions from interfering. Durability guarantees committed data survives system failures.

ACID compliance is a key feature of relational databases. NoSQL databases often relax these properties (BASE model: Basically Available, Soft-state, Eventually consistent) for better scalability.

Related Terms

PostgreSQL
An advanced open-source relational database known for its reliability, feature richness, and standards compliance.
Soft Delete
A pattern where records are marked as deleted with a flag or timestamp rather than being physically removed from the database.
Query Optimization
The process of improving database query performance through indexing, query rewriting, and schema design techniques.
Vacuum
A PostgreSQL maintenance operation that reclaims storage from dead tuples and updates statistics for the query planner.
B-Tree Index
The default index type in most databases that organizes data in a balanced tree structure for efficient searching, sorting, and range queries.
Row-Level Security (RLS)
A database feature that restricts which rows a user can access in a table based on security policies.
 View All Databases Terms →