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.00029006574
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.00053906051
72	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.0003753293
109	Extensible/Rule Based Query Rewrite Optimization in Starburst	1992	SIGMOD	0.00032757423
246	Deriving Production Rules for Incremental View Maintenance	1991	VLDB	0.00023204593
247	Efficient Filtering of XML Documents for Selective Dissemination of Information	2000	VLDB	0.00023188523
369	Continuous Queries over Append-Only Databases	1992	SIGMOD	0.0001984577
399	Query Caching and Optimization in Distributed Mediator Systems	1996	SIGMOD	0.00019134783
567	Answering Queries with Aggregation Using Views	1996	VLDB	0.00016264813
581	Alert: An Architecture for Transforming a Passive DBMS into an Active DBMS	1991	VLDB	0.00015977796
689	Query Optimization in the Presence of Foreign Functions	1993	VLDB	0.00014746059
738	Set-Oriented Production Rules in Relational Database Systems	1990	SIGMOD	0.00014352601
1,372	Deriving Production Rules for Constraint Maintenance	1990	VLDB	0.00010893304
1,627	Implementing Set-Oriented Production Rules as an Extension to Starburst	1991	VLDB	0.00010034329
1,754	On-Line Warehouse View Maintenance	1997	SIGMOD	9.7204307e-05
2,284	Join Queries with External Text Sources: Execution and Optimization Techniques	1995	SIGMOD	8.6928064e-05
2,546	A Model for Active Object Oriented Database	1991	VLDB	8.3138254e-05
2,828	Segment Indexes: Dynamic Indexing Techniques for Multi-Dimensional Interval Data	1991	SIGMOD	7.9613943e-05
3,186	Language Constructs for Programming Active Databases	1991	VLDB	7.5531326e-05
3,517	Integrating Triggers and Declarative Constraints in SQL Database Systems	1996	VLDB	7.2388199e-05
3,631	Efficient Maintenance of Materialized Mediated Views (Extended Abstract)	1995	SIGMOD	7.1463149e-05
3,865	On Implementing a Language for Specifying Active Database Execution Models	1993	VLDB	6.9594584e-05
3,894	Behavior of Database Production Rules: Termination, Confluence, and Observable Determinism	1992	SIGMOD	6.9364082e-05
4,122	Temporal Conditions and Integrity Constraints in Active Database Systems	1995	SIGMOD	6.7915299e-05
5,401	Semantics and Expressiveness Issues in Active Databases	1995	PODS	6.1467854e-05
5,451	Crystal: A Unified Cache Storage System for Analytical Databases	2021	VLDB	6.1238308e-05
5,605	Managing Temporal Financial Data in an Extensible Database	1993	VLDB	6.0669209e-05
5,729	Rule Management in Object Oriented Databases: A Uniform Approach	1991	VLDB	6.0132592e-05
5,858	Implementing High Level Active Rules on top of a Relational DBMS	1992	VLDB	5.9668341e-05
6,021	NAOS: Efficient and modular reactive capabilities in an Object-Oriented Database System	1994	VLDB	5.9101772e-05
6,471	An Adaptive Algorithm for Incremental Evaluation of Production Rules in Databases	1993	VLDB	5.7716341e-05
6,489	A Multidatabase System for Tracking and Retrieval of Financial Data	1994	VLDB	5.765661e-05
6,977	Real-Time Integrity Constraints (extended abstract)	1992	PODS	5.6273193e-05
8,518	Set-Oriented Constructs: From Rete Rule Bases to Database Systems	1991	SIGMOD	5.3230739e-05
13,290	Enhancing Database Correctness: A Statistical Approach	1995	SIGMOD	4.9769913e-05
13,311	Database De-Centralization - A Practical Approach	1995	VLDB	4.9769913e-05
13,368	An Active Object-Oriented Database: A Multi-Paradigm Approach to Constraint Management	1993	VLDB	4.9769913e-05
13,388	Updates in a Rule-Based Language for Objects	1992	VLDB	4.9769913e-05
13,390	Production Rules in Parallel and Distributed Database Environments	1992	VLDB	4.9769913e-05
13,404	Function Materialization in Object Bases	1991	SIGMOD	4.9769913e-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.00049129967
39	Efficiently Updating Materialized Views	1986	SIGMOD	0.00046583225
87	Implementation of Integrity Constraints and Views by Query Modification	1975	SIGMOD	0.00035703156
203	The Architecture Of An Active Data Base Management System*	1989	SIGMOD	0.00025218052
354	A DBMS Prototype to Support Extended NF2 Relations: An Integrated View on Flat Tables and Hierarchies	1986	SIGMOD	0.00020212701
1,143	The POSTGRES Data Model	1987	VLDB	0.00011842018
1,844	A Performance Study of Query Optimization Algorithms on a Database System Supporting Procedures	1988	VLDB	9.5195972e-05

Semantically Similar Papers

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