Query Suspend and Resume

Summary: Database-centric suspend/resume for long-running analytics. Per-operator lightweight checkpoints coordinated by a contracting mechanism enable optimized suspend plans that mix dumps and checkpoint reuse; implemented with small iterator changes in PREDATOR and outperforming traditional options. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3943
Venue: SIGMOD
Year: 2007
Pagerank: 7.1818056e-05
Overall Rank: 3,707 | 74.57%
DOI: 10.1145/1247480.1247542

Incoming Non-self Citations Over Time

Authors

1. Badrish Chandramouli (Duke University)
2. Christopher N. Bond (Google)
3. Shivnath Babu (Duke University)
4. Jun Yang (Duke University)

BibTeX Citation

@inproceedings{chandramouli_sigmod07,
        title = {{Query Suspend and Resume}},
        author = {Chandramouli, Badrish and Bond, Christopher N. and Babu, Shivnath and Yang, Jun},
        series = {{SIGMOD} '07},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1247480.1247542},
        url = {https://dl.acm.org/doi/10.1145/1247480.1247542},
        year = {2007}
}

Incoming Citations (Sorted by Pagerank)

Showing 11 of 11 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
3,117	Chi: A Scalable and Programmable Control Plane for Distributed Stream Processing Systems	2018	VLDB	7.7382559e-05
5,187	A Software-Defined Networking based Approach for Performance Management of Analytical Queries on Distributed Data Stores	2014	SIGMOD	6.3279213e-05
6,626	Tempura: A General Cost-Based Optimizer Framework for Incremental Data Processing	2021	VLDB	5.8198723e-05
7,200	Intermittent Query Processing	2019	VLDB	5.6756294e-05
8,065	Changing Flights in Mid-air: A Model for Safely Modifying Continuous Queries	2011	SIGMOD	5.4942386e-05
8,090	Amber: A Debuggable Dataflow System Based on the Actor Model	2020	VLDB	5.4890583e-05
8,818	Resource-Adaptive Query Execution with Paged Memory Management	2025	CIDR	5.3637177e-05
9,531	Shrink - Prescribing Resiliency Solutions for Streaming	2017	VLDB	5.2540895e-05
10,039	Towards Resource-adaptive Query Execution in Cloud Native Databases	2024	CIDR	5.1723558e-05
12,473	Slicing Long-Running Queries	2010	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 8 of 8 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
53	Eddies: Continuously Adaptive Query Processing	2000	SIGMOD	0.00041071971
98	Encapsulation of Parallelism in the Volcano Query Processing System	1990	SIGMOD	0.00034510605
151	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD	0.00029161879
492	Robust Query Processing through Progressive Optimization	2004	SIGMOD	0.0001756877
1,143	Toward a Progress Indicator for Database Queries	2004	SIGMOD	0.00011999403
2,997	Adapting to Source Properties in Processing Data Integration Queries	2004	SIGMOD	7.8745158e-05
3,220	Efficient Resumption of Interrupted Warehouse Loads	2000	SIGMOD	7.6272892e-05
5,035	Run-Time Operator State Spilling for Memory Intensive Long-Running Queries	2006	SIGMOD	6.3920216e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	3,760	Query Processing in Tertiary Memory Databases	1995	VLDB
2	773	Low Overhead Concurrency Control for Partitioned Main Memory Databases	2010	SIGMOD
3	1,544	Reducing the Braking Distance of an SQL Query Engine	1998	VLDB
4	9,287	Executing Long-Running Transactions in Synchronization-Free Main Memory Database Systems	2013	CIDR
5	9,612	Memory Efficient Scheduling of Query Pipeline Execution	2022	CIDR
6	8,818	Resource-Adaptive Query Execution with Paged Memory Management	2025	CIDR
7	6,622	Compensation-Based On-Line Query Processing	1992	SIGMOD
8	4,493	Self-Tuning Query Scheduling for Analytical Workloads	2021	SIGMOD
9	2,388	Low-Overhead Asynchronous Checkpointing in Main-Memory Database Systems	2016	SIGMOD
10	7,244	Stop-and-Restart Style Execution for Long Running Decision Support Queries	2007	VLDB