Selecting actions to trigger in active database applications

  • Huang-Cheng Kuo
  • Gültekin özsoyoğlu
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1460)


This paper studies the problem of selecting rules to fire in real-time active databases in order to avoid missing action deadlines. We give an algorithm that executes at every fixed time interval (called the Rule Selection Period), and satisfies three properties, namely, the Completion Property, the Duration Property, and the Priority Property. We develop a probabilistic model, and an inexpensive (polynomial-time) algorithm for the satisfaction of the Completion Property. We show that the problem of satisfying the Duration and the Priority Properties at the same time is NP-Complete. We then give two heuristic-based algorithms, and briefly summarize the associated experimental results.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [AHW95]
    Aiken, A., Hellerstein, J.M., and Widom, J., “Static Analysis Techniques for Predicting the Behavior of Active Database Rules”, ACM TODS, Vol. 20, No. 1., March 1995.Google Scholar
  2. [BCP96]
    Baralis, E., Ceri, S., and Paraboschi, S., “Modularization Techniques for Active Rules Design”, ACM TODS, Vol. 2, No. 1, March 1996.Google Scholar
  3. [Chak92]
    Chakravarthy, S., Special Issue on Active Databases, IEEE Bulletin of the TC on Data Engineering, Vol. 15, No. 1–4, December 1992.Google Scholar
  4. [CKTB95]
    Chakravarthy, S., Krishnaprasad, V., Tamizuddin, Z., Badana, R.H., “ECA Rule Integration into an OODBMS: Architecture and Implementation”, IEEE ICDE Conf., February 1995.Google Scholar
  5. [Doug90]
    Dougherty, E.R., Probability and Statics for the Engineering, Computing, and Physical Sciences, Prentice-Hall, 1990.Google Scholar
  6. [Kuo97]
    Kuo, H.-C., “A Rule-Based Cooperative Transaction Model and Event Processing in Real-Time Active Database Systems”, Ph.D. Dissertation, Dept of Computer Eng. and Sci., Case Western Reserve University, Feb. 1997.Google Scholar
  7. [OzSn95]
    özsoyoğlu, G. and Snodgrass, R., “Temporal and Real-Time Databases: A Survey”, IEEE TKDE, Vol. 7, No. 4, August 1995.Google Scholar
  8. [WiCe96]
    Widom, J. and Ceri, S., (ed.) Active Database Systems: Triggers and Rules For Advanced Database Processing Morgan Kaufmann Pub., 1996.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1998

Authors and Affiliations

  • Huang-Cheng Kuo
    • 1
  • Gültekin özsoyoğlu
    • 1
  1. 1.Department of Computer Engineering and ScienceCase Western Reserve UniversityCleveland

Personalised recommendations