Local and Global Query Optimization Mechanisms for Relational Databases
Summary: Relational DBMS optimization built into a Hitachi product uses precise tuple selectivity estimates to pick optimal access paths. Introduces the cascade method to reduce optimization overhead and a global optimization mechanism that co-optimizes multiple queries. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Authors
- 1. Kazuhiro Satoh
- 2. Masashi Tsuchida
- 3. Fumio Nakamura
- 4. Kazuhiko Oomachi
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.0040449103 |
| 28 | Accurate Estimation Of The Number Of Tuples Satisfying A Condition | 1984 | SIGMOD | 0.00080435857 |
| 88 | Common Expression Analysis in Database Applications | 1982 | SIGMOD | 0.00052316625 |
| 163 | Optimizing the Performance of a Relational Algebra Database Interface | 1975 | SIGMOD | 0.00039689347 |
| 1,702 | An Architecture For Query Optimization | 1982 | SIGMOD | 0.0001085438 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,493 | Advanced Query Processing in Object Bases Using Access Support Relations | 1990 | VLDB | 0.00011694373 |
| 220 | Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans | 1998 | SIGMOD | 0.00033194808 |
| 9,957 | How to Optimize SQL Queries? A Comparison Between Split, Holistic, and Hybrid Approaches | 2025 | VLDB | 4.2373024e-05 |
| 1,702 | An Architecture For Query Optimization | 1982 | SIGMOD | 0.0001085438 |
| 1,199 | A General Framework for the Optimization of Object-Oriented Queries | 1992 | SIGMOD | 0.00013354204 |
| 2,860 | Optimization of Queries with User-defined Predicates | 1996 | VLDB | 7.9934503e-05 |
| 143 | Optimization of Nonrecursive Queries | 1986 | VLDB | 0.00041510555 |
| 2,044 | Optimization of Multi-Way Join Queries for Parallel Execution | 1991 | VLDB | 9.6953608e-05 |
| 454 | An Overview of Query Optimization in Relational Systems | 1998 | PODS | 0.00022734812 |
| 410 | Global Query Optimization | 1986 | SIGMOD | 0.00023934971 |