Creating Understanding and Educating Programmers, Developers and Technical Communities, one post at a time.

Monday, June 22, 2009

ACID Properties

To ensure integrity of the data, we require that the database system maintain the following properties of the transactions(these properties are also called ACID properties of a transaction.)

Atomicity: Either all operations of the transaction are reflected properly in the database, or none are.

Consistency Execution of a transaction in isolation (that is, with no other transaction executing concurrently) preserves the consistency of the database.

Isolation Even though multiple transactions may execute concurrently. Each transaction is unaware of other transactions executing concurrently in the system.

Durability After a transactions completes successfully, the changes it has made to the database persist, even if there are system failures.

1 comment: