Tuesday, September 2, 2008

ACID rule

1. Atomic - Transaction is one unit of work and does not dependent on previous and next transactions.

2. Consistent - Data is either committed or roll backed, no transaction should be in middle state like some data is committed and some are not.

3. Isolated - No transaction sees the intermediate results of the current transaction i.e one transaction which is in its middle process should not be referenced by another transaction.

4. Durable - The values should persist if the data had been committed even the system crashes right after that transaction.

No comments: