Section: IT & Technology · DatabasesDifficulty: Medium

ACID Properties

USUK

Atomicity, Consistency, Isolation, Durability — four properties ensuring reliable database transactions.

Also: ACID properties

Definition

ACID is an acronym for four properties that guarantee database transactions are processed reliably: Atomicity (a transaction is all-or-nothing), Consistency (transactions bring the database from one valid state to another), Isolation (concurrent transactions execute as if they were sequential), and Durability (committed transactions persist even after system failures). ACID compliance is fundamental to relational databases and critical for applications requiring data integrity, such as banking and financial systems.

Example

When you transfer money between bank accounts, ACID ensures either both the debit and credit succeed, or neither does — preventing money from disappearing mid-transaction.

Synonyms

  • transaction guarantees
  • database reliability properties
  • ACID compliance

Antonyms / Opposites

  • eventual consistency
  • BASE properties

Images

CC-licensed · free to use
More on Wikimedia
Loading images…

Video

  • sql
  • transaction
  • database
  • cap-theorem

Dictionary Entry

Back to IT & Technology