Properties of a Transaction (ACID)?

The essential properties of a transaction are commonly termed as ACID, an abbreviation that can be expended as follows:

A          Atomicity

C          Consistency

I           Isolation

D          Durability

ATOMICITY: Atomicity means that the effect of the transaction it either full or null. It is assumed that a system always starts from a consistent state and moves to another consistent state after executing a complete transaction.

CONSISTENCY: Consistency means that a transaction should generate consistent data defined by application logic and inconsistency should not be generated due to the nature of the system, such as job scheduling or slow disk I/O.

ISOLATION: Isolation indicates the level of interference in one transaction due to the other transaction. A strict isolation level is the basic condition for executing of a transaction as if it is lonely executed.

DURABILITY: The effect of a transaction should be durable, irrespective if the nature of storage, such as volatile, nonvolatile memory.