On Rules, Procedures, Caching And Views In Data Base Systems

Summary: Proposes a compact rule system that unifies views, procedures, and procedural data types, with rule-based semantics for ambiguous view updates and POSTGRES-like data. Caches rule actions to materialize views and speed procedural items, arguing that a rule-centric approach subsumes core DBMS functions. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: haca28ece929c73b9
Venue: SIGMOD
Year: 1990
Pagerank: 0.00029019485
Overall Rank: 147 | 99.02%
DOI: 10.1145/93597.98737

Incoming Non-self Citations Over Time

Authors

1. Michael Stonebraker (University of California Berkeley)
2. Anant Jhingran (University of California Berkeley)
3. Jeffrey Goh (University of California Berkeley)
4. Spyros Potamianos (University of California Berkeley)

BibTeX Citation

@inproceedings{stonebraker_sigmod90,
        title = {{ON RULES, PROCEDURES, CACHING AND VIEWS IN DATA BASE SYSTEMS}},
        author = {Stonebraker, Michael and Jhingran, Anant and Goh, Jeffrey and Potamianos, Spyros},
        series = {{SIGMOD} '90},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/93597.98737},
        url = {https://dl.acm.org/doi/10.1145/93597.98737},
        year = {1990}
}

Incoming Citations (Sorted by Pagerank)

Showing 39 of 39 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
25	NiagaraCQ: A Scalable Continuous Query System for Internet Databases	2000	SIGMOD	0.00053930011
72	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.00037549176
109	Extensible/Rule Based Query Rewrite Optimization in Starburst	1992	SIGMOD	0.0003276959
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
369	Continuous Queries over Append-Only Databases	1992	SIGMOD	0.00019854467
399	Query Caching and Optimization in Distributed Mediator Systems	1996	SIGMOD	0.00019143706
567	Answering Queries with Aggregation Using Views	1996	VLDB	0.00016272161
581	Alert: An Architecture for Transforming a Passive DBMS into an Active DBMS	1991	VLDB	0.00015984359
689	Query Optimization in the Presence of Foreign Functions	1993	VLDB	0.00014752546
737	Set-Oriented Production Rules in Relational Database Systems	1990	SIGMOD	0.00014359198
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
1,753	On-Line Warehouse View Maintenance	1997	SIGMOD	9.7248839e-05
2,286	Join Queries with External Text Sources: Execution and Optimization Techniques	1995	SIGMOD	8.6942645e-05
2,546	A Model for Active Object Oriented Database	1991	VLDB	8.3177548e-05
2,828	Segment Indexes: Dynamic Indexing Techniques for Multi-Dimensional Interval Data	1991	SIGMOD	7.9650643e-05
3,185	Language Constructs for Programming Active Databases	1991	VLDB	7.556677e-05
3,517	Integrating Triggers and Declarative Constraints in SQL Database Systems	1996	VLDB	7.2422477e-05
3,631	Efficient Maintenance of Materialized Mediated Views (Extended Abstract)	1995	SIGMOD	7.1495656e-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
5,446	Crystal: A Unified Cache Storage System for Analytical Databases	2021	VLDB	6.1266228e-05
5,604	Managing Temporal Financial Data in an Extensible Database	1993	VLDB	6.0697862e-05
5,728	Rule Management in Object Oriented Databases: A Uniform Approach	1991	VLDB	6.0161071e-05
5,856	Implementing High Level Active Rules on top of a Relational DBMS	1992	VLDB	5.9696592e-05
6,021	NAOS: Efficient and modular reactive capabilities in an Object-Oriented Database System	1994	VLDB	5.9129763e-05
6,470	An Adaptive Algorithm for Incremental Evaluation of Production Rules in Databases	1993	VLDB	5.7743274e-05
6,487	A Multidatabase System for Tracking and Retrieval of Financial Data	1994	VLDB	5.7683894e-05
6,976	Real-Time Integrity Constraints (extended abstract)	1992	PODS	5.6299711e-05
8,512	Set-Oriented Constructs: From Rete Rule Bases to Database Systems	1991	SIGMOD	5.3255942e-05
13,284	Enhancing Database Correctness: A Statistical Approach	1995	SIGMOD	4.9793485e-05
13,305	Database De-Centralization - A Practical Approach	1995	VLDB	4.9793485e-05
13,362	An Active Object-Oriented Database: A Multi-Paradigm Approach to Constraint Management	1993	VLDB	4.9793485e-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
13,398	Function Materialization in Object Bases	1991	SIGMOD	4.9793485e-05

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
34	The Design Of Postgres	1986	SIGMOD	0.00049142315
39	Efficiently Updating Materialized Views	1986	SIGMOD	0.00046602544
87	Implementation of Integrity Constraints and Views by Query Modification	1975	SIGMOD	0.00035719146
203	The Architecture Of An Active Data Base Management System*	1989	SIGMOD	0.00025229522
354	A DBMS Prototype to Support Extended NF2 Relations: An Integrated View on Flat Tables and Hierarchies	1986	SIGMOD	0.00020222123
1,143	The POSTGRES Data Model	1987	VLDB	0.00011847554
1,843	A Performance Study of Query Optimization Algorithms on a Database System Supporting Procedures	1988	VLDB	9.5236698e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	9,880	Understanding the implications of view update policies	1985	VLDB
2	1,464	Implementing Large Production Systems in a DBMS Environment: Concepts and Algorithms	1988	SIGMOD
3	9,208	A New Perspective on Rule Support for Object-Oriented Databases*	1993	SIGMOD
4	737	Set-Oriented Production Rules in Relational Database Systems	1990	SIGMOD
5	4,821	Processing Queries Against Database Procedures: A Performance Analysis	1988	SIGMOD
6	13,402	Effects of Database Size on Rule System Performance: Five Case Studies	1991	VLDB
7	630	A Rule-Based View of Query Optimization	1987	SIGMOD
8	4,221	Efficiently Supporting Procedures In Relational Database Systems	1987	SIGMOD
9	8,397	Data Management for Large Rule Systems	1991	VLDB
10	246	Deriving Production Rules for Incremental View Maintenance	1991	VLDB