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
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsRecommended Reading
Barga RS, Lomet DB, Shegalov G, Weikum G. Recovery guarantees for internet applications. ACM Trans Internet Technol. 2004;4(3):289–328.
Bernstein PA, Hadzilacos V, Goodman N. Concurrency control and recovery in database systems. Reading: Addison-Wesley, MS; 1987.
Bjork LA. Recovery scenario for a DB/DC system. In: Proceedings of the ACM Annual Conference; 1973. p. 142–6.
Davies CT. Recovery semantics for a DB/DC system. In: Proceedings of 1st ACM Annual Conference; 1973. p. 136–41.
Elmagarmid AK, editor. Database transaction models for advanced applications. San Fransisco: Morgan Kaufmann; 1992.
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.
Gray J. Notes on database operating systems. In: Operating systems – an advanced course. London: Springer; 1978.
Gray J, Reuter A. Transaction processing: concepts and techniques. San Fransisco: Morgan Kaufmann; 1993.
Jajodia S, Kerschberg L, editors. Advanced transaction models and architectures. Noewell: Kluwer; 1997.
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.
Lampson B. Atomic transactions. In: Distributed systems – \architecture and implementation. New York: Springer; 1981.
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.
Randell B. System structure for software fault-tolerance. IEEE Trans Softw Eng. 1975;1(2):221–32.
Weikum G, Vossen G. Transactional information systems: theory, algorithms, and the practice of concurrency control and recovery. San Fransisco: Morgan Kaufmann; 2002.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
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
DOI: https://doi.org/10.1007/978-1-4614-8265-9_28
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering