🎁 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

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.
PostgreSQL
An advanced open-source relational database known for its reliability, feature richness, and standards compliance.
CTE (Common Table Expression)
A temporary named result set defined within a SQL statement using the WITH clause, improving query readability and enabling recursion.
Redis
An open-source, in-memory data store used as a database, cache, message broker, and queue with sub-millisecond response times.
Database Index Types
Different index structures (B-tree, Hash, GIN, GiST, BRIN) optimized for various query patterns and data types.
Trigger
A database object that automatically executes a specified function when certain events (INSERT, UPDATE, DELETE) occur on a table.
 View All Databases Terms →