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)
Incoming Non-self Citations Over Time
Authors
Incoming Citations (Sorted by Pagerank)
Showing 3 of 3 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 939 | Performance Enhancement Through Replication in an Object-Oriented DBMS | 1989 | SIGMOD | 0.000151516 |
| 1,416 | A Performance Study of Query Optimization Algorithms on a Database System Supporting Procedures | 1988 | VLDB | 0.00012097722 |
| 12,923 | Function Materialization in Object Bases | 1991 | SIGMOD | 4.1905499e-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 |
|---|---|---|---|---|
| 44 | The Design Of Postgres | 1986 | SIGMOD | 0.00071946446 |
| 55 | Efficiently Updating Materialized Views | 1986 | SIGMOD | 0.00065687017 |
| 580 | Quel As A Data Type | 1984 | SIGMOD | 0.00019775101 |
| 658 | A Performance Analysis of View Materialization Strategies | 1987 | SIGMOD | 0.00018566555 |
| 3,350 | Efficiently Supporting Procedures In Relational Database Systems | 1987 | SIGMOD | 7.1867845e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 3,742 | Query Processing in Tertiary Memory Databases | 1995 | VLDB | 6.7950057e-05 |
| 5,621 | Query Caching and View Selection for XML Databases | 2005 | VLDB | 5.4061733e-05 |
| 7,373 | Cache-Oblivious Query Processing | 2007 | CIDR | 4.744464e-05 |
| 7,788 | Query Processing for SQL Updates | 2004 | SIGMOD | 4.6465948e-05 |
| 135 | On Rules, Procedures, Caching And Views In Data Base Systems | 1990 | SIGMOD | 0.0004273413 |
| 5,127 | View Invalidation for Dynamic Content Caching in Multitiered Architectures | 2002 | VLDB | 5.6735949e-05 |
| 2,242 | Procedural Extensions of SQL: Understanding their usage in the wild | 2021 | VLDB | 9.2124242e-05 |
| 658 | A Performance Analysis of View Materialization Strategies | 1987 | SIGMOD | 0.00018566555 |
| 3,350 | Efficiently Supporting Procedures In Relational Database Systems | 1987 | SIGMOD | 7.1867845e-05 |
| 1,416 | A Performance Study of Query Optimization Algorithms on a Database System Supporting Procedures | 1988 | VLDB | 0.00012097722 |