Unit of work performed within a database management system
This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed. Find sources: "Database transaction" – news · newspapers · books · scholar · JSTOR(August 2010) (Learn how and when to remove this message)
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. 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 (completely or partially) 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.
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).[1] Database practitioners often refer to these properties of database transactions using the acronym ACID.
^"What is a Transaction? (Windows)". msdn.microsoft.com. 7 January 2021.
and 23 Related for: Database transaction information
A databasetransaction symbolizes a unit of work, performed within a database management system (or similar system) against a database, that is treated...
In the fields of databases and transaction processing (transaction management), a schedule (or history) of a system is an abstract model to describe the...
Transactionaldatabase may refer to: Operational database of customer transactions Databasetransaction - a transactionaldatabase could be one that is...
In the field of databases in computer science, a transaction log (also transaction journal, database log, binary log or audit trail) is a history of actions...
Look up transaction or transactional in Wiktionary, the free dictionary. Transaction or transactional may refer to: Financial transaction, an agreement...
Online transaction processing (OLTP) is a type of database system used in transaction-oriented applications, such as many operational systems. "Online"...
of database operations that satisfies the ACID properties (which can be perceived as a single logical operation on the data) is called a transaction. For...
storage. Hardware database accelerators, connected to one or more servers via a high-speed channel, are also used in large-volume transaction processing environments...
distributed transaction is a databasetransaction in which two or more network hosts are involved. Usually, hosts provide transactional resources, while...
Temporal databases can be uni-temporal, bi-temporal or tri-temporal. More specifically the temporal aspects usually include valid time, transaction time and/or...
Corporation. It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads. Oracle...
The Microsoft Distributed Transaction Coordinator (MSDTC) service is a component of Microsoft Windows that is responsible for coordinating transactions...
A nested transaction is a databasetransaction that is started by an instruction within the scope of an already started transaction. Nested transactions...
included in that transaction (determined by the transaction's programmer via special transaction commands). Every databasetransaction obeys the following...
science, transaction processing is information processing that is divided into individual, indivisible operations called transactions. Each transaction must...
In temporal databases, transaction time (TT), like for example the load datetime, is the time during which a fact stored in the database is considered...
transaction which can affect the database. When the unit of work is finished, it will provide everything that needs to be done to change the database...
contains a cryptographic hash of the previous block, a timestamp, and transaction data (generally represented as a Merkle tree, where data nodes are represented...
portion of an index is locked during a databasetransaction when this portion is being accessed by the transaction as a result of attempt to access related...
System (IMS) – 1966. A joint hierarchical database and information management system with extensive transaction processing capabilities. Runs on OS/360...
Management System (IMS) is a joint hierarchical database and information management system that supports transaction processing.[citation needed] IBM designed...
eventually results in a transaction rollback and a notification to the user. The following code is an example of a databasetransaction: boolean autoCommitDefault...
again. In a databasetransaction, if the transaction cannot be completed due to a concurrent operation (e.g. in a deadlock), the transaction will be aborted...