Set-oriented production rules in relational database systems

1 May 1990

journal article
Published by Association for Computing Machinery (ACM) in ACM SIGMOD Record

Vol. 19 (2) , 259-270
https://doi.org/10.1145/93605.98735

Abstract

We propose incorporating a production rules facility into a relational database system. Such a facility allows definition of database operations that are automatically executed whenever certain conditions are met. In keeping with the set-oriented approach of relational data manipulation languages, our production rules are also set-oriented—they are triggered by sets of changes to the database and may perform sets of changes. The condition and action parts of our production rules may refer to the current state of the database as well as to the sets of changes triggering the rules. We define a syntax for production rule definition as an extension to SQL. A model of system behavior is used to give an exact semantics for production rule execution, taking into account externally-generated operations, self-triggering rules, and simultaneous triggering of multiple rules.

Keywords

This publication has 11 references indexed in Scilit:

On rules, procedure, caching and views in data base systems
Published by Association for Computing Machinery (ACM) ,1990
An initial report on the design of Ariel DBMS with an integrated production rule system
ACM SIGMOD Record, 1989
Extensible query processing in starburst
Published by Association for Computing Machinery (ACM) ,1989
Compiling complex database transition triggers
Published by Association for Computing Machinery (ACM) ,1989
The architecture of an active database management system
Published by Association for Computing Machinery (ACM) ,1989
The POSTGRES rule manager
IEEE Transactions on Software Engineering, 1988
Implementing large production systems in a DBMS environment: concepts and algorithms
Published by Association for Computing Machinery (ACM) ,1988
Supporting semantic rules by a generalized event/trigger mechanism
Published by Springer Nature ,1988
A data management extension architecture
Published by Association for Computing Machinery (ACM) ,1987
A relational model of data for large shared data banks
Communications of the ACM, 1970