Alert: An Architecture for Transforming a Passive DBMS into an Active DBMS

Alert is an extension architecture designed for transforming a passive SQL DBMS into. an active DBMS. The salient features of the design of Alert are reusing, to the extent possible, the passive DBMS technology, and making minimal changes to the language and implementation of the passive DBMS. Alert provides a layered architecture that allows the semantics of a variety of production rule languages to be supported on top. Rules may be specified on userdefined as well as built-in operations. Both synchronous and asynchronous event, monit,oring are possible. This paper presents the design of Alert and its implementation in the Starburst extensible DBMS.

[1]  Hamid Pirahesh,et al.  Extensible query processing in starburst , 1989, SIGMOD '89.

[2]  Michael Stonebraker,et al.  A commentary on the POSTGRES rules system , 1989, SGMD.

[3]  Timos K. Sellis,et al.  Implementing large production systems in a DBMS environment: concepts and algorithms , 1988, SIGMOD '88.

[4]  Charles L. Forgy,et al.  OPS5 user's manual , 1981 .

[5]  Daniel G. Bobrow,et al.  On Overview of KRL, a Knowledge Representation Language , 1976, Cogn. Sci..

[6]  Michael Stonebraker,et al.  The POSTGRES Rule Manager , 1988, IEEE Trans. Software Eng..

[7]  Umeshwar Dayal,et al.  The HiPAC project: combining active databases and timing constraints , 1988, SGMD.

[8]  Umeshwar Dayal,et al.  The architecture of an active database management system , 1989, SIGMOD '89.

[9]  Eric N. Hanson,et al.  A predicate matching algorithm for database rule systems , 1990, SIGMOD '90.

[10]  Charles Lanny Forgy,et al.  On the efficient implementation of production systems. , 1979 .

[11]  M. Darnovsky,et al.  TRANSACT-SQL USER''S GUIDE , 1987 .

[12]  Meichun Hsu,et al.  An Execution Model for Active Data Base Management Systems , 1988, JCDKB.

[13]  Jennifer Widom,et al.  Implementing Set-Oriented Production Rules as an Extension to Starburst , 1991, VLDB.

[14]  Irving L. Traiger,et al.  Granularity of Locks and Degrees of Consistency in a Shared Data Base , 1998, IFIP Working Conference on Modelling in Data Base Management Systems.

[15]  Hamid Pirahesh,et al.  Parallelism in relational data base systems: architectural issues and design approaches , 1990, DPDS '90.

[16]  Jennifer Widom,et al.  Set-oriented production rules in relational database systems , 1990, SIGMOD '90.

[17]  Setsuo Ohsuga,et al.  INTERNATIONAL CONFERENCE ON VERY LARGE DATA BASES , 1977 .

[18]  Sharma Chakravarthy,et al.  Situation Monitoring for Active Databases , 1989, VLDB.

[19]  Hamid Pirahesh,et al.  A data management extension architecture , 1987, SIGMOD '87.

[20]  Hamid Pirahesh,et al.  Starburst Mid-Flight: As the Dust Clears , 1990, IEEE Trans. Knowl. Data Eng..

[21]  Michael Stonebraker,et al.  The Implementation of Postgres , 1990, IEEE Trans. Knowl. Data Eng..

[22]  Victor M. Markowitz,et al.  Referential Integrity Revisited: An Object-Oriented Perspective , 1990, VLDB.

[23]  Michael Stonebraker,et al.  On rules, procedure, caching and views in data base systems , 1990, SIGMOD '90.