Coarse-Grained Optimization: Techniques for Rewriting SQL Statement Sequences
Summary: Introduces coarse-grained optimization for correlated SQL statement sequences generated by OLAP applications, complementing per-query optimization. A lightweight, DBMS-independent heuristic rewrites sequences across statements, delivering significant performance gains. (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. Tobias Kraft (University of Stuttgart)
- 2. Holger Schwarz (University of Stuttgart)
- 3. Ralf Rantzau (University of Stuttgart)
- 4. Bernhard Mitschang (University of Stuttgart)
BibTeX Citation
@article{kraft_vldb03,
title = {{Coarse-Grained Optimization: Techniques for Rewriting SQL Statement Sequences}},
author = {Kraft, Tobias and Schwarz, Holger and Rantzau, Ralf and Mitschang, Bernhard},
journal = {PVLDB},
series = {{VLDB} '03},
doi = {10.1016/B978-012722442-8/50050-1},
url = {https://doi.org/10.1016/B978-012722442-8/50050-1},
year = {2003}
}Incoming Citations (Sorted by Pagerank)
Showing 3 of 3 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 3,913 | An Approach to Optimize Data Processing in Business Processes | 2007 | VLDB | 7.0230514e-05 |
| 12,663 | A Cost-Estimation Component for Statement Sequences | 2007 | VLDB | 5.093636e-05 |
| 12,785 | CHICAGO: A Test and Evaluation Environment for Coarse-Grained Optimization | 2004 | VLDB | 5.093636e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 0 of 0 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 7,366 | Non-Invasive Progressive Optimization for In-Memory Databases | 2016 | VLDB |
| 2 | 13,224 | Local and Global Query Optimization Mechanisms for Relational Databases | 1985 | VLDB |
| 3 | 71 | Including Group-By in Query Optimization | 1994 | VLDB |
| 4 | 1,073 | A General Framework for the Optimization of Object-Oriented Queries | 1992 | SIGMOD |
| 5 | 1,154 | Efficient Exploitation of Similar Subexpressions for Query Processing | 2007 | SIGMOD |
| 6 | 2,722 | Automatic Physical Design Tuning: Workload as a Sequence | 2006 | SIGMOD |
| 7 | 5,552 | Enabling Incremental Query Re-Optimization | 2016 | SIGMOD |
| 8 | 687 | Sequence Query Processing | 1994 | SIGMOD |
| 9 | 12,663 | A Cost-Estimation Component for Statement Sequences | 2007 | VLDB |
| 10 | 12,785 | CHICAGO: A Test and Evaluation Environment for Coarse-Grained Optimization | 2004 | VLDB |