Query suspend and resume

11 years 6 months ago
Query suspend and resume
Suppose a long-running analytical query is executing on a database server and has been allocated a large amount of physical memory. A high-priority task comes in and we need to run it immediately with all available resources. We have several choices. We could swap out the old query to disk, but writing out a large execution state may take too much time. Another option is to terminate the old query and restart it after the new task completes, but we would waste all the work already performed by the old query. Yet another alternative is to periodically checkpoint the query during execution, but traditional synchronous checkpointing carries high overhead. In this paper, we advocate a database-centric approach to implementing query suspension and resumption, with negligible execution overhead, bounded suspension cost, and efficient resumption. The basic idea is to let each physical query operator perform lightweight checkpointing according to its own semantics, and coordinate asynchronous...
Badrish Chandramouli, Christopher N. Bond, Shivnat
Added 08 Dec 2009
Updated 08 Dec 2009
Type Conference
Year 2007
Authors Badrish Chandramouli, Christopher N. Bond, Shivnath Babu, Jun Yang 0001
Comments (0)