Skip to main content

Atomicity

  • Reference work entry
  • First Online:
  • 26 Accesses

Definition

The atomicity of actions on a database is a fundamental guarantee that database systems provide to application programs. Whatever state modifications an atomic action may perform are guaranteed to be executed in an all-or-nothing manner: either all state changes caused by the action will be installed in the database or none. This property is important in the potential presence of failures that could interrupt the atomic action. The database system prepares itself for this case by logging state modifications and providing automated recovery as part of the failure handling or system restart. These implementation aspects are transparent to the application program and are thus a major relief for the programs’ failure handling and boost the application development productivity.

Historical Background

Since the early 1970s (or even earlier), transaction processing systems for airline reservations and debit/credit banking had means for recovery and concurrency control that were...

This is a preview of subscription content, log in via an institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   4,499.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book
USD   6,499.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Recommended Reading

  1. Barga RS, Lomet DB, Shegalov G, Weikum G. Recovery guarantees for internet applications. ACM Trans Internet Technol. 2004;4(3):289–328.

    Article  Google Scholar 

  2. Bernstein PA, Hadzilacos V, Goodman N. Concurrency control and recovery in database systems. Reading: Addison-Wesley, MS; 1987.

    Google Scholar 

  3. Bjork LA. Recovery scenario for a DB/DC system. In: Proceedings of the ACM Annual Conference; 1973. p. 142–6.

    Google Scholar 

  4. Davies CT. Recovery semantics for a DB/DC system. In: Proceedings of 1st ACM Annual Conference; 1973. p. 136–41.

    Google Scholar 

  5. Elmagarmid AK, editor. Database transaction models for advanced applications. San Fransisco: Morgan Kaufmann; 1992.

    Google Scholar 

  6. Eswaran KP, Gray J, Lorie RA, Traiger IL. The notions of consistency and predicate locks in a database system. Commun ACM. 1976;19(11):624–33.

    Article  MathSciNet  MATH  Google Scholar 

  7. Gray J. Notes on database operating systems. In: Operating systems – an advanced course. London: Springer; 1978.

    Google Scholar 

  8. Gray J, Reuter A. Transaction processing: concepts and techniques. San Fransisco: Morgan Kaufmann; 1993.

    MATH  Google Scholar 

  9. Jajodia S, Kerschberg L, editors. Advanced transaction models and architectures. Noewell: Kluwer; 1997.

    MATH  Google Scholar 

  10. Jones CB, Lomet DB, Romanovsky AB, Weikum G, Fekete A, Gaudel M-C, Korth HF, Rogério de Lemos J, Moss EB, Rajwar R, Ramamritham K, Randell B, Rodrigues L. The atomic manifesto: a story in four quarks. ACM SIGMOD Rec. 2005;34(1):63–9.

    Article  Google Scholar 

  11. Lampson B. Atomic transactions. In: Distributed systems – \architecture and implementation. New York: Springer; 1981.

    Chapter  Google Scholar 

  12. Lomet DB. Process structuring, synchronization, and recovery using atomic actions. In: Proceedings of the ACM Conference on Language Design for Reliable Software; 1977. p. 128–37.

    Google Scholar 

  13. Randell B. System structure for software fault-tolerance. IEEE Trans Softw Eng. 1975;1(2):221–32.

    MathSciNet  Google Scholar 

  14. Weikum G, Vossen G. Transactional information systems: theory, algorithms, and the practice of concurrency control and recovery. San Fransisco: Morgan Kaufmann; 2002.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Gerhard Weikum .

Editor information

Editors and Affiliations

Section Editor information

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer Science+Business Media, LLC, part of Springer Nature

About this entry

Check for updates. Verify currency and authenticity via CrossMark

Cite this entry

Weikum, G. (2018). Atomicity. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_28

Download citation

Publish with us

Policies and ethics