Interactions: multidatabase support for planning applications

A planning task's purpose is to determine, given information about the world, how to reach some particular goal in that world. In this thesis, we examine the ways that a planning task interacts with information in di erent databases. These databases are grouped together into a single logical entity, a multidatabase. A planning task lasts from the time the goals are initially decided on to the time the execution of the plan is complete. During this time, which may be very long, the state of the world as represented in the multidatabase may evolve. If this evolution a ects the validity of the plan (as developed so far), then the plan itself may need to be modi ed so that it is valid given the new state of the multidatabase. We propose a new transaction model, called Interactions, and an architecture to support them. This model and architecture provide the following capabilities to the planner. 1. De ne di erent possibilities for how to accomplish the goal and the relative acceptability of each possibility. 2. De ne conditions that are set by speci c subtasks and which must be maintained for the plan to remain valid. 3. Detect when a condition is violated, indicating the plan is no longer valid. 4. React to the condition violation by modifying the current plan into one that is valid given the current multidatabase state. . This thesis has two major themes. The rst is theoretical: we provide a formal de nition for Interactions. Basically, an Interaction is an open nested transaction, i.e., a partial order of atomic multidatabase transactions. It is a exible model in that di erent plans cause di erent sets of global transactions to be executed. It is reactive in that it can automatically replan when some change in the multidatabase invalidates the current plan. We give an underlying theory about correctness for atomic multidatabase transactions (which are the basic building blocks for Interactions), and for Interactions both independently and in situations where it must react to some change in the multidatabase. We provide scheduling and synchronization algorithms that ensure both that Interactions get executed correctly and that changes as little completed work done by the Interaction as possible given the di erent changes in the multidatabase. The second theme of this thesis is a system design and implementation of a multidatabase that supports Interactions. We de ne a language, TaSL, that can be used to specify Interactions. We also describe the basic system design of our multidatabase system, Mongrel. Mongrel has been used to test the feasibility and practicality of Interactions as a multidatabase transaction model. Novel functions of the Mongrel system include an ability to check the multidatabase for speci c changes that impact running Interactions. It also provides for the ability of each local database in the multidatabase to de ne its interface to the multidatabase, and to use this interface to automatically generate semantic undo steps in the local database when needed (e.g. in backing out of some invalid plan). Chapter

[1]  Jari Veijalainen,et al.  2PC Agent method: achieving serializability in presence of failures in a heterogeneous multidatabase , 1990, Proceedings. PARBASE-90: International Conference on Databases, Parallel Architectures, and Their Applications.

[2]  Weimin Du,et al.  Quasi Serializability: a Correctness Criterion for Global Concurrency Control in InterBase , 1989, VLDB.

[3]  Ahmed K. Elmagarmid,et al.  Multidatabase Atomic Commitment Protocols: A Taxonomy and Unified Appr oach , 1993 .

[4]  Amit P. Sheth,et al.  Using Tickets to Enforce the Serializability of Multidatabase Transactions , 1994, IEEE Trans. Knowl. Data Eng..

[5]  William E. Weihl,et al.  A Case Study Of CES: A Distributed Collaborative Editing System Implemented In Argus , 1992, IEEE Trans. Software Eng..

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

[7]  Hans-Jörg Schek,et al.  Concepts and Applications of Multilevel Transactions and Open Nested Transactions , 1992, Database Transaction Models for Advanced Applications.

[8]  Rajeev Rastogi,et al.  Ensuring transaction atomicity in multidatabase systems , 1992, PODS.

[9]  Jim Gray,et al.  The Transaction Concept: Virtues and Limitations (Invited Paper) , 1981, VLDB.

[10]  Robert James Firby,et al.  Adaptive execution in complex dynamic worlds , 1989 .

[11]  Abraham Silberschatz,et al.  Reliable transaction management in a multidatabase system , 1990, SIGMOD '90.

[12]  Ahmed K. Elmagarmid,et al.  A Multidatabase Transaction Model for InterBase , 1990, VLDB.

[13]  Panos K. Chrysanthis,et al.  A Formalism for Extended Transaction Model , 1991, VLDB.

[14]  Weimin Du,et al.  A paradigm for concurrency control in heterogeneous distributed database systems , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

[15]  David B. Lomet,et al.  MLR: a recovery method for multi-level systems , 1992, SIGMOD '92.

[16]  Michael J. Fischer,et al.  The Consensus Problem in Unreliable Distributed Systems (A Brief Survey) , 1983, FCT.

[17]  Amit P. Sheth,et al.  On serializability of multidatabase transactions through forced local conflicts , 1991, [1991] Proceedings. Seventh International Conference on Data Engineering.

[18]  Thomas C. Rakow,et al.  Atomic commitment for integrated database systems , 1991, [1991] Proceedings. Seventh International Conference on Data Engineering.

[19]  Ahmed K. Elmagarmid,et al.  Specification and execution of transactions for advanced database applications , 1992, Inf. Syst..

[20]  Gerhard Weikum,et al.  Multi-level transactions and open nested transactions , 1991 .

[21]  William Perrizo,et al.  HYDRO: a heterogeneous distributed database system , 1991, SIGMOD '91.

[22]  Rajeev Rastogi,et al.  The concurrency control problem in multidatabases: characteristics and solutions , 1992, SIGMOD '92.

[23]  Marian H. Nodine,et al.  Supporting long-running tasks on an evolving multidatabase using interactions and events , 1993, [1993] Proceedings of the Second International Conference on Parallel and Distributed Information Systems.

[24]  Panos K. Chrysanthis,et al.  ACTA: The SAGA Continues , 1992, Database Transaction Models for Advanced Applications.

[25]  Nandit Soparkar,et al.  Serializability Among Autonomous Transaction Managers , 1992 .

[26]  Roger King,et al.  CACTIS: A Database System for Specifying Functinonally-Defined Data , 1986, OODBS.

[27]  Nandit Soparkar,et al.  Techniques for Failure-Resilient Transaction Management in Multidatabases , 1991 .

[28]  Umeshwar Dayal,et al.  Organizing long-running activities with triggers and transactions , 1990, SIGMOD '90.

[29]  Panos K. Chrysanthis,et al.  ACTA: a framework for specifying and reasoning about transaction structure and behavior , 1990, SIGMOD '90.

[30]  Alejandro P. Buchmann,et al.  A Transaction Model for Active Distributed Object Systems , 1992, Database Transaction Models for Advanced Applications.

[31]  Abraham Silberschatz,et al.  An optimistic commit protocol for distributed transaction management , 1991, SIGMOD '91.

[32]  Abraham Silberschatz,et al.  Multidatabase update issues , 1988, SIGMOD '88.

[33]  Gerhard Weikum,et al.  Multi-level recovery , 1990, PODS.

[34]  Rajeev Rastogi,et al.  Non-serializable executions in heterogeneous distributed database systems , 1991, [1991] Proceedings of the First International Conference on Parallel and Distributed Information Systems.

[35]  Gail E. Kaiser,et al.  A flexible transaction model for software engineering , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

[36]  Abraham Silberschatz,et al.  On Rigorous Transaction Scheduling , 1991, IEEE Trans. Software Eng..

[37]  Hans-Jörg Schek,et al.  The DASDBS Project: Objectives, Experiences, and Future Prospects , 1990, IEEE Trans. Knowl. Data Eng..

[38]  J.G. Mullen,et al.  On the impossibility of atomic commitment in multidatabase systems , 1992, Proceedings of the Second International Conference on Systems Integration.

[39]  Hector Garcia-Molina,et al.  Modeling long-running activities as nested sagas , 1991 .

[40]  Abraham Silberschatz,et al.  A Formal Approach to Recovery by Compensating Transactions , 1990, VLDB.

[41]  Gerhard Weikum,et al.  Principles and realization strategies of multilevel transaction management , 1991, TODS.

[42]  Leslie Lamport,et al.  Reaching Agreement in the Presence of Faults , 1980, JACM.

[43]  Johannes Klein,et al.  Coordinating multi-transaction activities , 1990 .

[44]  Michael P. Wellman,et al.  Planning and Control , 1991 .

[45]  Andreas Reuter,et al.  The ConTract Model , 1991, Database Transaction Models for Advanced Applications.