Efficient and Extensible Algorithms for Multi Query Optimization
Summary: Proposes practical multi-query optimization through three cost-based heuristics (Volcano-SH, Volcano-RU, greedy) to exploit shared subexpressions across queries. Demonstrates significant plan-cost reductions with modest optimizer overhead and easy integration, validated on TPC-D workloads. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Prasan Roy (Indian Institute of Technology Mumbai)
- 2. S. Seshadri (AT&T)
- 3. S. Sudarshan (Indian Institute of Technology Mumbai)
- 4. Siddhesh Bhobe (PSPL Limited)
BibTeX Citation
@inproceedings{roy_sigmod00,
title = {{Efficient and Extensible Algorithms for Multi Query Optimization}},
author = {Roy, Prasan and Seshadri, S. and Sudarshan, S. and Bhobe, Siddhesh},
series = {{SIGMOD} '00},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/342009.335419},
url = {https://dl.acm.org/doi/10.1145/342009.335419},
year = {2000}
}Incoming Citations (Sorted by Pagerank)
Showing 37 of 87 citing papers.
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 |
|---|---|---|---|---|
| 137 | Relational Databases for Querying XML Documents: Limitations and Opportunities | 1999 | VLDB | 0.00029877792 |
| 153 | Common Expression Analysis in Database Applications | 1982 | SIGMOD | 0.00029032276 |
| 166 | Query Transformation for PSJ-queries | 1987 | VLDB | 0.00027676268 |
| 736 | Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time | 1996 | SIGMOD | 0.00014508563 |
| 1,107 | Simultaneous Optimization and Evaluation of Multiple Dimensional Queries | 1998 | SIGMOD | 0.00012145695 |
| 2,093 | Reusing Invariants: A New Strategy for Correlated Queries | 1998 | SIGMOD | 9.1831198e-05 |
| 2,593 | Cost-Based Optimization of Decision Support Queries using Transient-Views | 1998 | SIGMOD | 8.3649196e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 1,645 | AniPQO: Almost Non-intrusive Parametric Query Optimization for Nonlinear Cost Functions | 2003 | VLDB |
| 2 | 4,880 | An Incremental Anytime Algorithm for Multi-Objective Query Optimization | 2015 | SIGMOD |
| 3 | 5,124 | Approximation Schemes for Many-Objective Query Optimization | 2014 | SIGMOD |
| 4 | 583 | Global Query Optimization | 1986 | SIGMOD |
| 5 | 822 | Pipelining in Multi-Query Optimization | 2001 | PODS |
| 6 | 984 | Analyzing Plan Diagrams of Database Query Optimizers | 2005 | VLDB |
| 7 | 1,154 | Efficient Exploitation of Similar Subexpressions for Query Processing | 2007 | SIGMOD |
| 8 | 1,530 | Multiple Query Processing in Deductive Databases using Query Graphs | 1986 | VLDB |
| 9 | 2,540 | Multi-Objective Parametric Query Optimization | 2015 | VLDB |
| 10 | 3,268 | Efficient and Provable Multi-Query Optimization | 2017 | PODS |