Stop-and-Restart Style Execution for Long Running Decision Support Queries

Summary: Introduces stop-and-restart execution for resource-contended, long-running decision-support queries, preserving selected intermediate state rather than discarding terminated work. Bounded checkpoint overhead substantially reduces restart time by re-executing only remaining work. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 9815
Venue: VLDB
Year: 2007
Pagerank: 5.6638746e-05
Overall Rank: 7,244 | 50.31%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Surajit Chaudhuri (Microsoft)
2. Raghav Kaushik (Microsoft)
3. Abhijit Pol (University of Florida)
4. Ravi Ramamurthy (Microsoft)

BibTeX Citation

@article{chaudhuri_vldb07,
        title = {{Stop-and-Restart Style Execution for Long Running Decision Support Queries}},
        author = {Chaudhuri, Surajit and Kaushik, Raghav and Pol, Abhijit and Ramamurthy, Ravi},
        journal = {PVLDB},
        series = {{VLDB} '07},
        pages = {735},
        year = {2007}
}

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,622	A Latency and Fault-Tolerance Optimizer for Online Parallel Query Plans	2011	SIGMOD	8.3330136e-05
8,065	Changing Flights in Mid-air: A Model for Safely Modifying Continuous Queries	2011	SIGMOD	5.4942386e-05
12,473	Slicing Long-Running Queries	2010	VLDB	5.093636e-05

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.

Rank	Cited Paper	Year	Venue	Pagerank
151	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD	0.00029161879
409	Semantic Data Caching and Replacement	1996	VLDB	0.00018985783
492	Robust Query Processing through Progressive Optimization	2004	SIGMOD	0.0001756877
829	Proactive Re-Optimization	2005	SIGMOD	0.00013769838
943	DynaMat: A Dynamic View Management System for Data Warehouses	1999	SIGMOD	0.00013068595
1,143	Toward a Progress Indicator for Database Queries	2004	SIGMOD	0.00011999403
1,562	Estimating Progress of Execution for SQL Queries	2004	SIGMOD	0.00010354429
2,270	When Can We Trust Progress Estimators for SQL Queries?	2005	SIGMOD	8.8310714e-05
3,220	Efficient Resumption of Interrupted Warehouse Loads	2000	SIGMOD	7.6272892e-05
4,771	Loading a Cache with Query Results	1999	VLDB	6.5158709e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	5,375	A Cost-Effective Method for Providing Improved Data Availability During DBMS Restart Recovery After a Failure	1993	VLDB
2	151	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD
3	5,552	Enabling Incremental Query Re-Optimization	2016	SIGMOD
4	6,622	Compensation-Based On-Line Query Processing	1992	SIGMOD
5	1,562	Estimating Progress of Execution for SQL Queries	2004	SIGMOD
6	434	Query Optimization for Parallel Execution	1992	SIGMOD
7	3,220	Efficient Resumption of Interrupted Warehouse Loads	2000	SIGMOD
8	2,593	Cost-Based Optimization of Decision Support Queries using Transient-Views	1998	SIGMOD
9	1,544	Reducing the Braking Distance of an SQL Query Engine	1998	VLDB
10	3,707	Query Suspend and Resume	2007	SIGMOD