Case studies on active database applications

  • H. -J. Appelrath
  • H. Behrends
  • H. Jasper
  • O. Zukunft
Active and Temporal Aspects 1
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1134)


Active databases provide event-condition-action-rules for the implementation of (re)active behaviour in database applications. There exist a lot of proposals for such language extensions as well as some reported implementations. Usually, the suggested features are motivated by application requirements. In contrast, there is a severe lack of reported experiences with applications. Thus, there is no way to judge on the usefulness of the proposals given in the various technical papers up to now. This paper presents first results on the application of active database technology to real-world problems.

In our experimental setting an enhanced active rule language on top of a commercial database management system was used. Three real-world application domains were studied. They encompass the areas of executive information systems (maintaining derived data), cancer clustering (knowledge discovery in databases), and software process management (process management and control). Active capabilities proved to be especially useful for the implementation of the flow of control between various subsystems. Deficiencies of the technology were due to the lack of both modelling and design techniques as well as strong database functionality regarding multi-user mechanisms for the active part of the DBMS.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [ABJK94]
    H.-J. Appelrath, H. Behrends, H. Jasper, and V. Kamp. Active database technology supports cancer clustering. In Proc. First Intl. Conf. on Applications of Databases (ADB-94), LNCS 819, pages 351–364, 1994.Google Scholar
  2. [Beh94]
    H. Behrends. Simulation-based debugging of active databases. In Proc. 4. Intl. Workshop on Research Issues in Data Engineering, pages 172–180, Houston, USA, 1994.Google Scholar
  3. [Ber94]
    M. Berndtsson. Reactive object-oriented databases and CIM. In Proc. 5th Intl. Conf. on Database and Expert Systems Applications, pages 769–778, 1994.Google Scholar
  4. [BZBW95]
    A. Buchmann, J. Zimmermann, J. A. Blakeley, and D. L. Wells. Building an integrated active OODBMS: Requirements, architecture, and design decisions. In Proc. 11th Intl. Conf. on Data Engineering (ICDE 95), 1995.Google Scholar
  5. [CKAK94]
    S. Chakravarthy, V. Krishnaprasad, E. Anwar, and S.-K. Kim. Composite events for active databases: Semantics, contexts and detection. In Proc. 20th Intl. Conf. on Very Large Data Bases (VLDB 94), 1994.Google Scholar
  6. [CW90]
    S. Ceri and J. Widom. Deriving production rules for constraint maintenance. In Proc. Intl. Conf. on Very Large Data Bases, pages 566–577, Brisbane, Australia, 1990.Google Scholar
  7. [CW94]
    S. Ceri and J. Widom. Deriving incremental production rules for deductive data. Information Systems, 18:467–490, 1994.CrossRefGoogle Scholar
  8. [DBB+88]
    U. Dayal, B. Blaustein, A. Buchmann, U. Chakravarthy, M. Hsu, R. Ledin, D. McCarthy, A. Rosenthal, S. Sarin, M. J. Carey, M. Livny, and R. Jauhari. The HiPAC project: Combining active databases and timing constraints. SIGMOD Record, 17:51–70, 1988.CrossRefGoogle Scholar
  9. [DGG95]
    K. R. Dittrich, S. Gatziu, and A. Geppert. The active database management systems manifesto. In Proc. 2nd. Intl. Workshop on Rules in Database Systems. LNCS 985, pages 3–17, Athens, Greece, 1995. Springer.Google Scholar
  10. [DJPa94]
    O. Diaz, A. Jaime, N. W. Paton, and G. Al-Qaimari. Supporting dynamic displays using active rules. SIGMOD Record, 23:21–26, 1994.CrossRefGoogle Scholar
  11. [Esw76]
    K. P. Eswaran. Aspects of a trigger subsystem in an integrated database system. In Proc. Intl. Conf. on Software Engineering, pages 243–250, 1976.Google Scholar
  12. [GD92]
    S. Gatziu and K. R. Dittrich. SAMOS: an active, object-oriented database system. IEEE Data Engineering Bulletin, 15:1–4, 1992.Google Scholar
  13. [GD93]
    A. Geppert and K. R. Dittrich. Rule-based implementation of transaction model specifications. In First Intl. Workshop on Rules in Database Systems, Edinburgh, 1993.Google Scholar
  14. [Jas94]
    H. Jasper. Active databases for active repositories. In Proc. 10. Intl. Conference on Data Engineering, pages 375–384, Houston, USA, 1994.Google Scholar
  15. [JZB95]
    H. Jasper, O. Zukunft, and H. Behrends. Time issues in advanced workflow management applications of active databases. In Proc. First Intl. Workshop on Active and Real-Time Database Systems, pages 65–81, 1995. Springer.Google Scholar
  16. [KNHH94]
    H. Kawano, S. Nishio, J. Han, and T. Hasegawa. How does knowledge discovery cooperate with active database techniques in controlling dynamic environment? In Proc. 5th Intl. Conf. on Database and Expert Systems Applications (DEXA 94), pages 370–379, Athen, 1994.Google Scholar
  17. [Kot94]
    A. Kotz-Dittrich. Active database functionality in a real-world banking environment. Technical Report 01-94, ACT-NET, 1994.Google Scholar
  18. [SKD95]
    E. Simon and A. Kotz-Dittrich. Promises and realities of active database systems. In Proc. Intl. Conf. on Very Large Data Bases, pages 642–653, 1995.Google Scholar
  19. [WCL91]
    J. Widom, R. J. Cochrane, and B. G. Lindsay. Implementing set-oriented production rules as an extension to starburst. In Proc. Intl. Conf. on Very Large Data Bases, pages 275–285, Barcelona, Spain, 1991.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1996

Authors and Affiliations

  • H. -J. Appelrath
    • 1
  • H. Behrends
    • 1
  • H. Jasper
    • 1
  • O. Zukunft
    • 1
  1. 1.Fachbereich InformatikUniversität OldenburgOldenburg

Personalised recommendations