Search content within the blog

Friday, August 6, 2010

ACID properties

The ACID Properties are explained below,

Atomic: All updates within the transaction are successful, or they’re all rolled back. No partial updates are allowed. For instance, in a bank transfer, if the debit succeeds but the credit fails, the debit is rolled back so money isn’t created or lost.

Consistent : After the operation, all data is valid according to the business rules. For instance, in a bank transfer, the To and From accounts must be valid accounts or the transaction will abort.

Isolated :While the operation is executing, no partial results are visible outside the transactions. For instance, as a bank transfer is being executed, other users will not see the balances part way through the
transfer.

Durable : After the transaction is committed, the data must be persisted in a way that can survive system failures.

No comments:

Post a Comment