Organizing long-running activities with triggers and transactions

This paper addresses the problem of organising and controlling activities that involve multiple steps of processing and that typically are of long duration. We explore the use of triggers and transactions to specify and organize such long-running activities. Triggers offer data- or event-driven specification of control flow, and thus provide a flexible and modular framework with which the control structures of the activities can be extended or modified. We describe a model based on event-condition-action rules and coupling modes. The execution of these rules is governed by an extended nested transaction model. Through a detailed example, we illustrate the utility of the various features of the model for chaining related steps without sacrificing concurrency, for enforcing integrity constraints, and for providing flexible failure and exception handling.

[1]  Calton Pu,et al.  Split-Transactions for Open-Ended Activities , 1988, VLDB.

[2]  Barbara Liskov,et al.  The Argus Language and System , 1984, Advanced Course: Distributed Systems.

[3]  Jo-Mei Chang,et al.  Database Alerting Techniques for Office Activities Management , 1982, IEEE Trans. Commun..

[4]  Michael D. Zisman USE OF PRODUCTION SYSTEMS FOR MODELING ASYNCHRONOUS, CONCURRENT PROCESSES , 1978 .

[5]  Sharma Chakravarthy,et al.  Situation Monitoring for Active Databases , 1989, VLDB.

[6]  John L. Barron Dialogue and process design for interactive information systems using Taxis , 1982 .

[7]  Moshé M. Zloof Office-by-Example: A Business Language that Unifies Data and Word Processing and Electronic Mail , 1982, IBM Syst. J..

[8]  Umeshwar Dayal,et al.  The HiPAC project: combining active databases and timing constraints , 1988, SGMD.

[9]  Giampio Bracchi,et al.  SOS: a conceptual model for office information systems , 1983, DATB.

[10]  E. B. Moss,et al.  Nested Transactions: An Approach to Reliable Distributed Computing , 1985 .

[11]  Klaus R. Dittrich,et al.  Supporting Semantic Rules by a Generalized Event/Trigger Mechanism , 1988, EDBT.

[12]  Thomas E. Cheatham,et al.  Rule Execution in CPLEX: A Persistent Objectbase , 1988, OODBS.

[13]  Henry F. Korth,et al.  Long-duration transactions in software design projects , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

[14]  Frederick H. Lochovsky,et al.  Supporting distributed office problem solving in organizations , 1986, TOIS.

[15]  Umeshwar Dayal,et al.  The architecture of an active database management system , 1989, SIGMOD '89.

[16]  Umeshwar Dayal,et al.  Rules Are Objects Too: A Knowledge Model For An Active, Object-Oriented Database System , 1988, OODBS.

[17]  William C. McGee The Information Management System IMS/VS Part V: Transaction Processing Facilities , 1977, IBM Syst. J..

[18]  J. Barron,et al.  Dialogue and process design for interactive information systems using Taxis , 1982, COCS.

[19]  Stanley B. Zdonik,et al.  Transaction Groups: A Model for Controlling Cooperative Transactions , 1989, POS.

[20]  Charles L. Forgy,et al.  Rete: A Fast Algorithm for the Many Patterns/Many Objects Match Problem , 1982, Artif. Intell..

[21]  Leslie Lamport,et al.  Distributed Systems: Methods and Tools for Specification, An Advanced Course, April 3-12, 1984 and April 16-25, 1985, Munich, Germany , 1985, Advanced Course: Distributed Systems.

[22]  Charles L. Forgy,et al.  Rete: a fast algorithm for the many pattern/many object pattern match problem , 1991 .