DBScholar

Back to papers

Set-Oriented Production Rules in Relational Database Systems

Summary: Introduces a production-rules facility in relational DBs, enabling set-oriented rules triggered by changes and updates. Extends SQL with a rule-definition syntax and an exact semantics model for external ops, self-triggering rules, and concurrent firing. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
hfb1df16a06c82bb0
Venue
SIGMOD
Year
1990
Pagerank
0.00014359198
Overall Rank
737 | 95.05%
DOI
10.1145/93597.98735

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{widom_sigmod90,
        title = {{Set-Oriented Production Rules in Relational Database Systems}},
        author = {Widom, Jennifer and Finkelstein, Sheldon J.},
        series = {{SIGMOD} '90},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/93597.98735},
        url = {https://dl.acm.org/doi/10.1145/93597.98735},
        year = {1990}
}

Incoming Citations (Sorted by Pagerank)

Showing 21 of 21 citing papers.

Rank Citing Paper Year Venue Pagerank
25 NiagaraCQ: A Scalable Continuous Query System for Internet Databases 2000 SIGMOD 0.00053930011
246 Deriving Production Rules for Incremental View Maintenance 1991 VLDB 0.00023212582
247 Efficient Filtering of XML Documents for Selective Dissemination of Information 2000 VLDB 0.00023199427
581 Alert: An Architecture for Transforming a Passive DBMS into an Active DBMS 1991 VLDB 0.00015984359
1,372 Deriving Production Rules for Constraint Maintenance 1990 VLDB 0.00010898439
1,627 Implementing Set-Oriented Production Rules as an Extension to Starburst 1991 VLDB 0.00010038961
2,546 A Model for Active Object Oriented Database 1991 VLDB 8.3177548e-05
2,848 On Maintaining Priorities in a Production Rule System 1991 VLDB 7.9429561e-05
2,988 A Method for Change Computation in Deductive Databases 1992 VLDB 7.7771712e-05
3,185 Language Constructs for Programming Active Databases 1991 VLDB 7.556677e-05
3,637 Ode as an Active Database: Constraints and Triggers 1991 VLDB 7.1462234e-05
3,864 On Implementing a Language for Specifying Active Database Execution Models 1993 VLDB 6.9626898e-05
3,894 Behavior of Database Production Rules: Termination, Confluence, and Observable Determinism 1992 SIGMOD 6.9395397e-05
4,120 Temporal Conditions and Integrity Constraints in Active Database Systems 1995 SIGMOD 6.7947455e-05
5,395 Semantics and Expressiveness Issues in Active Databases 1995 PODS 6.1496965e-05
6,588 Managing Conflicts between Rules 1996 PODS 5.742847e-05
8,512 Set-Oriented Constructs: From Rete Rule Bases to Database Systems 1991 SIGMOD 5.3255942e-05
8,925 Monitoring Business Processes with Queries 2007 VLDB 5.2559789e-05
9,208 A New Perspective on Rule Support for Object-Oriented Databases* 1993 SIGMOD 5.2067706e-05
13,382 Updates in a Rule-Based Language for Objects 1992 VLDB 4.9793485e-05
13,384 Production Rules in Parallel and Distributed Database Environments 1992 VLDB 4.9793485e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
147 On Rules, Procedures, Caching And Views In Data Base Systems 1990 SIGMOD 0.00029019485
203 The Architecture Of An Active Data Base Management System* 1989 SIGMOD 0.00025229522
273 Extensible Query Processing in Starburst 1989 SIGMOD 0.00022504729
610 Active Databases as a Paradigm for Enhanced Computing Environments 1983 VLDB 0.0001558453
1,372 Deriving Production Rules for Constraint Maintenance 1990 VLDB 0.00010898439
1,464 Implementing Large Production Systems in a DBMS Environment: Concepts and Algorithms 1988 SIGMOD 0.00010580339
2,333 Compiling complex database transition triggers 1989 SIGMOD 8.6255214e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 1,464 Implementing Large Production Systems in a DBMS Environment: Concepts and Algorithms 1988 SIGMOD
2 6,892 Modelling Non Deterministic Queries and Updates In Deductive Databases 1988 VLDB
3 13,384 Production Rules in Parallel and Distributed Database Environments 1992 VLDB
4 6,470 An Adaptive Algorithm for Incremental Evaluation of Production Rules in Databases 1993 VLDB
5 8,512 Set-Oriented Constructs: From Rete Rule Bases to Database Systems 1991 SIGMOD
6 5,201 An Algebraic Approach to Rule Analysis in Expert Database Systems 1994 VLDB
7 246 Deriving Production Rules for Incremental View Maintenance 1991 VLDB
8 5,856 Implementing High Level Active Rules on top of a Relational DBMS 1992 VLDB
9 1,372 Deriving Production Rules for Constraint Maintenance 1990 VLDB
10 1,627 Implementing Set-Oriented Production Rules as an Extension to Starburst 1991 VLDB