Data Atomicity

Data Atomicity: A transaction in commercial database is referred to as atomic unit of work.

For example when you purchase something from a point of sale terminal a number of tasks are performed such as

  • Company stock is updated.
  • Amount is added in company’s account.
  • Sales person’s commission increases etc.

All these tasks collectively are called an atomic unit of work or transaction. These tasks must be completed; otherwise partially completed tasks are rolled back or may be lost or corrupt. Thus through DBMS, it is ensured that only consistent data exists within the database and inconsistent may not be allowed.