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.0040465394 |
| 28 | Accurate Estimation Of The Number Of Tuples Satisfying A Condition | 1984 | SIGMOD | 0.00080571183 |
| 89 | Common Expression Analysis in Database Applications | 1982 | SIGMOD | 0.00052299473 |
| 164 | Optimizing the Performance of a Relational Algebra Database Interface | 1975 | SIGMOD | 0.0003965847 |
| 1,700 | An Architecture For Query Optimization | 1982 | SIGMOD | 0.00010842044 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,492 | Advanced Query Processing in Object Bases Using Access Support Relations | 1990 | VLDB | 0.00011683783 |
| 221 | Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans | 1998 | SIGMOD | 0.00033182072 |
| 9,956 | How to Optimize SQL Queries? A Comparison Between Split, Holistic, and Hybrid Approaches | 2025 | VLDB | 4.2332427e-05 |
| 1,700 | An Architecture For Query Optimization | 1982 | SIGMOD | 0.00010842044 |
| 1,201 | A General Framework for the Optimization of Object-Oriented Queries | 1992 | SIGMOD | 0.00013341955 |
| 144 | Optimization of Nonrecursive Queries | 1986 | VLDB | 0.00041430126 |
| 2,867 | Optimization of Queries with User-defined Predicates | 1996 | VLDB | 7.9931252e-05 |
| 2,051 | Optimization of Multi-Way Join Queries for Parallel Execution | 1991 | VLDB | 9.6871984e-05 |
| 454 | An Overview of Query Optimization in Relational Systems | 1998 | PODS | 0.00022796106 |
| 406 | Global Query Optimization | 1986 | SIGMOD | 0.00023989944 |