Design, implementation and management of rules in an active database system

  • J. Zimmermann
  • H. Branding
  • A. P. Buchmann
  • A. Deutsch
  • A. Geppert
Active and Temporal Aspects 3
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1134)


Active database systems must provide efficient support for event detection and rule execution. Large applications that benefit from facilities offered by active database systems require tools for their whole life cycle — otherwise there will be no acceptance of this new database technology. Therefore, we propose to extend the well-known and broadly accepted OMT design methodology to model classes and rules which have to be mapped onto a rule language. Then we present the rule languages of NAOS, SAMOS, and REACH and compare them from a user's point of view. To improve the rule management REACH offers the facility to organize rules in so-called rule directories which provide a structured name space like UNIX directories for the storage of files. Then we describe a comprehensive set of commands for rules and rule directories, especially an access control mechanism for rules. Additionally browsers for the rules, the rule triggering graph, and the event history are presented, and finally we show how the triggering of rules within applications can be visualized online in a trace mode.


Active database systems object-oriented database systems modelling of rules software life cycle rule languages tools for rule management access control of rules 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Bancilhon, F., Delobel, C., Kanellakis, P. (Eds.); Building an Object-Oriented Database System — The Story of O2. Morgan Kaufmann, 1992.Google Scholar
  2. 2.
    Bichler, P., Schrefl, M.; Active Object-Oriented Database Design using Active Object/Behaviour Diagrams. Proc. 4th RIDE Workshop, 1994.Google Scholar
  3. 3.
    Bouzeghoub, M., Metais, E.; Semantic Modeling of Object Oriented Databases. Proc. 17th Intl. Conf. on Very Large Databases, Barcelona, 1991.Google Scholar
  4. 4.
    Buchmann, A., Branding, H., Kudrass, T., Zimmermann, J.; REACH: a REal-time ACtive and Heterogeneous mediator system, Database Engineering, Vol. 15, 1992.Google Scholar
  5. 5.
    Branding, H., Buchmann, A., Kudrass, T., Zimmermann, J.; Rules in an Open System: The REACH Rule System, 1st RIDS Workshop, 1993.Google Scholar
  6. 6.
    Buchmann, A. P., Zimmermann, J., Blakeley, J. A., Wells, D. L.; Building an Integrated Active OODBMS: Requirements, Architecture, and Design Decisions. Proc. 11th Intl. Conf. on Data Engineering, Taipeh, March 1995.Google Scholar
  7. 7.
    Carey, M., Schneider, D. (Eds.); SIGMOD Record, Vol 24, No 2, June 1995.Google Scholar
  8. 8.
    Chen, P.; The Entity-Relationship Model — Towards a Unified View of Data, in: ACM Transactions on Database Systems, Vol 1, No 1, March 1976, pp 9–36.CrossRefGoogle Scholar
  9. 9.
    Ceri, S., Fraternali, P., Paraboschi, S., Psaila, G.; The Algres Testbed of CHIMERA: An Active Object-Oriented Database System. SIGMOD, 1995.Google Scholar
  10. 10.
    Chakravarthy, S., Krishnaprasad, V., Tamizuddi, Z., Badani, R. H.; ECA Rule Integration into an OODBMS: Architecture and Implementation. Proc. 11th Int. Conf. on Data Engineering, Taipeh (Taiwan), 1995.Google Scholar
  11. 11.
    Collet, S., Coupaye, T., Svensen, T.; NAOS — Efficient and Modular Reactive Capabilities in an Object-Oriented Database System. 20th VLDB, 1994Google Scholar
  12. 12.
    Collet, C., Coupaye, T.; The NAOS v2.0 Demonstration. 5th EDBT, 1996.Google Scholar
  13. 13.
    Dayal, U., Blaustein, B., Buchmann, A., Chakravarthy, S., Goldhirsch, D., Hsu, M., Ladin, R., McCarthy, D., Rosenthal, A.; The HiPAC Project: Combining Active Databases and Timing Constraints. SIGMOD RECORD, Vol. 17, No. 1, March 1988.Google Scholar
  14. 14.
    Dittrich, K.R., Gatziu, S., Geppert, A. (eds); The Active Database Management System Manifesto: A Rulebase of ADBMS Features. 2nd RIDS Workshop, 1995.Google Scholar
  15. 15.
    Fröhlich, M., Werner, M.; Demonstration of the Interactive Graph Visualization System daVinci. In: Tamassia, R., Tollis, I.: Proc. of DIMACS Workshop on Graph Drawing '94; LNCS, Springer Verlag, 1995.Google Scholar
  16. 16.
    Gatziu, S., Dittrich, K. R.; Events in an Active Object-Oriented Database System, 1st RIDS Workshop, 1993.Google Scholar
  17. 17.
    Gatziu, S., Fritschi, H., Vaduva, A.; SAMOS an Active Object-Oriented Database System: Manual. University Zurich, Tech. Report 96.02, 1996.Google Scholar
  18. 18.
    Lamb, C., Landis, G., Orenstein, J., Weinreb, D.; The ObjectStore Database System. Communications of the ACM, Vol 34, No 10, Oct. 1991, pp 34–49.CrossRefGoogle Scholar
  19. 19.
    Rumbaugh, J., Blaha, M., Premerlani, W., Eddy, F., Lorensen, W.; Object-Oriented Modeling and Design. Prentice Hall, 1991.Google Scholar
  20. 20.
    Weinand, A., Gamma, E., Marty, R.; ET++ — An Object-Oriented Application Framework in C++. OOPSLA, 1988.Google Scholar
  21. 21.
    Wells, D. L., Blakeley, J. A., Thompson, C. W.; Architecture of an Open Object-Oriented Database Management System. IEEE Computer, 25(10), 1992.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1996

Authors and Affiliations

  • J. Zimmermann
    • 1
  • H. Branding
    • 1
  • A. P. Buchmann
    • 1
  • A. Deutsch
    • 1
  • A. Geppert
    • 2
  1. 1.University of DarmstadtDarmstadtGermany
  2. 2.University of ZurichZurichSwitzerland

Personalised recommendations