Progressive Optimization in Action

Summary: Demonstrates Progressive Optimization in a DB2 research prototype: validity ranges and runtime CHECK operators detect cardinality errors and trigger re-optimization. Visualizes plan changes and reuse of previously computed intermediates on real and synthetic workloads. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 9290
Venue: VLDB
Year: 2004
Pagerank: -
Overall Rank: 13,902 | 4.62%
DOI: 10.1016/B978-012088469-8.50141-8

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

1. Vijayshankar Raman (IBM)
2. Volker Markl (IBM)
3. David Simmen (IBM)
4. Guy Lohman (IBM)
5. Hamid Pirahesh (IBM)

BibTeX Citation

@article{raman_vldb04,
        title = {{Progressive Optimization in Action}},
        author = {Raman, Vijayshankar and Markl, Volker and Simmen, David and Lohman, Guy and Pirahesh, Hamid},
        journal = {PVLDB},
        series = {{VLDB} '04},
        pages = {1337--1348},
        doi = {10.1016/B978-012088469-8.50141-8},
        url = {https://doi.org/10.1016/B978-012088469-8.50141-8},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
8,064	Progressive Optimization in a Shared-Nothing Parallel Database	2007	SIGMOD	5.4949524e-05

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

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	151	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD
2	1,256	Sampling-Based Query Re-Optimization	2016	SIGMOD
3	566	Towards a Robust Query Optimizer: A Principled and Practical Approach	2005	SIGMOD
4	3,506	Identifying Robust Plans through Plan Diagram Reduction	2008	VLDB
5	3,003	Configuration-Parametric Query Optimization for Physical Design Tuning	2008	SIGMOD
6	474	Dynamic Query Evaluation Plans	1989	SIGMOD
7	7,366	Non-Invasive Progressive Optimization for In-Memory Databases	2016	VLDB
8	8,064	Progressive Optimization in a Shared-Nothing Parallel Database	2007	SIGMOD
9	5,659	POP/FED: Progressive Query Optimization for Federated Queries in DB2	2006	VLDB
10	492	Robust Query Processing through Progressive Optimization	2004	SIGMOD