🎁 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

Full-Text Search
A technique for searching natural language text in databases using word stemming, ranking, and relevance scoring.
Redis
An open-source, in-memory data store used as a database, cache, message broker, and queue with sub-millisecond response times.
Transaction
A sequence of database operations that are treated as a single unit — either all succeed or all are rolled back.
Upsert
A database operation that inserts a new row if it does not exist, or updates the existing row if it does.
Connection Pool
A cache of database connections that can be reused, avoiding the overhead of creating new connections for each request.
Write-Ahead Log (WAL)
A technique where changes are first written to a log before being applied to the database, ensuring crash recovery and data integrity.
 View All Databases Terms →