DBScholar

Back to papers

Processing Queries Against Database Procedures: A Performance Analysis

Summary: Compares three strategies for retrieving values from database procedures: live execution, cached results with invalidation, and differential view maintenance. Results show the best choice hinges on update frequency and object size, varying with workload. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h1023d5b3f92e659b
Venue
SIGMOD
Year
1988
Pagerank
6.3955453e-05
Overall Rank
4,821 | 67.59%
DOI
10.1145/50202.50238

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{hanson_sigmod88,
        title = {{Processing Queries Against Database Procedures: A Performance Analysis}},
        author = {Hanson, Eric N.},
        series = {{SIGMOD} '88},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/50202.50238},
        url = {https://dl.acm.org/doi/10.1145/50202.50238},
        year = {1988}
}

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank Citing Paper Year Venue Pagerank
1,523 Performance Enhancement Through Replication in an Object-Oriented DBMS 1989 SIGMOD 0.00010366107
1,843 A Performance Study of Query Optimization Algorithms on a Database System Supporting Procedures 1988 VLDB 9.5236698e-05
13,398 Function Materialization in Object Bases 1991 SIGMOD 4.9793485e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 5 of 5 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
723 A Performance Analysis of View Materialization Strategies 1987 SIGMOD 0.00014487177
1,126 Quel As A Data Type 1984 SIGMOD 0.00011920289
4,221 Efficiently Supporting Procedures In Relational Database Systems 1987 SIGMOD 6.7238906e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 5,355 Query Caching and View Selection for XML Databases 2005 VLDB
2 3,845 Query Processing in Tertiary Memory Databases 1995 VLDB
3 8,143 Query Processing for SQL Updates 2004 SIGMOD
4 7,918 Cache-Oblivious Query Processing 2007 CIDR
5 147 On Rules, Procedures, Caching And Views In Data Base Systems 1990 SIGMOD
6 5,240 View Invalidation for Dynamic Content Caching in Multitiered Architectures 2002 VLDB
7 1,786 Procedural Extensions of SQL: Understanding their usage in the wild 2021 VLDB
8 723 A Performance Analysis of View Materialization Strategies 1987 SIGMOD
9 4,221 Efficiently Supporting Procedures In Relational Database Systems 1987 SIGMOD
10 1,843 A Performance Study of Query Optimization Algorithms on a Database System Supporting Procedures 1988 VLDB