🎁 New User? Get 20% off your first purchase with code NEWUSER20 · ⚡ Instant download · 🔒 Secure checkout 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

Schema
The structure definition of a database including tables, columns, data types, relationships, indexes, and constraints.
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.
SQL
Structured Query Language — the standard language for managing and querying data in relational databases.
JSONB
PostgreSQL's binary JSON data type that stores JSON documents with indexing, querying, and manipulation capabilities.
MVCC (Multi-Version Concurrency Control)
A technique where the database maintains multiple versions of data to allow concurrent reads and writes without locking.
 View All Databases Terms →