ACID
Transaction reliability acronym
In computing, ACID is an acronym for Atomicity, Consistency, Isolation, and Durability—the four properties that guarantee reliable database transactions.
A transaction is ACID-compliant when it either completes entirely or fails without partial effects, maintaining data integrity even during system crashes.
The database engine ensures ACID compliance for financial transactions. (Lowercase acid is a chemical substance or slang for LSD.)
database
Atoms in a molecule
- consistencyReliable adherence to standards
- isolationComplete separation from others
- durabilityResistance to wear
- transactionExchange of goods/money
compliant · compliance · relational · commit · rollback · integrity · concurrent · reliable
atomicity
Atoms in a molecule
- consistencyReliable adherence to standards
- isolationComplete separation from others
- durabilityResistance to wear
transaction · compliant · compliance · relational · commit · rollback · integrity · concurrent · reliable · guarantee
- databasesSQL, table, databases, database, tables
- SQLAND, OR, ON, ALL, insert
- data integrityconsistency, accuracy, completeness, validity, constraint
- database transactionscommit, rollback, begin, end, atomicity
- transactionspayment, purchase, deposit, transfer, money transfer
- concurrencythreads, deadlock, semaphore, atomic, race condition
- acid testConclusive quality evaluation
- omega-3 fatty acidPolyunsaturated dietary lipid
- acid refluxStomach contents reversing course
- battery acidElectrolyte in power cells
- stomach acidDigestive fluid in belly
- lead-acid batteriesRechargeable electrochemical storage cells