February 11, 2001

Acid test for transaction

The acid test for transaction validity

Atomic : all or none of the transaction must be executed
Consistent: any discrete step within the transaction must not be left in an inconsistent state when the transaction is completed, regardless of its success or failure.
Isolated: the intermediate states must not be visible to other transactions.
Durable: the results of the successful transactions must be stored in the permanent or durable medium.