Atomicity  
 
A component of ACID; Atomicity is a property of a unit of work (e.g., a transaction) such that the separate operations of the unit of work are either all performed, or none of them are performed. Simply put, atomicity means "all or nothing".

A transaction that exhibits atomicity is said to be atomic.

In other words, an atomic group of sub-tasks, --no matter how many individual tasks the group is composed of-- will be atomic if all the sub-tasks in the group are handled as a single group-task. The group-task is only completed when all the member tasks are successfully performed. If one or more of the member-tasks are not performed successfully, then the system will left in the same state it would be in if NONE of the member tasks had been performed.

Example: if entering a credit card sale is composed of three distinct steps (1. swipe, 2. key in PIN, 3. accept amount) then the transaction should be performed atomically. That way, if the swipe machine shuts off after the first step (swipe) is complete, the transaction will not be performed at all. Thus, there will be no partially completed transaction in the database tables to deal with.

 
  Consistency     Isolation     Durability
 


Content: © Copyright 2000-2007 Creativyst, Inc. (all rights reserved)

 

index
Record date: 2007.12.21-2108