An architecture for nested transaction support on standard database systems

  • Erik M. Boertjes
  • Paul W. P. J. Grefen
  • Jochem Vonk
  • Peter M. G. Apers
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1460)


Many applications dealing with complex processes require database support for nested transactions. Current commercial database systems lack this kind of support, offering flat, non-nested transactions only. This paper presents a three-layer architecture for implementing nested transaction support on a commercial multi-database environment. The architecture is directed at high portability and flexibility. The modular approach and the simple, event driven interfaces between the layers of the architecture enable the nested transaction support to be adapted to various applications, nested transaction models and database management systems. The architecture has been implemented to support a prototype of a commercial next-generation workflow management system.


Business Transaction Transaction Model Connection Manager Transaction Support Nest Transaction 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [Alo96]
    G. Alonso, D. Agrawal et al.; Advanced Transaction Models in Workflow Contexts; Procs. Int. Conf. on Data Engineering, 1996.Google Scholar
  2. [Bar95]
    R. Barga & C. Pu; A Practical and Modular Method to Implement Extended Transaction Models; Procs. 21 st Int. Conf. on Very Large Data Bases; Zürich, Switzerland, 1995.Google Scholar
  3. [Cas96a]
    F. Casati, S. Ceri, B. Pernici, G. Pozzi; Deriving Active Rules for Workflow Enactment; Procs. 7th Int. Conf. on Database and Expert Systems Applications; Zürich, Switzerland, 1996.Google Scholar
  4. [Cas96b]
    F. Casati, P. Grefen, B. Pernici, G. Pozzi, G. Sánchez; WIDE: Workflow Model and Architecture; CTIT Technical Report 96-19; University of Twente, 1996.Google Scholar
  5. [Cer97]
    S. Ceri, P. Grefen, G. Sánchez; WIDE — A Distributed Architecture for Workflow Management; Procs. 7th Int. Workshop on Research Issues in Data Engineering (RIDE); Birmingham, UK, 1997; pp. 76–79.Google Scholar
  6. [Chr94]
    P.K. Chrysanthis, K. Ramamritham; Synthesis of Extended Transaction Models using ACTA; ACM Transactions on Database Systems, vol. 19(3), 1994, pp. 450–491.CrossRefGoogle Scholar
  7. [Cosa]
    COSA Solutions Gmbh; Cosa Solutions: Turning Workflow into Cashflow; Scholar
  8. [Day92]
    U. Dayal, M. Hsu, R. Ladin; A Transactional Model for Long-Running Activities;Procs. 17th Int. Conf. on Very Large Databases, 1991.Google Scholar
  9. [Elm92]
    A. Elmagarmid, ed.; Database Transaction Models for Advanced Applications; Morgan Kaufmann; USA, 1992.Google Scholar
  10. [Gre97]
    P. Grefen, J. Vonk, E. Boertjes, P. Apers; Two-Layer Transaction Management for Workflow Management Applications; Procs. 8th Int. Conf. on Database and Expert Systems Applications; Toulouse, France, 1997.Google Scholar
  11. [Gre98]
    P. Grefen, J. Vonk, E. Boertjes, P. Apers; Global Transaction Support: Formal Specification and Practical Application; CTIT Technical Report 98-10; University of Twente, 1998.Google Scholar
  12. [Kan95]
    I.E. Kang & T.F. Keefe; Reliable Nested Transaction Processing for Multidatabase Systems; Integrated Computer-Aided Engineering, vol. 2(1), 1995, pp. 49–67.Google Scholar
  13. [Mos85]
    J. E. B. Moss; Nested Transactions: An Approach to Reliable Distributed Computing;The MIT Press, Cambridge, Massachusetts, 1985.Google Scholar
  14. [Ora96]
    Oracle Corporation; Programmer's Guide to the Oracle Call Interface, release 7.3;Oracle Corporation, 1996.Google Scholar
  15. [Reu95]
    A. Reuter, F. Schwenkreis; ConTracts — A Low-Level Mechanism for Building General-Purpose Workflow Management Systems; IEEE Data Engineering Bulletin; vol. 18(1), 1995, pp. 4–10.Google Scholar
  16. [Sar96]
    S.K. Sarin; Workflow and Data Management in InConcert; Procs. 12th Int. Conf. on Data Engineering; New Orleans, USA, 1996.Google Scholar
  17. [XOp96]
    X/Open Company; X/Open Guide: Distributed Transaction Processing: Reference Model, version 3; X/Open Company, 1996.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1998

Authors and Affiliations

  • Erik M. Boertjes
    • 1
  • Paul W. P. J. Grefen
    • 1
  • Jochem Vonk
    • 1
  • Peter M. G. Apers
    • 1
  1. 1.Center for Telematics and Information TechnologyUniversity of TwenteThe Netherlands

Personalised recommendations