Glossary · Database

ACID

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

ACID is an acronym for the four key properties of database transactions: Atomicity (each transaction is all-or-nothing–if any part fails, the entire transaction is rolled back), Consistency (a transaction brings the database from one valid state to another, maintaining all defined rules and constraints), Isolation (concurrent transactions execute as if they were sequential, preventing interference), and Durability (once a transaction is committed, it persists even in the event of system failure). ACID compliance is a fundamental requirement for financial systems, inventory management, and any application where data correctness is critical.

Fig — every answer ships with the tables, rows and SQL behind it.