CHICAGO: A Test and Evaluation Environment for Coarse-Grained Optimization

Summary: CHICAGO: test/eval environment for coarse-grained opt. of SQL-statement sequences in relational OLAP; enables evaluation of rewrite rules and control strategies. A lightweight heuristic optimizer applies a small set of rewrite rules to the sequence. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 9292
Venue: VLDB
Year: 2004
Pagerank: 5.093636e-05
Overall Rank: 12,785 | 12.29%
DOI: 10.1016/B978-012088469-8.50143-1

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)

BibTeX Citation

@article{kraft_vldb04,
        title = {{CHICAGO: A Test and Evaluation Environment for Coarse-Grained Optimization}},
        author = {Kraft, Tobias and Schwarz, Holger},
        journal = {PVLDB},
        series = {{VLDB} '04},
        pages = {1345},
        doi = {10.1016/B978-012088469-8.50143-1},
        url = {https://doi.org/10.1016/B978-012088469-8.50143-1},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
12,663	A Cost-Estimation Component for Statement Sequences	2007	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 4 of 4 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
110	Extensible/Rule Based Query Rewrite Optimization in Starburst	1992	SIGMOD	0.0003309592
153	Common Expression Analysis in Database Applications	1982	SIGMOD	0.00029032276
1,375	Anatomy of a Modular Multiple Query Optimizer	1988	VLDB	0.00010977145
13,939	Coarse-Grained Optimization: Techniques for Rewriting SQL Statement Sequences	2003	VLDB	-

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	12,315	Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations	2012	SIGMOD
2	7,117	Changing the Rules: Transformations for Rule-Based Optimizers*	1998	SIGMOD
3	8,636	Adaptive Code Generation for Data-Intensive Analytics	2021	VLDB
4	10,139	Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More!	2026	CIDR
5	8,453	A Learned Query Rewrite System	2023	VLDB
6	2,069	Generating Targeted Queries for Database Testing	2008	SIGMOD
7	12,496	A Framework for Testing Query Transformation Rules	2009	SIGMOD
8	8,164	SlabCity: Whole-Query Optimization using Program Synthesis	2023	VLDB
9	12,663	A Cost-Estimation Component for Statement Sequences	2007	VLDB
10	13,939	Coarse-Grained Optimization: Techniques for Rewriting SQL Statement Sequences	2003	VLDB