This Article 
 Bibliographic References 
 Add to: 
Early Active Database Efforts: A Capsule Summary
December 1995 (vol. 7 no. 6)
pp. 1008-1010

Abstract—Over the past few years, the topic of active databases has become an important area of research. A number of efforts—both research prototypes and commercial database management systems (DBMSs)—have addressed support for event-condition-action (ECA) rule in databases. This paper examines the motivations for providing this capability, identifies features that form the basis for supporting active functionality and provides a capsule summary of active database features of early commercial systems as well as research prototypes. Three broad categories—rule expressiveness, execution semantics, and efficiency—are used for the capsule summary.

[1] S. Chakravarthy,“Divide and conquer: A basis for augmenting a conventional query optimizer with multiple query processing capabilities,” Proc. Seventh Int’l Conf. Data Eng., pp. 482-490,Kobe, Japan, Apr. 1991.
[2] S. Chakravarthy,E. Anwar,L. Maugis,, and D. Mishra,“Design of Sentinel: An object-oriented DBMS with event-based rules,” Information and Software Technology, vol. 36, no. 9, pp. 559-568, 1994.
[3] S. Chakravarthy et al.,“HiPAC: A research project in active, time-constrained database management,” Technical Report XAIT-89-02, Xerox Advanced Information Tech nology, Cambridge, Mass., Aug. 1989.
[4] S. Chakravarthy,S.B. Navathe,S. Garg,D. Mishra,, and A. Sharma,“An evaluation of active DBMS developments,” Technical Report UF-CIS TR-90-23, Database Systems R&D Ctr., CIS Dept.,Univ. of Florida, Sept. 1990.
[5] U. Dayal,A. Buchmann,, and D. McCarthy,“Rules are objects too: A knowledge model for an active, object-oriented database management system,” Proc. Second Int’l Workshop Object-Oriented Database Systems, Bad Muenster am Stein, Ebernburg, West Germany, Sept. 1988.
[6] O. Diaz,N. Paton,, and P. Gray,“Rule management in object-oriented databases: A unified approach,” Proc. 17th Int’l Conf. Very Large Data Bases,Barcelona, Spain, Sept. 1991.
[7] S. Dietrich,S. Urban,J. Harrison,, and A. Karadimice,“A DOOD Ranch at ASU: Integrating active, deductive, and object-oriented databases,” IEEE Quarterly Bull. Data Eng., vol. 15, nos. 1-4, pp. 40-44, Dec. 1992.
[8] “(ISO/ANSI) Working draft database language SQL (SQL3),” J. Melton, ed., x3h2-93-091/dbl yok-003, Feb. 1993.
[9] IEEE Bull. Technical Committee on Data Eng., special issue on active databases, S. Chakravarthy, guest ed., Dec. 1992.
[10] S. Gatziu and K.R. Dittrich,“Events in an object-oriented database system,” Proc. First Int’l Conf. Rules in Database Systems, Sept. 1993.
[11] N. Gehani and H. Jagadish,"Ode as an active database: Constraints and triggers," Proc. 17th Int'l Conf. Very Large Data Bases, Sept. 1991.
[12] M. Hsu,R. Ladin,, and D. McCarthy,“An execution model for active data base management systems,” Proc. Third Int’l Conf. Data and Knowledge Bases,Washington, D.C., June 1988.
[13] Interbase Software Corp., Interbase DDL Reference Manual, Version 3.0.Bedford, Mass., 1990.
[14] A. Kotz,K. Dittrich,, and J. Mulle,“Supporting semantic rules by a generalized event/trigger mechanism,” Proc. Int’l Conf. Extending Database Technology,Venice, Mar. 1988.
[15] A. Rosenthal and S. Chakravarthy,“Anatomy of a modular multiple query optimizer,” Proc. Int’l Conf. Very Large Data Bases, pp. 230-239,Los Angeles, Sept. 1988.
[16] T. Sellis,“Global query optimization,” Proc. SIGMOD, pp. 191-205, 1986.
[17] Y.-M. Shyy and S.Y.W. Su,“K: A high-level knowledge base programming language,” Proc. Int’l Conf. Management of Data, pp. 29-31,Denver, May 1991.
[18] M. Stonebraker,“The integration of rule systems and database systems,” IEEE Trans. Knowledge and Data Eng., vol. 4, no. 4, pp. 415-423, Oct. 1992.
[19] Transact-SQL User’s Guide, Release 4.2, Sybase Inc., Berkeley, Calif., May 1990.
[20] J. Widom and S.J. Finkelstein,"Set-oriented production rules in relational database systems," Proc. 1990 ACM SIGMOD Int'l Conf. Management of Data, pp. 259-270, 1990.

Index Terms:
Active functionality, event-condition-action rules, rule execution.
Sharma Chakravarthy, "Early Active Database Efforts: A Capsule Summary," IEEE Transactions on Knowledge and Data Engineering, vol. 7, no. 6, pp. 1008-1010, Dec. 1995, doi:10.1109/69.476505
Usage of this product signifies your acceptance of the Terms of Use.