Brain Dump

ACID

Tags
sys-design

Refers to a core aspect of DBMS.

TermMeaning
AtomicPart of transaction failing => all transaction fails.
ConsistentEach transaction moves from a valid state to another valid state. Can't currupt db.
IsolatedTransactions are consistent regardless of the order in which their run.
DurableData persists on the disk.

Note: Grouping multiple transactions and running them concurrently has the same affect as running each transaction independently.