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: hcd22f09b5ceb213a
Venue: VLDB
Year: 2007
Pagerank: 5.540013e-05
Overall Rank: 7,376 | 50.41%
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,672	A Latency and Fault-Tolerance Optimizer for Online Parallel Query Plans	2011	SIGMOD	8.1491683e-05
7,860	Changing Flights in Mid-air: A Model for Safely Modifying Continuous Queries	2011	SIGMOD	5.4391693e-05
12,764	Slicing Long-Running Queries	2010	VLDB	4.9793485e-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
149	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD	0.00028981723
416	Semantic Data Caching and Replacement	1996	VLDB	0.00018658244
481	Robust Query Processing through Progressive Optimization	2004	SIGMOD	0.00017603972
836	Proactive Re-Optimization	2005	SIGMOD	0.00013557047
949	DynaMat: A Dynamic View Management System for Data Warehouses	1999	SIGMOD	0.00012902181
1,159	Toward a Progress Indicator for Database Queries	2004	SIGMOD	0.00011771949
1,587	Estimating Progress of Execution for SQL Queries	2004	SIGMOD	0.0001014156
2,318	When Can We Trust Progress Estimators for SQL Queries?	2005	SIGMOD	8.6464837e-05
3,278	Efficient Resumption of Interrupted Warehouse Loads	2000	SIGMOD	7.4661193e-05
4,880	Loading a Cache with Query Results	1999	VLDB	6.3714546e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	12,764	Slicing Long-Running Queries	2010	VLDB
2	149	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD
3	5,667	Enabling Incremental Query Re-Optimization	2016	SIGMOD
4	6,755	Compensation-Based On-Line Query Processing	1992	SIGMOD
5	1,587	Estimating Progress of Execution for SQL Queries	2004	SIGMOD
6	446	Query Optimization for Parallel Execution	1992	SIGMOD
7	3,278	Efficient Resumption of Interrupted Warehouse Loads	2000	SIGMOD
8	2,619	Cost-Based Optimization of Decision Support Queries using Transient-Views	1998	SIGMOD
9	1,574	Reducing the Braking Distance of an SQL Query Engine	1998	VLDB
10	3,772	Query Suspend and Resume	2007	SIGMOD