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: 2554
Venue: SIGMOD
Year: 1990
Pagerank: 0.00029540467
Overall Rank: 146 | 99.01%
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.00054667018
69	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.00038090878
110	Extensible/Rule Based Query Rewrite Optimization in Starburst	1992	SIGMOD	0.0003309592
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
368	Continuous Queries over Append-Only Databases	1992	SIGMOD	0.00019968151
381	Query Caching and Optimization in Distributed Mediator Systems	1996	SIGMOD	0.00019549294
554	Answering Queries with Aggregation Using Views	1996	VLDB	0.00016580778
576	Alert: An Architecture for Transforming a Passive DBMS into an Active DBMS	1991	VLDB	0.00016238156
677	Query Optimization in the Presence of Foreign Functions	1993	VLDB	0.00015065909
716	Set-Oriented Production Rules in Relational Database Systems	1990	SIGMOD	0.00014652696
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
1,715	On-Line Warehouse View Maintenance	1997	SIGMOD	9.9392931e-05
2,244	Join Queries with External Text Sources: Execution and Optimization Techniques	1995	SIGMOD	8.8737737e-05
2,492	A Model for Active Object Oriented Database	1991	VLDB	8.5073897e-05
2,776	Segment Indexes: Dynamic Indexing Techniques for Multi-Dimensional Interval Data	1991	SIGMOD	8.1356669e-05
3,130	Language Constructs for Programming Active Databases	1991	VLDB	7.7250012e-05
3,475	Integrating Triggers and Declarative Constraints in SQL Database Systems	1996	VLDB	7.3816996e-05
3,607	Efficient Maintenance of Materialized Mediated Views (Extended Abstract)	1995	SIGMOD	7.262291e-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
5,348	Crystal: A Unified Cache Storage System for Analytical Databases	2021	VLDB	6.2562688e-05
5,464	Managing Temporal Financial Data in an Extensible Database	1993	VLDB	6.2080679e-05
5,600	Rule Management in Object Oriented Databases: A Uniform Approach	1991	VLDB	6.1541906e-05
5,762	Implementing High Level Active Rules on top of a Relational DBMS	1992	VLDB	6.0957273e-05
5,896	NAOS: Efficient and modular reactive capabilities in an Object-Oriented Database System	1994	VLDB	6.0486927e-05
6,362	A Multidatabase System for Tracking and Retrieval of Financial Data	1994	VLDB	5.900531e-05
6,364	An Adaptive Algorithm for Incremental Evaluation of Production Rules in Databases	1993	VLDB	5.8996672e-05
6,836	Real-Time Integrity Constraints (extended abstract)	1992	PODS	5.7580859e-05
8,344	Set-Oriented Constructs: From Rete Rule Bases to Database Systems	1991	SIGMOD	5.4477811e-05
12,994	Enhancing Database Correctness: A Statistical Approach	1995	SIGMOD	5.093636e-05
13,015	Database De-Centralization - A Practical Approach	1995	VLDB	5.093636e-05
13,072	An Active Object-Oriented Database: A Multi-Paradigm Approach to Constraint Management	1993	VLDB	5.093636e-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
13,108	Function Materialization in Object Bases	1991	SIGMOD	5.093636e-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.00049302774
39	Efficiently Updating Materialized Views	1986	SIGMOD	0.00047309646
81	Implementation of Integrity Constraints and Views by Query Modification	1975	SIGMOD	0.00036443459
197	The Architecture Of An Active Data Base Management System*	1989	SIGMOD	0.00025700767
346	A DBMS Prototype to Support Extended NF2 Relations: An Integrated View on Flat Tables and Hierarchies	1986	SIGMOD	0.00020654241
1,118	The POSTGRES Data Model	1987	VLDB	0.00012104924
1,816	A Performance Study of Query Optimization Algorithms on a Database System Supporting Procedures	1988	VLDB	9.6840978e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	5,600	Rule Management in Object Oriented Databases: A Uniform Approach	1991	VLDB
2	1,428	Implementing Large Production Systems in a DBMS Environment: Concepts and Algorithms	1988	SIGMOD
3	9,041	A New Perspective on Rule Support for Object-Oriented Databases*	1993	SIGMOD
4	4,724	Processing Queries Against Database Procedures: A Performance Analysis	1988	SIGMOD
5	716	Set-Oriented Production Rules in Relational Database Systems	1990	SIGMOD
6	13,112	Effects of Database Size on Rule System Performance: Five Case Studies	1991	VLDB
7	615	A Rule-Based View of Query Optimization	1987	SIGMOD
8	4,146	Efficiently Supporting Procedures In Relational Database Systems	1987	SIGMOD
9	8,226	Data Management for Large Rule Systems	1991	VLDB
10	258	Deriving Production Rules for Incremental View Maintenance	1991	VLDB