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 38 of 88 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 |
|---|---|---|---|---|
| 141 | Relational Databases for Querying XML Documents: Limitations and Opportunities | 1999 | VLDB | 0.00029294114 |
| 155 | Common Expression Analysis in Database Applications | 1982 | SIGMOD | 0.00028527932 |
| 167 | Query Transformation for PSJ-queries | 1987 | VLDB | 0.00027190004 |
| 744 | Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time | 1996 | SIGMOD | 0.00014309622 |
| 1,127 | Simultaneous Optimization and Evaluation of Multiple Dimensional Queries | 1998 | SIGMOD | 0.00011918964 |
| 2,114 | Reusing Invariants: A New Strategy for Correlated Queries | 1998 | SIGMOD | 9.0158191e-05 |
| 2,619 | Cost-Based Optimization of Decision Support Queries using Transient-Views | 1998 | SIGMOD | 8.2215744e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 1,612 | AniPQO: Almost Non-intrusive Parametric Query Optimization for Nonlinear Cost Functions | 2003 | VLDB |
| 2 | 4,980 | An Incremental Anytime Algorithm for Multi-Objective Query Optimization | 2015 | SIGMOD |
| 3 | 5,223 | Approximation Schemes for Many-Objective Query Optimization | 2014 | SIGMOD |
| 4 | 592 | Global Query Optimization | 1986 | SIGMOD |
| 5 | 831 | Pipelining in Multi-Query Optimization | 2001 | PODS |
| 6 | 996 | Analyzing Plan Diagrams of Database Query Optimizers | 2005 | VLDB |
| 7 | 1,131 | Efficient Exploitation of Similar Subexpressions for Query Processing | 2007 | SIGMOD |
| 8 | 1,551 | Multiple Query Processing in Deductive Databases using Query Graphs | 1986 | VLDB |
| 9 | 2,524 | Multi-Objective Parametric Query Optimization | 2015 | VLDB |
| 10 | 3,214 | Efficient and Provable Multi-Query Optimization | 2017 | PODS |