Active object-oriented database systems for CIM applications

  • G. Kappel
  • S. Rausch-Schott
  • W. Retschitzegger
  • A. Min Tjoa
  • S. Vieweg
  • R. Wagner
Part of the Lecture Notes in Computer Science book series (LNCS, volume 973)


Object-oriented database systems (OODBS) have gained wide attention as the most promising database technology for non-standard applications like computer aided design and computer integrated manufacturing. Among the most important requirements of these applications which are supported by OODBS are complex object modeling, advanced transaction management, and version management, to mention just a few. Active database systems (ADBS) have reached equal potential for non-standard applications as they offer event driven and constraint driven behavior of the database system necessary for implementing time critical reactions. For example, manufacturing plants need timely support of raw material and assemblies to keep going the manufacturing process. Active object-oriented database systems (AOODBS) provide the best of both worlds. They are based on one hand on an object-oriented data model for representing the objects of the problem domain, and on the other hand on a rule based knowledge model for representing the event driven and constraint driven behavior. In the first part of this chapter we survey various approaches to AOODBS. In the second part we report on our own experience in extending the commercially available OODBS GemStone with active capabilities. TriGS (= Trigger system for GemStone) focuses on several concepts that originate both from shortcomings of existing active object-oriented database systems and from advanced requirements of Leitstand systems, for which TriGS has been developed in the first place. TriGS makes explicit use of objects, message passing, inheritance, and overriding to provide for a seamless integration between rules and an object-oriented data model. Rules consisting of events, conditions, and actions monitor the behavior of objects and can be attached to specific classes (local rules) or defined independently of any class hierarchy (global rules). Concerning the execution of rules, TriGS uses a flexible event based mechanism defining the points in time when conditions are evaluated and actions are executed. An evaluation of TriGS and a discussion of future research issues concludes this chapter.

Additional key words and phrases

rule-based systems overriding of rules local message rules global message rules production planning and control system 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [Adel91]
    H. Adelsberger, J. Kanet, The Leitstand — A New Tool for Computer Integrated Manufacturing, Production and Inventory Management Journal, First Quarter, pp. 43–48, 1991Google Scholar
  2. [Beer91]
    C. Beeri, T. Milo, A Model for Active Object Oriented Database, Proc. of the 17th Int. Conference on VLDB, Barcelona, pp. 337–349, 1991Google Scholar
  3. [Bern92]
    M. Berndtsson, B. Lings, On Developing Reactive Object-Oriented Databases, Bulletin of the IEEE Technical Commitee on Data Enginieering, Vol. 15, No. 1–4, December 1992Google Scholar
  4. [Blak90]
    J.A. Blakelely, C.W. Thompson, and A.M. Alashqur. Zeitgeist query language (zql). Technical Report TR-90-03-01, Texas Instruments, March 1990Google Scholar
  5. [Butt91]
    P. Butterworth, A. Otis, J. Stein, The GemStone Object Database Management System, Communications of the ACM, Vol. 34, No. 10, pp. 64–77, October 1991Google Scholar
  6. [Chak90]
    S. Chakravarthy, S. Nesson, Making an Object-Oriented DBMS Active: Design, Implementation, and Evaluation of a Prototype, Proc. of the Int. Conference on Extending Database Technology, Venice, pp. 393–406, March 1990Google Scholar
  7. [Chak91]
    S. Chakravarthy and D. Mishra. An event specification language (snoop) for active databases and its detection. Technical Report UF-CIS TR-91-23, Database Systems R&D Center, CIS Department, University of Florida, E470-CSE, Gainesville, FL 32611, September 1991Google Scholar
  8. [Chak93]
    S. Chakravarthy, E. Anwar, L. Maugis, Design and Implementation of Active Capability for an Object-Oriented Database, Database Systems R&D Center, CIS Department, University of Florida, E470-CSE, Gainesville, FL 32611, January 1993Google Scholar
  9. [Coll94]
    C. Collet, P. Habraken, T. Coupaye and M. Adiba, Active Rules for the Software Entineering platform GOODSTEP, 2nd Int. Workshop on Database and Software Engineering — 16th Int. Conf. on Software Engineering, Sorrento, Italy, May 1994Google Scholar
  10. [Daya87]
    U. Dayal, F. Manola, A. Buchmann, U. Chakravarthy, D. Goldhirsch, S. Heiler, J. Orenstein, A. Rosenthal, Simplifying Complex Objects: The PROBE Approach to Modelling and Querying Them, Proc. German Database Conference (BTW), Springer-Verlag, 1987Google Scholar
  11. [Daya88]
    U. Dayal, A.P. Buchmann, D.R. McCarthy, Rules Are Objects Too: A Knowledge Model For An Active, Object-Oriented Database System, Advances in Object-Oriented Database Systems, Proc. of the 2nd. Int. Wordshop on OODBS, K.R. Dittrich (ed.), Springer-Verlag, pp. 129–143, 1988Google Scholar
  12. [Diaz91]
    O. Diaz, N. Paton, P. Gray, Rule Management in Object Oriented Databases: A Uniform Approach, Proc. of the 17th Int. Conference on VLDB, Barcelona, pp. 317–326, 1991Google Scholar
  13. [Gatz91]
    S. Gatziu, A. Geppert, K.R. Dittrich, Integrating Active Concepts into an Object-Oriented Database System, Proc. of the 3rd Int. Workshop on Database Programming Languages, Nafplion, August 1991Google Scholar
  14. [Gatz92]
    S. Gatziu, K.R. Dittrich, SAMOS: an Active Object-Oriented Database System, Bulletin of the IEEE Technical Commitee on Data Enginieering, Vol. 15, No. 1–4, December 1992Google Scholar
  15. [Gatz94]
    S. Gatziu, K.R. Dittrich, Detecting Composite Events in Active Database Systems Using Petri Nets, Fourth International Workshop on Research Issues in Data Engineering, Houston, Texas, February 1994Google Scholar
  16. [Geha92a]
    N. H. Gehani, H. V. Jagadish, O.Shmuheli, Composite Event Specification in Active Database Systems, Proc. of the 18th Int. Conference on VLDB, August 1992Google Scholar
  17. [Geha92b]
    N. H. Gehani, H. V. Jagadish, O.Shmuheli, Event Specification in an Active Object-Oriented Database, Proc. of ACM-SIG-MOD Int.'l Conf. on Managment of Data, 1992Google Scholar
  18. [Geha93]
    N. H. Gehani, H. V. Jagadish, O.Shmuheli, COMPOSE — A System for Event Specification and Detection, in Advanced Database Concepts and Research Issues, N.R. Adam, B. Bhargava, LNCS, Springer Verlag 1993Google Scholar
  19. [Kapp92]
    G. Kappel, M. Schrefl, Local Referential Integrity, Proc of the 11th International Conference on Entity-Relationship Approach, G. Pernul and A M. Tjoa (eds), Springer, pp. 41–61, 1992Google Scholar
  20. [Kapp93]
    G. Kappel, S. Rausch-Schott, W. Retschitzegger, S. Vieweg, TriGS — Making a Passive Object-Oriented Database System Active, to be published in: Journal of Object-Oriented Programming (JOOP), 1993Google Scholar
  21. [Kapp94]
    G. Kappel, S. Rausch-Schott, W. Retschitzegger, Beyond Coupling Modes — Implementing Active Concepts on Top of a Commercial OODBMS, submitted for publication, 1994Google Scholar
  22. [Kotz93]
    A. Kotz-Dittrich, Adding Active Functionality to an Object-Oriented Database System — a Layered Approach, Proc. of GI-Conference on Database Systems for Office, Technology and Science, Braunschweig (BRD), W. Stucky, A. Oberweis (eds.), Springer, pp.54–73, March 1993Google Scholar
  23. [McCa89]
    D. R. McCarthy, U. Dayal, The Architecture Of An Active Data Base Management System, Proc. of the ACM-SIGMOD Int.'l Conference on Managment of Data, Portland, Oregon, 1989Google Scholar
  24. [Mede91]
    C. B. Medeiros, P. Pfeffer, Object Integrity Using Rules, European Conference on Object-Oriented Programming (ECOOP), P. America (ed.), Springer LNCS 512, pp. 219–230, 1991Google Scholar
  25. [Röck93]
    B. Röck, M. Schrefl, Active Object-Oriented Database Systems, Technical Report, University of Linz, 1993Google Scholar
  26. [Sche91]
    A.-W. Scheer and A. Hars, The Leitstand — A New Tool for Decentral Production Control, in: Fandel, G. and Zäpfel, G. (eds.), Modern Production Concepts, Springer-Verlag, Berlin, pp. 370–385, 1991Google Scholar
  27. [View94]
    S. Vieweg, G. Kappel, A M. Tjoa, Change Management in Object-Oriented Database Systems, Institute of Applied Computer Science and Information Systems, Univerity of Vienna, 1994 (submitted for publication)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1995

Authors and Affiliations

  • G. Kappel
    • 2
  • S. Rausch-Schott
    • 2
  • W. Retschitzegger
    • 2
  • A. Min Tjoa
    • 1
  • S. Vieweg
    • 1
  • R. Wagner
    • 3
  1. 1.Institute of Applied Computer Science and Information Systems. Department of Information EngineeringUniversity of ViennaAustria
  2. 2.Institute of Computer Science. Department of Information SystemsUniversity of LinzAustria
  3. 3.Research Institute for Applied Knowledge Processing (FAW)University of LinzAustria

Personalised recommendations