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
2552
Venue
SIGMOD
Year
1990
Pagerank
0.00014652696
Overall Rank
716 | 95.09%
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.00054667018
236 Efficient Filtering of XML Documents for Selective Dissemination of Information 2000 VLDB 0.00023721569
258 Deriving Production Rules for Incremental View Maintenance 1991 VLDB 0.00023131981
576 Alert: An Architecture for Transforming a Passive DBMS into an Active DBMS 1991 VLDB 0.00016238156
1,329 Deriving Production Rules for Constraint Maintenance 1990 VLDB 0.00011140837
1,590 Implementing Set-Oriented Production Rules as an Extension to Starburst 1991 VLDB 0.00010257581
2,492 A Model for Active Object Oriented Database 1991 VLDB 8.5073897e-05
2,820 On Maintaining Priorities in a Production Rule System 1991 VLDB 8.0911708e-05
2,982 A Method for Change Computation in Deductive Databases 1992 VLDB 7.8959297e-05
3,130 Language Constructs for Programming Active Databases 1991 VLDB 7.7250012e-05
3,561 Ode as an Active Database: Constraints and Triggers 1991 VLDB 7.3091114e-05
3,797 On Implementing a Language for Specifying Active Database Execution Models 1993 VLDB 7.1176817e-05
3,829 Behavior of Database Production Rules: Termination, Confluence, and Observable Determinism 1992 SIGMOD 7.088463e-05
4,040 Temporal Conditions and Integrity Constraints in Active Database Systems 1995 SIGMOD 6.9423365e-05
5,270 Semantics and Expressiveness Issues in Active Databases 1995 PODS 6.2908453e-05
6,455 Managing Conflicts between Rules 1996 PODS 5.8742703e-05
8,344 Set-Oriented Constructs: From Rete Rule Bases to Database Systems 1991 SIGMOD 5.4477811e-05
8,763 Monitoring Business Processes with Queries 2007 VLDB 5.3766157e-05
9,041 A New Perspective on Rule Support for Object-Oriented Databases* 1993 SIGMOD 5.326278e-05
13,092 Updates in a Rule-Based Language for Objects 1992 VLDB 5.093636e-05
13,094 Production Rules in Parallel and Distributed Database Environments 1992 VLDB 5.093636e-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
146 On Rules, Procedures, Caching And Views In Data Base Systems 1990 SIGMOD 0.00029540467
197 The Architecture Of An Active Data Base Management System* 1989 SIGMOD 0.00025700767
268 Extensible Query Processing in Starburst 1989 SIGMOD 0.00022788687
598 Active Databases as a Paradigm for Enhanced Computing Environments 1983 VLDB 0.00015910777
1,329 Deriving Production Rules for Constraint Maintenance 1990 VLDB 0.00011140837
1,428 Implementing Large Production Systems in a DBMS Environment: Concepts and Algorithms 1988 SIGMOD 0.00010811922
2,277 Compiling complex database transition triggers 1989 SIGMOD 8.817902e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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