ACID (n)~ The four essential properties of an electronic transaction. Atomicity requires
that a transaction be fully completed or else fully canceled. Consistency requires that
resources used are transformed from one consistent state to another. Isolation requires all
transactions to be independent of each other. Durability requires that the completed
transaction be permanent, including survival through system failure
The four essential properties of a reliable database transaction:
-
Atomicity
A transaction must be all or nothing. If any part of the transaction fails, the entire transaction is rolled back, leaving the system unchanged. -
Consistency
A transaction must transform the system from one valid state to another, maintaining data integrity and abiding by all defined rules, constraints, and triggers. -
Isolation
Transactions must operate independently of one another. Intermediate states of a transaction are invisible to other concurrent transactions, preventing conflicts or inconsistencies. -
Durability
Once a transaction is committed, its changes are permanent, even in the case of a power failure, crash, or other system error.