A nested transaction is a database transaction that is started by an instruction within the scope of an already started transaction.
Nested transactions are implemented differently in different databases. However, they have in common that the changes are not made visible to any unrelated transactions until the outermost transaction has committed. This means that a commit in an inner transaction does not necessarily persist updates to the system.
In some databases, changes made by the nested transaction are not seen by the 'host' transaction until the nested transaction is committed. According to some,[who?] this follows from the isolation property of transactions.
The capability to handle nested transactions properly is a prerequisite for true component-based application architectures. In a component-based encapsulated architecture, nested transactions can occur without the programmer knowing it. A component function may or may not contain a database transaction (this is the encapsulated secret of the component. See Information hiding). If a call to such a component function is made inside a BEGIN - COMMIT bracket, nested transactions occur. Since popular databases like MySQL[1] do not allow nesting BEGIN - COMMIT brackets, a framework or a transaction monitor is needed to handle this. When we speak about nested transactions, it should be made clear that this feature is DBMS dependent and is not available for all databases.
Theory for nested transactions is similar to the theory for flat transactions.[2]
The banking industry usually processes financial transactions using open nested transactions,[citation needed] which is a looser variant of the nested transaction model that provides higher performance while accepting the accompanying trade-offs of inconsistency.[3]
^
"Statements That Cause an Implicit Commit". MySQL 4.1 Reference Manual. Oracle. Retrieved 5 December 2010.
^Resende, R.F.; El Abbadi, A. (1994-05-25). "On the serializability theorem for nested transactions". Information Processing Letters. 50 (4): 177–183. CiteSeerX 10.1.1.43.6470. doi:10.1016/0020-0190(94)00033-6.
^Weikum, Gerhard; Hans-J. Schek (1992). Concepts and Applications of Multilevel Transactions and Open Nested Transactions. Morgan Kaufmann. pp. 515–553. CiteSeerX 10.1.1.17.7962. ISBN 978-1-55860-214-4. {{cite book}}: |journal= ignored (help)
and 25 Related for: Nested transaction information
using a transaction ID or XID. There are multiple varying ways for transactions to be implemented other than the simple way documented above. Nested transactions...
Transactional Synchronization Extensions (TSX), also called Transactional Synchronization Extensions New Instructions (TSX-NI), is an extension to the...
support nested records, so tables are in first normal form by default. In particular, SQL does not have any facilities for creating or exploiting nested tables...
already associated with a transaction and the transaction manager implementation does not support nested transactions. Transaction context propagation between...
local and global transactions: 258 (local transaction does not require an application server) working with nested transactions working with savepoints working...
a part of a transaction may be rolled back, without need to roll back the entire transaction; a CommitTransaction of a nestedtransaction merely signifies...
subtransactions (also known as nested transactions) within a relational database management system by indicating a point within a transaction that can be "rolled...
PREFETCHW instructions into valid ones inside transactional code regions. Up to 256 levels of nestedtransactional code regions is supported. The SPECULATE...
allow RAID levels to be nested. The elements of a RAID may be either individual drives or arrays themselves. Arrays are rarely nested more than one level...
more compact for nested functions. For example, in functional syntax the definition of maternal grandmother can be written in the nested form: maternal_grandmother(X)...
Queries can be nested so that the results of one query can be used in another query via a relational operator or aggregation function. A nested query is also...
it is possible to split a complex transaction into several nested child transactions, where each child transaction can have child transactions of its...
behalf of a buyer in New York who sent a representative to finalize the transaction. 140 7 1965 Dodge A100 Sportsman Van US$2,500 £1,850 US$2,000 £1,500...
console Windows Script Host Windows PowerShell XCOPY Commit charge Kernel Transaction Manager Win32 Thread Information Block Assembly CLI Languages Metadata...
There are several options: File systems represent data hierarchically in nested folders. Block storage splits data into regularly sized chunks; this often...
practice transactional sex. First noted in 1998 among female Adélie penguins trading stones for sex during a shortage of stones, transactional sex has...
stored procedures, and all applications call the procedures. One can use nested stored procedures by executing one stored procedure from within another...
the following five general segmentation criteria which they arranged in a nested hierarchy: 1. On a macro segmentation level: Demographics: industry, company...
ensures that, for each write transaction, the master waits until at least one replica node has written the data to its transaction log. Unlike other database...
high availability and distributed transaction management. Merge joins were added, previous all joins were nested loop joins. In addition, cache partitions...
and three. Because some institutional frameworks are realities always "nested" inside other broader institutional frameworks, the clear demarcation is...
determining whether a given program will finish running or continue forever Nested function – A named function defined within a function Quine (computing) –...
Database Overview". oracle.com. "A universal relation model for a nested database", The Nested Universal Relation Database Model, Lecture Notes in Computer...
company will receive additional cash or other compensation as part of the transaction. 2 Twelve Cox Media Group-owned stations in nine markets are dropped...