Database transaction

A database transaction symbolizes a unit of work, performed within a database management system (or similar system) against a database, that is treated in a coherent and reliable way independent of other transactions .

Uses your system voice; voice and rate in settings.

≈ 7 min read

Cite, export and learn8 citation formats · 8 exports · lesson and quiz

Names in other languages

No names in other languages are held for this entry yet.

Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.

A database transaction symbolizes a unit of work, performed within a database management system (or similar system) against a database, that is treated in a coherent and reliable way independent of other transactions[1]. A transaction generally represents any change in a database. Transactions in a database environment have two main purposes:

  1. To provide reliable units of work that allow correct recovery from failures and keep a database consistent even in cases of system failure. For example: when execution prematurely and unexpectedly stops (completely or partially) in which case many operations upon a database remain uncompleted, with unclear status.
  2. To provide isolation between programs accessing a database concurrently. If this isolation is not provided, the programs' outcomes are possibly erroneous.

In a database management system, a transaction is a single unit of logic or work, sometimes made up of multiple operations. Any logical calculation done in a consistent mode in a database is known as a transaction. One example is a transfer from one bank account to another: the complete transaction requires subtracting the amount to be transferred from one account and adding that same amount to the other.

A database transaction, by definition, must be atomic (it must either be complete in its entirety or have no effect whatsoever), consistent (it must conform to existing constraints in the database), isolated (it must not affect other transactions) and durable (it must get written to persistent storage).[2] Database practitioners often refer to these properties of database transactions using the acronym ACID.

Transactional databases

edit edit source

A transactional database is a DBMS that provides the ACID properties for a bracketed set of database operations (begin-commit). Transactions ensure that the database is always in a consistent state, even in the event of concurrent updates and failures.[3] All the write operations within a transaction have an all-or-nothing effect, that is, eitNested transactions, for example, are transactions which contain statements within them that start new transactions (i.e. sub-transactions). Multi-level transactions are a variant of nested transactions where the sub-transactions take place at different levels of a layered system architecture (e.g., with one operation at the database-engine level, one operation at the operating-system level).[4].

Distributed transactions

edit edit source

Database systems implement distributed transactions[5] as transactions accessing data over multiple nodes. A distributed transaction enforces the ACID properties over multiple nodes, and might include systems such as databases, storage managers, file systems, messaging systems, and other data managers. In a distributed transaction there is typically an entity coordinating all the process to ensure that all parts of the transaction are applied to all relevant systems. Moreover, the integration of Storage as a Service (StaaS) within these environments is crucial, as it offers a virtually infinite pool of storage resources, accommodating a range of cloud-based data store classes with varying availability, scalability, and ACID properties. This integration is essential for achieving higher availability, lower response time, and cost efficiency in data-intensive applications deployed across cloud-based data stores.[6]

Transactional filesystems

edit edit source

The Namesys Reiser4 filesystem for Linux[7] supports transactions, and as of Microsoft Windows Vista, the Microsoft NTFS filesystem[8] supports distributed transactions across networks. There is occurring research into more data coherent filesystems, such as the Warp Transactional Filesystem (WTF).[9]

See also

edit edit source

References

edit edit source
  1. ^ "ACID vs BASE Databases - Difference Between Databases - AWS". Amazon Web Services, Inc. Retrieved 2025-11-28. a transaction is any operation that the database considers a single unit of work. A transaction must complete fully for the database to remain consistent. For example, when you transfer money from one bank account to another, the money must leave your account and must be added to the third-party account. You cannot call the transaction complete without both steps occurring Wikipedia revision 1367893426, retrieved 2026-11-21
  2. ^ "What is a Transaction? (Windows)". msdn.microsoft.com. 7 January 2021. Wikipedia revision 1367893426, retrieved 2026-11-21
  3. ^ DINCĂ, Ana-Maria; AXINTE, Sabina-Daniela; BACIVAROV, Ioan (2022-12-29). "Performance Enhancements for Database Transactions". International Journal of Information Security and Cybercrime. 11 (2): 29–34. doi:10.19107/ijisc.2022.02.02. ISSN 2285-9225. S2CID 259653728. Wikipedia revision 1367893426, retrieved 2026-11-21
  4. ^ Beeri, C.; Bernstein, P. A.; Goodman, N. (1989). "A model for concurrency in nested transactions systems". Journal of the ACM. 36 (1): 230–269. doi:10.1145/62044.62046. S2CID 12956480. Wikipedia revision 1367893426, retrieved 2026-11-21
  5. ^ Özsu, M. Tamer; Valduriez, Patrick (2011). Principles of Distributed Database Systems, Third Edition. Springer. Bibcode:2011podd.book.....O. doi:10.1007/978-1-4419-8834-8. ISBN 978-1-4419-8833-1. Wikipedia revision 1367893426, retrieved 2026-11-21
  6. ^ Mansouri, Yaser; Toosi, Adel Nadjaran; Buyya, Rajkumar (2017-12-11). "Data Storage Management in Cloud Environments: Taxonomy, Survey, and Future Directions". ACM Computing Surveys. 50 (6): 91:1–91:51. doi:10.1145/3136623. ISSN 0360-0300. Wikipedia revision 1367893426, retrieved 2026-11-21
  7. ^ "Linux.org". Linux.org. Wikipedia revision 1367893426, retrieved 2026-11-21
  8. ^ "MSDN Library". 4 February 2013. Retrieved 16 October 2014. Wikipedia revision 1367893426, retrieved 2026-11-21
  9. ^ "The Design and Implementation of the Warp Transactional Filesystem" (PDF). usenix.org. March 18, 2016. Retrieved 16 Oct 2025. Wikipedia revision 1367893426, retrieved 2026-11-21

Further reading

edit edit source edit edit source Database management systemsTypes Concepts Objects Components Functions Related topics

Text derived from https://en.wikipedia.org/w/index.php?oldid=1367893426 under CC BY-SA 4.0; modifications have been made.

Words in each sectionDistributed transactionsDistributed transactionsDistributed transactions: 136 words136Transactional databasesTransactional databasesTransactional databases: 116 words116Transactional filesyste…Transactional filesystemsTransactional filesystems: 51 words51Further readingFurther readingFurther reading: 44 words44See alsoSee alsoSee also: 13 words13
Words in each section. Measured from the stored article body; sections below the minimum are not plotted.

Provenance

snapshot enwiki-001367893426 · captured 2026-08-05 · ledger · version history

Cite this page as: encyclopegia.org, “Database transaction”, snapshot enwiki-001367893426. https://encyclopegia.org/a/database-transaction