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.00028920518
Overall Rank: 148 | 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.00053734242
72	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.00037421163
109	Extensible/Rule Based Query Rewrite Optimization in Starburst	1992	SIGMOD	0.00032702871
246	Deriving Production Rules for Incremental View Maintenance	1991	VLDB	0.00023146423
248	Efficient Filtering of XML Documents for Selective Dissemination of Information	2000	VLDB	0.00023113032
370	Continuous Queries over Append-Only Databases	1992	SIGMOD	0.00019781831
401	Query Caching and Optimization in Distributed Mediator Systems	1996	SIGMOD	0.00019080589
567	Answering Queries with Aggregation Using Views	1996	VLDB	0.00016228477
584	Alert: An Architecture for Transforming a Passive DBMS into an Active DBMS	1991	VLDB	0.00015927926
691	Query Optimization in the Presence of Foreign Functions	1993	VLDB	0.00014701803
739	Set-Oriented Production Rules in Relational Database Systems	1990	SIGMOD	0.0001430589
1,377	Deriving Production Rules for Constraint Maintenance	1990	VLDB	0.00010857402
1,634	Implementing Set-Oriented Production Rules as an Extension to Starburst	1991	VLDB	0.00010001512
1,766	On-Line Warehouse View Maintenance	1997	SIGMOD	9.6888572e-05
2,297	Join Queries with External Text Sources: Execution and Optimization Techniques	1995	SIGMOD	8.6659442e-05
2,552	A Model for Active Object Oriented Database	1991	VLDB	8.2863926e-05
2,818	Segment Indexes: Dynamic Indexing Techniques for Multi-Dimensional Interval Data	1991	SIGMOD	7.9536217e-05
3,198	Language Constructs for Programming Active Databases	1991	VLDB	7.5282913e-05
3,527	Integrating Triggers and Declarative Constraints in SQL Database Systems	1996	VLDB	7.214911e-05
3,640	Efficient Maintenance of Materialized Mediated Views (Extended Abstract)	1995	SIGMOD	7.1242859e-05
3,875	On Implementing a Language for Specifying Active Database Execution Models	1993	VLDB	6.9365895e-05
3,908	Behavior of Database Production Rules: Termination, Confluence, and Observable Determinism	1992	SIGMOD	6.913498e-05
4,140	Temporal Conditions and Integrity Constraints in Active Database Systems	1995	SIGMOD	6.7691558e-05
5,210	Crystal: A Unified Cache Storage System for Analytical Databases	2021	VLDB	6.2142008e-05
5,417	Semantics and Expressiveness Issues in Active Databases	1995	PODS	6.1264606e-05
5,618	Managing Temporal Financial Data in an Extensible Database	1993	VLDB	6.0469419e-05
5,742	Rule Management in Object Oriented Databases: A Uniform Approach	1991	VLDB	5.9933756e-05
5,871	Implementing High Level Active Rules on top of a Relational DBMS	1992	VLDB	5.9471111e-05
6,035	NAOS: Efficient and modular reactive capabilities in an Object-Oriented Database System	1994	VLDB	5.8906344e-05
6,483	An Adaptive Algorithm for Incremental Evaluation of Production Rules in Databases	1993	VLDB	5.7528381e-05
6,503	A Multidatabase System for Tracking and Retrieval of Financial Data	1994	VLDB	5.7466167e-05
6,999	Real-Time Integrity Constraints (extended abstract)	1992	PODS	5.6087771e-05
8,533	Set-Oriented Constructs: From Rete Rule Bases to Database Systems	1991	SIGMOD	5.305476e-05
13,331	Enhancing Database Correctness: A Statistical Approach	1995	SIGMOD	4.9605343e-05
13,352	Database De-Centralization - A Practical Approach	1995	VLDB	4.9605343e-05
13,409	An Active Object-Oriented Database: A Multi-Paradigm Approach to Constraint Management	1993	VLDB	4.9605343e-05
13,429	Updates in a Rule-Based Language for Objects	1992	VLDB	4.9605343e-05
13,431	Production Rules in Parallel and Distributed Database Environments	1992	VLDB	4.9605343e-05
13,445	Function Materialization in Object Bases	1991	SIGMOD	4.9605343e-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.00049063803
39	Efficiently Updating Materialized Views	1986	SIGMOD	0.00046445099
87	Implementation of Integrity Constraints and Views by Query Modification	1975	SIGMOD	0.00035589793
205	The Architecture Of An Active Data Base Management System*	1989	SIGMOD	0.00025137529
354	A DBMS Prototype to Support Extended NF2 Relations: An Integrated View on Flat Tables and Hierarchies	1986	SIGMOD	0.00020147748
1,144	The POSTGRES Data Model	1987	VLDB	0.00011804665
1,853	A Performance Study of Query Optimization Algorithms on a Database System Supporting Procedures	1988	VLDB	9.4915966e-05

Semantically Similar Papers

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