Local and Global Query Optimization Mechanisms for Relational Databases
Summary: Presents a Hitachi relational optimizer combining precise predicate-selectivity estimation with a cascade method to reduce optimization overhead. Extends optimization across multiple queries, rather than treating each independently, for globally improved access strategies. (summarized by gpt-5.6-luna on Jul 24 2026)
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Authors
- 1. Kazuhiro Satoh (Hitachi, Ltd.)
- 2. Masashi Tsuchida (Hitachi, Ltd.)
- 3. Fumio Nakamura (Hitachi, Ltd.)
- 4. Kazuhiko Oomachi (Hitachi, Ltd.)
BibTeX Citation
@article{satoh_vldb85,
title = {{Local and Global Query Optimization Mechanisms for Relational Databases}},
author = {Satoh, Kazuhiro and Tsuchida, Masashi and Nakamura, Fumio and Oomachi, Kazuhiko},
journal = {PVLDB},
series = {{VLDB} '85},
pages = {405},
year = {1985}
}Incoming Citations (Sorted by Pagerank)
Showing 0 of 0 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|
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 |
|---|---|---|---|---|
| 1 | Access Path Selection in a Relational Database Management System | 1979 | SIGMOD | 0.0024089429 |
| 36 | Accurate Estimation Of The Number Of Tuples Satisfying A Condition | 1984 | SIGMOD | 0.00048351457 |
| 153 | Common Expression Analysis in Database Applications | 1982 | SIGMOD | 0.00029032276 |
| 519 | Optimizing the Performance of a Relational Algebra Database Interface | 1975 | SIGMOD | 0.00017144967 |
| 2,512 | An Architecture For Query Optimization | 1982 | SIGMOD | 8.485242e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 1,462 | Advanced Query Processing in Object Bases Using Access Support Relations | 1990 | VLDB |
| 2 | 151 | Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans | 1998 | SIGMOD |
| 3 | 10,106 | How to Optimize SQL Queries? A Comparison Between Split, Holistic, and Hybrid Approaches | 2025 | VLDB |
| 4 | 2,512 | An Architecture For Query Optimization | 1982 | SIGMOD |
| 5 | 1,073 | A General Framework for the Optimization of Object-Oriented Queries | 1992 | SIGMOD |
| 6 | 143 | Optimization of Nonrecursive Queries | 1986 | VLDB |
| 7 | 2,465 | Optimization of Queries with User-defined Predicates | 1996 | VLDB |
| 8 | 2,104 | Optimization of Multi-Way Join Queries for Parallel Execution | 1991 | VLDB |
| 9 | 290 | An Overview of Query Optimization in Relational Systems | 1998 | PODS |
| 10 | 583 | Global Query Optimization | 1986 | SIGMOD |