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
2468
Venue
SIGMOD
Year
1988
Pagerank
6.5378287e-05
Overall Rank
4,724 | 67.60%
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,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
13,108 Function Materialization in Object Bases 1991 SIGMOD 5.093636e-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.00049302774
39 Efficiently Updating Materialized Views 1986 SIGMOD 0.00047309646
707 A Performance Analysis of View Materialization Strategies 1987 SIGMOD 0.00014771849
1,099 Quel As A Data Type 1984 SIGMOD 0.0001217465
4,146 Efficiently Supporting Procedures In Relational Database Systems 1987 SIGMOD 6.8732593e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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