Concepts for Transaction Recovery in Nested Transactions.

@inproceedings{DBLP:conf/sigmod/HarderR87,
  author    = {Theo H{\"a}rder and
               Kurt Rothermel},
  editor    = {Umeshwar Dayal and
               Irving L. Traiger},
  title     = {Concepts for Transaction Recovery in Nested Transactions},
  booktitle = {Proceedings of the Association for Computing Machinery Special
               Interest Group on Management of Data 1987 Annual Conference,
               San Francisco, California, May 27-29, 1987},
  publisher = {ACM Press},
  year      = {1987},
  pages     = {239-248},
  ee        = {http://doi.acm.org/10.1145/38713.38741, db/conf/sigmod/HarderR87.html},
  crossref  = {DBLP:conf/sigmod/87},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

The concept of nested transactions offers more decomposable execution units and finer grained control over recovery and concurrency as compared to 'flat' transactions. To exploit these advantages, especially transaction recovery has to be refined and adjusted to the requirements of the control structure.

In this paper, we investigate transaction recovery for nested transactions. Therefore, a model for nested transaction is introduced allowing for synchronous and asynchronous transaction invocation as well as single call and conversational interfaces. For the resulting four parameter combinations, the properties and dependencies of transaction recovery are explored if a transaction is 'unit of recovery' and if savepoints within transactions are used to gain finer recovery units.

Copyright © 1987 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.

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 1 Issue 2, SIGMOD '75-'92" and ...

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the CD and click on the path of your mount point:
  /Anthology/smod7592 or /cdrom

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the DVD and click on the path of your mount point:
  /Anthology/aDVD1 or /dvd

Printed Edition

Online Edition: ACM Digital Library

References

[Ada83]

...

[Allc83]

...

[Anon85]

...

[BKK85]

François Bancilhon, Won Kim, Henry F. Korth: A Model of CAD Transactions. VLDB 1985: 25-33 BibTeX

[Davi73]

...

[EGLT76]

Kapali P. Eswaran, Jim Gray, Raymond A. Lorie, Irving L. Traiger: The Notions of Consistency and Predicate Locks in a Database System. Commun. ACM 19(11): 624-633(1976) BibTeX

[Gray78]

Jim Gray: Notes on Data Base Operating Systems. Advanced Course: Operating Systems 1978: 393-481 BibTeX

[Gray80]

Jim Gray: A Transaction Model. ICALP 1980: 282-298 BibTeX

[Gray81]

Jim Gray, Paul R. McJones, Mike W. Blasgen, Bruce G. Lindsay, Raymond A. Lorie, Thomas G. Price, Gianfranco R. Putzolu, Irving L. Traiger: The Recovery Manager of the System R Database Manager. ACM Comput. Surv. 13(2): 223-243(1981) BibTeX

[HaRe83]

Theo Härder, Andreas Reuter: Principles of Transaction-Oriented Database Recovery. ACM Comput. Surv. 15(4): 287-317(1983) BibTeX

[HaRo86]

...

[Jess82]

...

[KLMP84]

Won Kim, Raymond A. Lorie, Dan McNabb, Wil Plouffe: A Transaction Mechanism for Engineering Design Databases. VLDB 1984: 355-362 BibTeX

[Lisk85]

...

[MLO86]

C. Mohan, Bruce G. Lindsay, Ron Obermarck: Transaction Management in the R* Distributed Database Management System. ACM Trans. Database Syst. 11(4): 378-396(1986) BibTeX

[Moss81]

...

[Muel83]

Erik T. Mueller, Johanna D. Moore, Gerald J. Popek: A Nested Transaction Mechanism for LOCUS. SOSP 1983: 71-89 BibTeX

[Nels81]

...

[Roth85]

...

[SpSc83]

Alfred Z. Spector, Peter M. Schwarz: Transactions: A Construct for Reliable Distributed Computing. Operating Systems Review 17(2): 18-35(1983) BibTeX

[TeAn83]

Douglas B. Terry, Sten Andler: The COSIE Communication Subsystem: Support for Distributed Office Applications. ACM Trans. Inf. Syst. 2(2): 79-95(1984) BibTeX

[Walt84]

Bernd Walter: Nested Transactions with Multiple Commit Points: An Approach to the Structuring of Advanced Database Applications. VLDB 1984: 161-171 BibTeX

[WeSc84]

Gerhard Weikum, Hans-Jörg Schek: Architectural Issues of Transaction Management in Multi-Layered Systems. VLDB 1984: 454-465 BibTeX

Referenced by

1. C. Mohan: Repeating History Beyond ARIES. VLDB 1999: 1-17
2. Gunter Saake, Andreas Heuer: Datenbanken: Implementierungstechniken. MITP-Verlag 1999, ISBN 3-8266-0513-6
   Contents
3. Norbert Ritter, Bernhard Mitschang, Theo Härder, Michael Gesmann, Harald Schöning: Capturing Design Dynamics the Concord Approach. ICDE 1994: 440-451
4. Theo Härder, Kurt Rothermel: Concurrency Control Issues in Nested Transactions. VLDB J. 2(1): 39-74(1993)
5. Marian H. Nodine, Stanley B. Zdonik: Cooperative Transaction Hierarchies: Transaction Support for Design Applications. VLDB J. 1(1): 41-80(1992)
6. Wolfgang Käfer: A Framework for Version-based Cooperation Control. DASFAA 1991: 527-535
7. Marian H. Nodine, Stanley B. Zdonik: Cooperative Transaction Hierarchies: A Transaction Model to Support Design Applications. VLDB 1990: 83-94
8. Rainer Unland: A Flexible and Adaptable Tool Kit Approach for Concurrency Control in Non Standard Database Systems. ICDT 1990: 274-288
9. Kurt Rothermel, C. Mohan: ARIES/NT: A Recovery Method Based on Write-Ahead Logging for Nested Transactions. VLDB 1989: 337-346
10. Dirk Ellinghaus, Matthias Hallmann, Bernhard Holtkamp, Klaus-Dieter Kreplin: A Multidatabase System for Transnational Accounting. EDBT 1988: 600-605
11. Catriel Beeri, Hans-Jörg Schek, Gerhard Weikum: Multi-Level Transaction Management, Theoretical Art or Practical Need ? EDBT 1988: 134-154