🎁 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

Graph Database
A database that uses graph structures with nodes, edges, and properties to store and query highly connected data.
Trigger
A database object that automatically executes a specified function when certain events (INSERT, UPDATE, DELETE) occur on a table.
CTE (Common Table Expression)
A temporary named result set defined within a SQL statement using the WITH clause, improving query readability and enabling recursion.
JOIN
An SQL operation that combines rows from two or more tables based on a related column between them.
Cursor
A database object that enables row-by-row processing of query results, useful for operations that cannot be done in bulk.
Stored Procedure
A precompiled collection of SQL statements stored in the database that can be executed as a single unit.
 View All Databases Terms →