Skip to main content
SpringerLink
Log in

Ten Years of Activity in Active Database Systems: What Have We Accomplished?

  • Conference paper
Book cover Active and Real-Time Database Systems (ARTDB-95)

Part of the book series: Workshops in Computing ((WORKSHOPS COMP.))

Abstract

Over the last few years, active database systems have become a rather active area of research. This paper traces the history of research and development in this important area, highlighting the key paradigms and concepts. We examine the state of research today and its impact on commercial practice. We conclude with suggestions to researchers as to how they can increase the relevance of their work to commercial products, and hence the extent to which active database concepts will be widely used in practice.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. SQL3 Document X3H2-94-080, ISO-ANSI Workking Draft, Database Language SQL, 1994.

    Google Scholar 

  2. A. Aiken, J. Widom, and J. M. Hellerstein. Behavior of database production rules: Termination, confluence, and observable determinism. In Proceedings of the ACM SIGMOD International Conference on Management of Data, pages 59–68, San Diego, California, June 1992.

    Google Scholar 

  3. A. P. Buchmann, H. Branding, T. Kudrass, and J. Zimmerman. REACH: A Real-time Active and Heterogeneous Mediator System. IEEE Data Engineering Bulletin, Special Issue on Active Database Systems, Vol. 15, No. 4, June 1992.

    Google Scholar 

  4. O. P. Buneman and E. K. Clemons. Efficiently monitoring relational databases. ACM Transactions on Database Systems, 4(3):368–382, September 1979.

    Article  Google Scholar 

  5. M. Berndtsson and B. Lings. On Developing Reactive Object-Oriented Databases. IEEE Data Engineering Bulletin, Special Issue on Active Database Systems, Vol. 15, No. 4, June 1992.

    Google Scholar 

  6. A. Buchmann, M. T. Ozsu, M. Hornick, D. Georgakopoulos, and F. Manola. A Transaction Model for Active, Distributed Object Systems. In Database Transaction Models For Advanced Applications. (A. K. Elma-garmid, ed.). Morgan Kaufmann Pub. Inc. 1992.

    Google Scholar 

  7. S. Chakravarthy, E. Anwar, L. Maugis, and D. Mishra. Design of Sentinel: An object-oriented dbms with event-based rules. Information and Software Technology, 36(9):559–568, 1994.

    Article  Google Scholar 

  8. S. Chakravarthy, B. Blaustein, A.P. Buchmann, M. Carey, U. Dayai, D. Goldhirsch, M. Hsu, R. Jauhari, R. Ladin, M. Livny, D. McCarthy, R. McKee, and A. Rosenthal. HiPAC: A research project in active, time-constrained database management. Technical Report XAIT-89-02, Xerox Advanced Information Technology, Cambridge, Massachusetts, July 1989.

    Google Scholar 

  9. C. Collet, T. Coupaye, T. Svensen. NAOS Efficient and Modular Reactive Capabilities in an Object-Oriented Database System. In Proceedings of the 20th International Conference on Very Large Data Bases, Santiago, Chile, Sept. 1994.

    Google Scholar 

  10. M. J. Carey, R. Jauhari, and M. Livny. On transaction boundaries in active databases: A performance perspective. IEEE Transactions on Knowledge and Data Engineering, 3(3), September 1991.

    Google Scholar 

  11. S. Chakravarthy, V. Krishnaprasad, E. Anwar, and S.-K. Kim. Composite Events for Active Databases: Semantics, Contexts, and Detection. In Proceedings, International Conference on Very Large Data Bases, pages 606–617, August 1994.

    Google Scholar 

  12. S. Chakravarthy and D. Mishra. Snoop: An Expressive Event Specification Language for Active Databases. Data and Knowledge Engineering, 14(10):1–26, October 1994.

    Article  Google Scholar 

  13. CODASYL Data Description Language Committee. CODASYL Data Description Language Journal of Development, NBS Handbook 113, June 1973.

    Google Scholar 

  14. S. Ceri and J. Widom. Deriving production rules for constraint maintenance. In Proceedings of the Sixteenth International Conference on Very Large Data Bases, pages 566–577, Brisbane, Australia, August 1990.

    Google Scholar 

  15. S. Ceri and J. Widom. Deriving production rules for incremental view maintenance. In Proceedings of the Seventeenth International Conference on Very Large Data Bases, pages 577–589, Barcelona, Spain, September 1991.

    Google Scholar 

  16. U. Dayal. Active database management systems. In Proceedings of the Third International Conference on Data and Knowledge Bases, pages 150–169, Jerusalem, Israel, June 1988.

    Google Scholar 

  17. U. Dayal, B. Blaustein, A. Buchmann, S. Chakravarthy, M. Hsu, R. Ladin, 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(1), March 1988.

    Google Scholar 

  18. U. Dayal, A. P. Buchmann, and D. R. McCarthy. Rules are objects too: A knowledge model for an active, object-oriented database system. In Proceedings of the Second International Workshop on Object-Oriented Database Systems, Lecture Notes in Computer Science 334-Springer-Verlag, Berlin, 1988.

    Google Scholar 

  19. K. Dittrich and U. Dayal. Tutorial Notes on Active Database Systems. International Conference on Very Large Database Systems, Barcelona, Spain, Spet. 1991.

    Google Scholar 

  20. L. M. L. Delcambre and J. N. Etheredge. The Relational Production Language: A production language for relational databases. In L. Kerschberg, editor, Expert Database Systems — Proceedings from the Second International Conference, pages 333–351. Benjamin/Cummings, Redwood City, California, 1989.

    Google Scholar 

  21. U. Dayal, M. Hsu, and R. Ladin. Organizing long-running activities with triggers and transactions. In Proceedings, ACM SIGMOD International Conference on Management of Data, pages 204–214, Atlantic City, New Jersey, May 1990.

    Google Scholar 

  22. U. Dayai, M. Hsu, and R. Ladin. A transactional model for long running activities. In Proceedings of the Seventeenth International Conference on Very Large Data Bases, pages 113–122, Barcelona, Spain, September 1991.

    Google Scholar 

  23. U. Dayai, H. Y. Hwang, F. Manola, A. Rosenthal, and J. M. Smith. Knowledge-Oriented Database Management. Phase 1 Final Technical Report, Computer Corporation of America, Cambridge, MA, Aug. 1994.

    Google Scholar 

  24. H. M. Dewan, D. Ohsie, S. J. Stolfo, O. Wolfson, and S. Da Silva. Incremental Database Rule Processing in PARADISER. Journal of Intelligent Information Systems, 1992.

    Google Scholar 

  25. O. Diaz, N. Patom, and P. Gray. Rule management in object-oriented databases: A uniform approach. In Proceedings of the Seventeenth International Conference on Very Large Data Bases, pages 317–326, Barcelona, Spain, September 1991.

    Google Scholar 

  26. K. P. Eswaran and D. D. Chamberlin. Functional specifications of a subsystem for data base integrity. In Proceedings of the First International Conference on Very Large Data Bases, pages 48–67, Framingham, Massachusetts, September 1975.

    Google Scholar 

  27. K. P. Eswaran. Specifications, implementations and interactions of a trigger subsystem in an integrated database system. IBM Research Report RJ 1820, IBM San Jose Research Laboratory, San Jose, California, August 1976.

    Google Scholar 

  28. P. Fraternali, D. Montesi, and L. Tanca. Active Database Semantics. In Proceedings of the Fifth Australian Database Conference, University of Canterbury, New Zealand, Jan. 1984.

    Google Scholar 

  29. S. Gatziu, A. Geppert, and K. R. Dittrich. Integrating active concepts into an object-oriented database system. In Proceedings of the Third International Workshop on Database Programming Languages, Nafplion, Greece, August 1991.

    Google Scholar 

  30. N. Gehani and H. V. Jagadish. Ode as an active database: Constraints and triggers. In Proceedings of the Seventeenth International Conference on Very Large Data Bases, pages 327–336, Barcelona, Spain, September 1991.

    Google Scholar 

  31. N. Gehani, H. V. Jagadish, and O. Shmueli. Composite event specification in active databases: Model & implementation. In Proceedings of the Eighteenth International Conference on Very Large Data Bases, pages 327–338, Vancouver, British Columbia, August 1992.

    Google Scholar 

  32. E. N. Hanson. An initial report on the design of Ariel: A DBMS with an integrated production rule system. SIGMOD Record, Special Issue on Rule Management and Processing in Expert Database Systems, 18(3):12–19, September 1989.

    Google Scholar 

  33. M. Hsu, R. Ladin, and D. McCarthy. An execution model for active database management systems. In Proceedings of the Third International Conference on Data and Knowledge Bases, Jerusalem, Israel, June 1988.

    Google Scholar 

  34. IBM. IMS/VS Application Programming Reference Manual SH20-9026, IBM, White Plains, NY, 1978.

    Google Scholar 

  35. A. M. Kotz, K. R. Dittrich, and J. A. Mulle. Supporting semantic rules by a generalized event/trigger mechanism. In Advances in Database Technology — EDBT’ 88, Lecture Notes in Computer Science 303, pages 76–91. Springer-Verlag, Berlin, March 1988.

    Google Scholar 

  36. M. Morgenstern. Active databases as a paradigm for enhanced computing environments. In Proceedings of the Ninth International Conference on Very Large Data Bases, pages 34–42, Florence, Italy, October 1983.

    Google Scholar 

  37. J. Melton and A. R. Simon. Understanding the New SQL: A Complete Guide. Morgan Kaufmann Pub., San Mateo, CA, 1993.

    Google Scholar 

  38. S. B. Navathe, A. K. Tanaka, and S. Chakravarthy. “Active Database Modeling and Design Tools: Issues, Approach, and Architecture”, IEEE Data Engineering Bulletin, Special Issue on Active Database Systems, Vol. 15, No. 4, June 1992.

    Google Scholar 

  39. R. Cattell, ed. The Object Database Standard: ODMG-93. Morgan Kaufmann, San Mateo, CA, 1994.

    Google Scholar 

  40. Object Management Group. Common Object Services Specification, Volume I. OMG Document No. 94-1-1.

    Google Scholar 

  41. T. Risch. Monitoring database objects. In Proceedings of the Fifteenth International Conference on Very Large Data Bases, Amsterdam, The Netherlands, August 1989.

    Google Scholar 

  42. M. Stonebraker et al. A Rules System for Relational Data Base Management Systems. Proceedings of the Second International Conference on Databases, Jerusalem, June 1982.

    Google Scholar 

  43. M. Stonebraker, E. N. Hanson, and S. Potamianos. The POSTGRES rule manager. IEEE Transactions on Software Engineering, 14(7):897–907, July 1988.

    Article  Google Scholar 

  44. M. Stonebraker, A. Jhingran, J. Goh, and S. Potamianos. On rules, procedures, caching and views in data base systems. In Proceedings of the ACM SIGMOD International Conference on Management of Data, pages 281–290, Atlantic City, New Jersey, May 1990.

    Google Scholar 

  45. E. Simon, J. Kiernan, and C. de Maindreville. Implementing high level active rules on top of a relational DBMS. In Proceedings of the Eighteenth International Conference on Very Large Data Bases, pages 315–326, Vancouver, British Columbia, August 1992.

    Google Scholar 

  46. T. Sellis, C.-C. Lin, and L. Raschid. Implementing large production systems in a DBMS environment: Concepts and algorithms. In Proceedings of the ACM SIGMOD International Conference on Management of Data, pages 404–412, Chicago, Illinois, June 1988.

    Google Scholar 

  47. A. P. Sistla and O. Wolfson. Temporal Conditions and Integrity Constraints in Active Database Systems. In Proceedings of the ACM SIGMOD International Conference on Management of Data, San Jose, CA, June 1995.

    Google Scholar 

  48. Sybase, Inc. Transact SQL User’s Guide, 1987.

    Google Scholar 

  49. J. Widom and S. J. Finkelstein. Set-oriented production rules in relational database systems. In Proceedings of the ACM SIGMOD International Conference on Management of Data, pages 259–270, Atlantic City, New Jersey, May 1990.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Hewlett-Packard Laboratories, 1501 Page Mill Road, Palo Alto, CA, 94304, USA

    Umeshwar Dayal

Authors
  1. Umeshwar Dayal
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Computer Science, University of Skövde, PO Box 408, S-541 28, Skövde, Sweden

    Mikael Berndtsson MSc  & Jörgen Hansson MSc  & 

Rights and permissions

Reprints and permissions

Copyright information

© 1996 British Computer Society

About this paper

Cite this paper

Dayal, U. (1996). Ten Years of Activity in Active Database Systems: What Have We Accomplished?. In: Berndtsson, M., Hansson, J. (eds) Active and Real-Time Database Systems (ARTDB-95). Workshops in Computing. Springer, London. https://doi.org/10.1007/978-1-4471-3080-2_1

Download citation

  • DOI: https://doi.org/10.1007/978-1-4471-3080-2_1

  • Publisher Name: Springer, London

  • Print ISBN: 978-3-540-19983-0

  • Online ISBN: 978-1-4471-3080-2

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation