DBScholar

Back to papers

Robust Query Processing through Progressive Optimization

Summary: Progressive query optimization (POP) detects cardinality errors during execution and re-optimizes plans in a commercial DBMS. CHECK operators compute a validity range via a sensitivity analysis; when violated, re-optimization uses partial results. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
hafc60422fa7a7261
Venue
SIGMOD
Year
2004
Pagerank
0.00017744392
Overall Rank
471 | 96.84%
DOI
10.1145/1007568.1007642

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{markl_sigmod04,
        title = {{Robust Query Processing through Progressive Optimization}},
        author = {Markl, Volker and Raman, Vijayshankar and Simmen, David and Lohman, Guy and Pirahesh, Hamid and Cilimdzic, Miso},
        series = {{SIGMOD} '04},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1007568.1007642},
        url = {https://dl.acm.org/doi/10.1145/1007568.1007642},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 65 citing papers.

Rank Citing Paper Year Venue Pagerank
625 Adaptive Aggregation on Chip Multiprocessors 2007 VLDB 0.00015472161
688 Cardinality Estimation Done Right: Index-Based Join Sampling 2017 CIDR 0.00014749318
837 Proactive Re-Optimization 2005 SIGMOD 0.00013551072
1,258 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00011308863
1,432 Towards a Learning Optimizer for Shared Clouds 2019 VLDB 0.00010676754
1,892 CS2: A New Database Synopsis for Query Estimation 2013 SIGMOD 9.4150583e-05
1,989 Plan Bouquets: Query Processing without Selectivity Estimation 2014 SIGMOD 9.2469024e-05
2,217 Estimating Join Selectivities using Bandwidth-Optimized Kernel Density Models 2017 VLDB 8.8151982e-05
2,320 When Can We Trust Progress Estimators for SQL Queries? 2005 SIGMOD 8.6429103e-05
2,432 Cardinality Estimation Using Sample Views with Quality Assurance 2007 SIGMOD 8.4742372e-05
2,824 G-CARE: A Framework for Performance Benchmarking of Cardinality Estimation Techniques for Subgraph Matching 2020 SIGMOD 7.9662478e-05
3,362 Exact Cardinality Query Optimization for Optimizer Testing 2009 VLDB 7.3719912e-05
3,402 RHEEM: Enabling Cross-Platform Data Processing - May The Big Data Be With You! - 2018 VLDB 7.3269775e-05
3,527 Identifying Robust Plans through Plan Diagram Reduction 2008 VLDB 7.2283486e-05
3,544 Computation Reuse in Analytics Job Service at Microsoft 2018 SIGMOD 7.2108612e-05
3,593 Looking Ahead Makes Query Plans Robust: Making the Initial Case with In-Memory Star Schema Data Warehouse Workloads 2017 VLDB 7.1803217e-05
3,774 Query Suspend and Resume 2007 SIGMOD 7.026432e-05
3,777 Parallelizing Query Optimization 2008 VLDB 7.0240115e-05
4,046 Adaptive Query Processing in the Looking Glass 2005 CIDR 6.8297725e-05
4,069 Dynamically Optimizing Queries over Large Scale Data Platforms 2014 SIGMOD 6.8184364e-05
4,108 Content-Based Routing: Different Plans for Different Data 2005 VLDB 6.8000756e-05
4,508 Xplus: A SQL-Tuning-Aware Query Optimizer 2010 VLDB 6.5696141e-05
4,796 Permutable Compiled Queries: Dynamically Adapting Compiled Queries without Recompiling 2021 VLDB 6.409726e-05
4,820 Continuous Cloud-Scale Query Optimization and Processing 2013 VLDB 6.3935932e-05
4,857 Efficiently Approximating Query Optimizer Plan Diagrams 2008 VLDB 6.3772435e-05
4,945 Debunking the Myth of Join Ordering: Toward Robust SQL Analytics 2025 SIGMOD 6.3418058e-05
5,020 Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server 2023 VLDB 6.3096708e-05
5,310 CliffGuard: A Principled Framework for Finding Robust Database Designs 2015 SIGMOD 6.184026e-05
5,354 Adaptive and Robust Query Execution for Lakehouses at Scale 2024 VLDB 6.1661231e-05
5,475 A Pay-As-You-Go Framework for Query Execution Feedback 2008 VLDB 6.115573e-05
5,598 StatAdvisor: Recommending Statistical Views 2009 VLDB 6.0690976e-05
5,658 Uncertainty Aware Query Execution Time Prediction 2014 VLDB 6.0460211e-05
5,663 Enabling Incremental Query Re-Optimization 2016 SIGMOD 6.0448133e-05
5,700 PilotScope: Steering Databases with Machine Learning Drivers 2024 VLDB 6.028998e-05
5,777 POP/FED: Progressive Query Optimization for Federated Queries in DB2 2006 VLDB 5.9953732e-05
5,915 Inspector Joins 2005 VLDB 5.9472868e-05
5,988 On the Stability of Plan Costs and the Costs of Plan Stability 2010 VLDB 5.9229752e-05
6,024 Proactive Re-optimization with Rio 2005 SIGMOD 5.9096276e-05
6,664 Speeding Up End-to-end Query Execution via Learning-based Progressive Cardinality Estimation 2023 SIGMOD 5.715134e-05
6,688 Impliance: A Next Generation Information Management Appliance 2007 CIDR 5.7060345e-05
6,776 Cheap Data Analytics using Cold Storage Devices 2016 VLDB 5.6834455e-05
6,802 ROX: Run-time Optimization of XQueries 2009 SIGMOD 5.6773357e-05
7,251 Efficient Adaptive Detection of Complex Event Patterns 2018 VLDB 5.5719214e-05
7,307 Dynamic Plan Generation for Parameterized Queries 2009 SIGMOD 5.5567262e-05
7,378 Stop-and-Restart Style Execution for Long Running Decision Support Queries 2007 VLDB 5.537392e-05
7,413 POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance 2024 VLDB 5.5316834e-05
7,492 Non-Invasive Progressive Optimization for In-Memory Databases 2016 VLDB 5.5094171e-05
7,603 On the Calculation of Optimality Ranges for Relational Query Execution Plans 2018 SIGMOD 5.4846849e-05
7,958 Robust Query Processing: Mission Possible 2020 VLDB 5.4164639e-05
8,019 AJoin: Ad-hoc Stream Joins at Scale 2020 VLDB 5.4045347e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 10 of 10 cited papers.

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

Previous Page 1 / 1 Next

Semantically Similar Papers