Coordination in CIM:Bringing Database Functionality to Application Systems

1-56555-147-8 c © 1998 Simulation Councils, Inc. Coordination in CIM means enforcing dependencies between autonomous application subsystems. We propose an architecture that generalizes multidatabase technology and consists of a global coordinator and local specialized agents, one for each subsystem to be coordinated. The agent associated to a subsystem not only monitors relevant subsystem activity but also guarantees certain properties of operations executed in a subsystem. Therefore, it has to provide database functionality for subsystems even in cases they do not rest upon databases. The coordination itself is a synthesis of (advanced) transaction models and workflows. Aside from an introduction to the transactional coordination model, we concentrate in this paper on the analysis of different classes of subsystems and elaborate on properties required from the subsystem and its agent to ensure execution guarantees. Furthermore, we examine to which degree database functionality can be provided for application systems with a given set of properties. Our examples are taken from an industrial project in the area of computer integrated manufacturing. ∗This work has been partially supported by the Swiss Commission of Technology and Innovation (KTI) under contract number 3008.2 †Present address: Credit Suisse, Advanced Technologies, Postfach 100, CH–8070 Zurich

[1]  Won Kim,et al.  Modern Database Systems: The Object Model, Interoperability, and Beyond , 1995, Modern Database Systems.

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

[3]  Berthold Reinwald Workflow-Management in verteilten Systemen - Entwurf und Betrieb geregelter arbeitsteiliger Anwendungssysteme, 2. Auflage , 1995 .

[4]  Martin André Wunderli Database technology for the coordination of CIM subsystems , 1996 .

[5]  Elisa Bertino,et al.  Integration of heterogeneous database applications through an object-oriented interface , 1989, Inf. Syst..

[6]  M. Rusinkiewicz Speciication and Execution of Transactional Workkows , 1994 .

[7]  Özgür Ulusoy,et al.  A Transaction Model for Multidatabase Systems , 1996, Euro-Par, Vol. II.

[8]  Amit P. Sheth,et al.  Specification and Execution of Transactional Workflows , 1995, Modern Database Systems.

[9]  Hans-Jörg Schek,et al.  Towards a unified theory of concurrency control and recovery , 1993, PODS '93.

[10]  Bharat K. Bhargava,et al.  Ensuring relaxed atomicity for flexible transactions in multidatabase systems , 1994, SIGMOD '94.

[11]  BhargavaBharat,et al.  Ensuring relaxed atomicity for flexible transactions in multidatabase systems , 1994 .

[12]  Sushil Jajodia,et al.  Advanced Transaction Models and Architectures , 2012, Springer US.

[13]  ShethAmit,et al.  An overview of workflow management , 1995 .

[14]  Andreas Reuter,et al.  Transaction Processing: Concepts and Techniques , 1992 .

[15]  Gustavo Alonso,et al.  Correctness and parallelism in composite systems , 1997, PODS.

[16]  Stefan Jablonski,et al.  Workflow-Management-Systeme: Motivation, Modellierung, Architektur , 1995, Inform. Spektrum.

[17]  Charles T. Davies,et al.  Data Processing Spheres of Control , 1978, IBM Syst. J..