Abstract
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.
Preview
Unable to display preview. Download preview PDF.
References
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.
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.
M. Berndtsson. Reactive object-oriented databases and CIM. In Proc. 5th Intl. Conf. on Database and Expert Systems Applications, pages 769–778, 1994.
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.
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.
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.
S. Ceri and J. Widom. Deriving incremental production rules for deductive data. Information Systems, 18:467–490, 1994.
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.
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.
O. Diaz, A. Jaime, N. W. Paton, and G. Al-Qaimari. Supporting dynamic displays using active rules. SIGMOD Record, 23:21–26, 1994.
K. P. Eswaran. Aspects of a trigger subsystem in an integrated database system. In Proc. Intl. Conf. on Software Engineering, pages 243–250, 1976.
S. Gatziu and K. R. Dittrich. SAMOS: an active, object-oriented database system. IEEE Data Engineering Bulletin, 15:1–4, 1992.
A. Geppert and K. R. Dittrich. Rule-based implementation of transaction model specifications. In First Intl. Workshop on Rules in Database Systems, Edinburgh, 1993.
H. Jasper. Active databases for active repositories. In Proc. 10. Intl. Conference on Data Engineering, pages 375–384, Houston, USA, 1994.
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.
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.
A. Kotz-Dittrich. Active database functionality in a real-world banking environment. Technical Report 01-94, ACT-NET, 1994.
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.
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.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1996 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Appelrath, H.J., Behrends, H., Jasper, H., Zukunft, O. (1996). Case studies on active database applications. In: Wagner, R.R., Thoma, H. (eds) Database and Expert Systems Applications. DEXA 1996. Lecture Notes in Computer Science, vol 1134. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0034671
Download citation
DOI: https://doi.org/10.1007/BFb0034671
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-61656-6
Online ISBN: 978-3-540-70651-9
eBook Packages: Springer Book Archive