Efficiently Supporting Procedures In Relational Database Systems

Summary: Procedures as first-class objects in an extended relational DBMS, focusing on query processing efficiency. Proposes a variant INGRES decomposition, caching of procedure results with replacement/validation, and Partial Indexing for cached data. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 2412
Venue: SIGMOD
Year: 1987
Pagerank: 6.8732593e-05
Overall Rank: 4,146 | 71.56%
DOI: 10.1145/38713.38745

Incoming Non-self Citations Over Time

Authors

1. Timos K. Sellis (University of Maryland)

BibTeX Citation

@inproceedings{sellis_sigmod87,
        title = {{EFFICIENTLY SUPPORTING PROCEDURES IN RELATIONAL DATABASE SYSTEMS}},
        author = {Sellis, Timos K.},
        series = {{SIGMOD} '87},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/38713.38745},
        url = {https://dl.acm.org/doi/10.1145/38713.38745},
        year = {1987}
}

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,493	Performance Enhancement Through Replication in an Object-Oriented DBMS	1989	SIGMOD	0.00010581031
1,816	A Performance Study of Query Optimization Algorithms on a Database System Supporting Procedures	1988	VLDB	9.6840978e-05
4,724	Processing Queries Against Database Procedures: A Performance Analysis	1988	SIGMOD	6.5378287e-05

Outgoing Citations (Sorted by Pagerank)

Showing 16 of 16 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
63	An Amateur's Introduction to Recursive Query Processing Strategies	1986	SIGMOD	0.00038782376
81	Implementation of Integrity Constraints and Views by Query Modification	1975	SIGMOD	0.00036443459
92	The Database Language GEM	1983	SIGMOD	0.00034759032
135	An Evaluation of Buffer Management Strategies for Relational Database Systems	1985	VLDB	0.00030209257
147	Making Smalltalk a Database System	1984	SIGMOD	0.00029474235
153	Common Expression Analysis in Database Applications	1982	SIGMOD	0.00029032276
283	Object and File Management in the EXODUS Extensible Database System	1986	VLDB	0.00022377907
357	An Optimizing Prolog Front-End to a Relational Query System	1984	SIGMOD	0.00020283734
539	Computing Queries from Derived Relations	1985	VLDB	0.00016872223
583	Global Query Optimization	1986	SIGMOD	0.00016145442
848	The Representation and Deductive Retrieval of Complex Objects	1985	VLDB	0.00013651467
1,099	Quel As A Data Type	1984	SIGMOD	0.0001217465
1,259	On the Computation of the Transitive Closure of Relational Operators	1986	VLDB	0.00011437537
3,956	Preliminary Design of ADMS+: A Workstation-Mainframe Integrated Architecture for Database Management Systems	1986	VLDB	6.9949992e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,355	Query Processing in Main Memory Database Management Systems	1986	SIGMOD
2	3,760	Query Processing in Tertiary Memory Databases	1995	VLDB
3	1,512	On the Analysis of Indexing Schemes	1997	PODS
4	3,876	Cracking the Database Store	2005	CIDR
5	2,284	Access Support in Object Bases	1990	SIGMOD
6	12,057	Index-Assisted Hierarchical Computations in Main-Memory RDBMS	2016	VLDB
7	7,792	Cache-Oblivious Query Processing	2007	CIDR
8	1,816	A Performance Study of Query Optimization Algorithms on a Database System Supporting Procedures	1988	VLDB
9	4,724	Processing Queries Against Database Procedures: A Performance Analysis	1988	SIGMOD
10	386	Distributed Query Processing In A Relational Data Base System	1978	SIGMOD