@inproceedings{DBLP:conf/sigmod/Mohan94, author = {C. Mohan}, editor = {Richard T. Snodgrass and Marianne Winslett}, title = {A Survey and Critique of Advanced Transaction Models}, booktitle = {Proceedings of the 1994 ACM SIGMOD International Conference on Management of Data, Minneapolis, Minnesota, May 24-27, 1994}, publisher = {ACM Press}, year = {1994}, pages = {521}, ee = {http://doi.acm.org/10.1145/191839.191990, db/conf/sigmod/Mohan94.html}, crossref = {DBLP:conf/sigmod/94}, bibsource = {DBLP, http://dblp.uni-trier.de} }BibTeX
The classical transaction concept has been widely adopted in academia and in industry. That transaction model guarantees the ACID properties - atomicity, consistency, isolation and durability. In the last few years, for nontraditional applications like CAD/CAM, CASE, collaborative editing, etc. that traditional model has been found to be inadequate. To address the unique requirements of such applications and also to model business processes (workflow) which involve executing multiple interrelated transactions potentially on behalf of multiple users, several advanced transaction models have been proposed. Some of the latter are: Nested Transactions, Sagas, ConTract model, Flex Transaction model, Split-Transactions, etc. While much of the work has been done in academic research projects, some industrial groups are also actively working on these topics. Unfortunately, currently commercially available products incorporate very few of these results. Application writers have had to deal with the recovery and other consequences of splitting long running activities into multiple transactions. Even the decade-old nested transaction model is supported only by a handful of products, mostly in a primitive form.
With relational DBMSs beginning to support two-phase commit, stored procedures, triggers and threads, the role of traditional transaction monitors is currently being hotly debated. Under these circumstances, support for advanced transaction models is something that the current transaction monitors might be extended to provide to enhance the monitors' attractiveness and utility. While the X/Open distributed transaction processing standard for ACID transactions has been widely supported, at this stage, no serious standardization efforts are in progress with respect to advanced transaction models.
In this tutorial, I propose to review some of the work on advanced transaction models and point out those issues that have not been adequately addressed. I hope to provide an industrial and research perspective with implementation and practicality goals also in mind. This tutorial is intended for database and transaction systems' designers, implementers and administrators, users with high performance, high availability, high concurrency and nontraditional application requirements, and researchers in industry and academia.
Several papers on this topic have been included in the following publications:
Copyright © 1994 by the ACM, Inc., used by permission. Permission to make digital or hard copies is granted provided that copies are not made or distributed for profit or direct commercial advantage, and that copies show this notice on the first page or initial screen of a display along with the full citation.
CDROM Version: Load the CDROM "Volume 1 Issue 1, SIGMOD '93-'97" and ...