ACID Lab
ACID Properties
Interactive workbench for database transaction properties.
schoolWhat is ACID?
ACID stands for Atomicity, Consistency, Isolation, and Durability. These are the four key properties that guarantee database transactions are processed reliably. Think of them as the "rules" that keep your data safe when multiple operations happen at once. Click on any card below to explore each property with interactive simulations!
Atomicity
All or nothing. Ensures that all operations within a work unit are completed successfully; otherwise, the transaction is aborted.
Consistency
Valid data only. Ensures that the database properly changes states upon a successfully committed transaction, maintaining invariants.
Isolation
Independent execution. Enables transactions to operate independently of and transparently to each other to prevent concurrency issues.
Durability
Forever saved. Ensures that the result or effect of a committed transaction persists in case of a system failure or crash.