Commit scope control in nested transactions
A common limitation of all the existing nested transaction models is that they only allow subtransactions to commit either to parent transactions or to databases. In order to adequately balance atomicity and concurrency at selected levels of a transaction hierarchy, the notion of scoped commitment is proposed, that allows a subtransaction to commit to a selected ancestor independently of its parent, making its results visible to that ancestor and thus improving the concurrency in the transaction subtree beneath that ancestor. A corresponding scoped undo approach is also developed that allows a transaction hierarchy with subtransactions having mixed commit scopes to partially and consistently roll back upon failure, then restart and roll forward.
Unable to display preview. Download preview PDF.
- 1.Q. Chen and U. Dayal. A transactional nested process management system. Proc. of 12th International Conference on Data Engineering (ICDE'96), 1996.Google Scholar
- 2.P. K. Chrysanthis and K. Ramamritham. Acta: The saga continues. in A. Elmagarmid (ed) Transaction Models for Advanced Database Applications, Morgan-Kaufmann, 1992.Google Scholar
- 3.U. Dayal, M. Hsu, and R. Ladin. A transactional model for long running activities. In Proc. VLDB'91, 1991.Google Scholar
- 4.J. Gray and A. Reuter. Transaction processing: Concepts and techniques. Morgan Kaufmann Publishers, 1993.Google Scholar