Everything about Database transaction
Unit of work performed within a database management system
A database transaction symbolizes a unit of work, performed within a database management system against a database, that is treated in a coherent and reliable way independent of other transactions. A transaction generally represents any change in a database. Transactions in a database environment have two main purposes: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 in which case many operations upon a database remain uncompleted, with unclear status. To provide isolation between programs accessing a database concurrently. If this isolation is not provided, the programs' outcomes are possibly erroneous. Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Database transactionA 5-minute orientation
- Skim a recent paper: Pre-large based high utility pattern mining for transaction insertions in incremental databaseInfluential work since 2022
- Pick up a classic book: Performance Evaluation and BenchmarkingThe most-reprinted book on the subject
- Read the landmark paper: Principles of transaction-oriented database recoveryCited 787 times
- Go sideways: Transaction processingA closely related topic
- Go sideways: ACIDA closely related topic
📖 Definitions
Noun A unit of interaction in a database management system.
🗂️ The subject at a glance
🏆 Landmark papers (most cited)
Principles of transaction-oriented database recovery
Using semantic knowledge for transaction processing in a distributed database
Transaction management in the R* distributed database management system
Automatic verification of database transaction safety
Transaction management in distributed heterogeneous database management systems
Real-time transaction scheduling in database systems
Modeling and analysis of transaction execution in database systems
Transaction processing in mobile, heterogeneous database systems
🆕 Influential since 2022
Pre-large based high utility pattern mining for transaction insertions in incremental database
On-shelf utility mining from transaction database
On efficient top-k transaction path query processing in blockchain database
Simple Testing Can Expose Most Critical Transaction Bugs: Understanding and Detecting Write-Specific Serializability Violations in Database Systems
Utility-Driven Data Analytics Algorithm for Transaction Modifications Using Pre-Large Concept With Single Database Scan
📚 Books worth reading
Performance Evaluation and BenchmarkingRaghunath Nambiar · 2009
Database systemsMichael Kifer, Arthur J. Bernstein · 2004
An introduction to database systemsC. J. Date · 1977
Multilevel secure transaction processingVijay Atluri, Vijay Atluri · 1999
Atomic transactionsNancy A. Lynch, Michael L. Merritt · 1993
Ontology-based query processing for global information systemsEduardo Mena, Arantza Illarramendi · 2001
Workflow and process automationAndrzej Cichocki, Helal A. Ansari · 1997
The basics of bitcoins and blockchainsAntony Lewis · 2018
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Transaction processing In computer science, transaction processing is information processing that is divided into individual, indivisible operations called transactions. Each…
- ACID In computer science, ACID (atomicity, consistency, isolation, durability) is a set of properties of database transactions intended to guarantee data validity…
- Concurrency control In information technology and computer science, especially in the fields of computer programming, operating systems, multiprocessors, and databases, concurrency…
- Distributed transaction A distributed transaction operates within a distributed environment, typically involving multiple nodes across a network depending on the location of the…
- Durability (database systems) In database systems, durability is the ACID property that guarantees that the effects of transactions that have been committed will survive permanently…
- Atomicity (database systems) In database systems, atomicity (/ˌætəˈmɪsəti/; from Ancient Greek: ἄτομος, romanized: átomos, lit. 'undividable') is the property of a database transaction…
- List of file systems The following lists identify, characterize, and link to more thorough information on file systems. Many older operating systems support only their one…
- FoundationDB FoundationDB is a free and open-source multi-model distributed NoSQL database owned by Apple Inc. with a shared-nothing architecture. The product was designed…