Online index functionality allows concurrent queries and updates during index maintenance tasks, e.g., creation of a new secondary index. Nonetheless, index operations can be both extremely resource-intensive and also extremely long-running. As such, necessary system activities such as adding a new secondary index or changing the primary index may introduce significant contention for resources such as CPUs, memory, and space and bandwidth in temporary storage, thus starving the primary database workload. Danger of an additional workload at inopportune times inhibits adoption of automatic index tuning.Whether initiated by a database administrator or by a software component, 'pause and resume' is a step towards selfmanaging database systems. However, realizing even this step in a commercial system is more difficult than many researchers may realize. This paper summarizes a design for 'pause and resume' functionality and explores the many issues that must be addressed in order to implement such designs in a commercial system. The design is deliberately kept general such that it applies to many software packages. One unique contribution is that in addition to the basic mechanisms, this paper also enumerates functional requirements and covers interaction with other functions commonly used in database management systems, server shutdown and restart, tables with multiple indexes, concurrent queries and updates, failures in the index builder or in concurrent transactions, log volume, and performance expectations II. RELATED PRIOR WORK We discuss related research efforts that address the general problem of how to achieve 'pause and resume' functionality Goetz Graefe #1 , Wey Guy *2 , Harumi Kuno #3 # * 978-1-4244-9196-4/11/$26.00
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.