Database Transaction - Purpose

Purpose

Databases and other data stores which treat the integrity of data as paramount often include the ability to handle transactions to maintain the integrity of data. A single transaction consists of one or more independent units of work, each reading and/or writing information to a database or other data store. When this happens it is often important to ensure that all such processing leaves the database or data store in a consistent state.

Examples from double-entry accounting systems often illustrate the concept of transactions. In double-entry accounting every debit requires the recording of an associated credit. If one writes a check for €100 to buy groceries, a transactional double-entry accounting system must record the following two entries to cover the single transaction:

  1. Debit €100 to Groceries Expense Account
  2. Credit €100 to Checking Account

A transactional system would make both entries pass or both entries would fail. By treating the recording of multiple entries as an atomic transactional unit of work the system maintains the integrity of the data recorded. In other words, nobody ends up with a situation in which a debit is recorded but no associated credit is recorded, or vice versa.

Read more about this topic:  Database Transaction

Famous quotes containing the word purpose:

    What if we fail to stop the erosion of cities by automobiles?... In that case America will hardly need to ponder a mystery that has troubled men for millennia: What is the purpose of life? For us, the answer will be clear, established and for all practical purposes indisputable: The purpose of life is to produce and consume automobiles.
    Jane Jacobs (b. 1916)

    War is in truth a disease in which the juices that serve health and maintenance are used for the sole purpose of nourishing something foreign, something at odds with nature.
    Johann Wolfgang Von Goethe (1749–1832)

    Any historian of the literature of the modern age will take virtually for granted the adversary intention, the actually subversive intention, that characterizes modern writing—he will perceive its clear purpose of detaching the reader from the habits of thought and feeling that the larger culture imposes, of giving him a ground and a vantage point from which to judge and condemn, and perhaps revise, the culture that produces him.
    Lionel Trilling (1905–1975)