A Performance Study of Query Optimization Algorithms on a Database System Supporting Procedures
Summary: Compares five optimization techniques for procedural-field queries in POSTGRES/POSTQUEL: on-demand execution, pre-optimizing procedural subqueries, caching schemes (tuples vs. separate), and flattening. Results: caching helps with infrequent updates; separate caching generally outperforms tuple caching; flattening is best when procedural composition is predictable. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Anant Jhingran (University of California Berkeley)
BibTeX Citation
@article{jhingran_vldb88,
title = {{A Performance Study of Query Optimization Algorithms on a Database System Supporting Procedures}},
author = {Jhingran, Anant},
journal = {PVLDB},
series = {{VLDB} '88},
pages = {88},
year = {1988}
}Incoming Citations (Sorted by Pagerank)
Showing 8 of 8 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 125 | Predicate Migration: Optimizing Queries with Expensive Predicates | 1993 | SIGMOD | 0.00030470848 |
| 147 | On Rules, Procedures, Caching And Views In Data Base Systems | 1990 | SIGMOD | 0.00029019485 |
| 1,523 | Performance Enhancement Through Replication in an Object-Oriented DBMS | 1989 | SIGMOD | 0.00010366107 |
| 2,032 | Practical Predicate Placement | 1994 | SIGMOD | 9.1561026e-05 |
| 2,511 | WATCHMAN: A Data Warehouse Intelligent Cache Manager | 1996 | VLDB | 8.3696476e-05 |
| 2,787 | EVA: A Symbolic Approach to Accelerating Exploratory Video Analytics with Materialized Views | 2022 | SIGMOD | 8.0158999e-05 |
| 5,437 | Secure and Portable Database Extensibility | 1998 | SIGMOD | 6.1288241e-05 |
| 13,398 | Function Materialization in Object Bases | 1991 | SIGMOD | 4.9793485e-05 |
Previous
Page 1 / 1
Next
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 |
|---|---|---|---|---|
| 1 | Access Path Selection in a Relational Database Management System | 1979 | SIGMOD | 0.0023947656 |
| 87 | Implementation of Integrity Constraints and Views by Query Modification | 1975 | SIGMOD | 0.00035719146 |
| 96 | The Database Language GEM | 1983 | SIGMOD | 0.00034286345 |
| 863 | The Representation and Deductive Retrieval of Complex Objects | 1985 | VLDB | 0.00013392127 |
| 1,143 | The POSTGRES Data Model | 1987 | VLDB | 0.00011847554 |
| 4,221 | Efficiently Supporting Procedures In Relational Database Systems | 1987 | SIGMOD | 6.7238906e-05 |
| 4,821 | Processing Queries Against Database Procedures: A Performance Analysis | 1988 | SIGMOD | 6.3955453e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 149 | Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans | 1998 | SIGMOD |
| 2 | 10,336 | An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL | 2025 | SIGMOD |
| 3 | 8,164 | Efficient Query Re-optimization with Judicious Subquery Selections | 2023 | SIGMOD |
| 4 | 7,918 | Cache-Oblivious Query Processing | 2007 | CIDR |
| 5 | 939 | Buffering Database Operations for Enhanced Instruction Cache Performance | 2004 | SIGMOD |
| 6 | 5,039 | Leveraging Query Logs and Machine Learning for Parametric Query Optimization | 2022 | VLDB |
| 7 | 125 | Predicate Migration: Optimizing Queries with Expensive Predicates | 1993 | SIGMOD |
| 8 | 3,845 | Query Processing in Tertiary Memory Databases | 1995 | VLDB |
| 9 | 4,221 | Efficiently Supporting Procedures In Relational Database Systems | 1987 | SIGMOD |
| 10 | 4,821 | Processing Queries Against Database Procedures: A Performance Analysis | 1988 | SIGMOD |