Towards Autonomic Workload Management in DBMSs-Reference-Cited by-同舟云学术

Towards Autonomic Workload Management in DBMSs

Published:2011 Issue: Volume: Page:154-173
ISSN:
Container-title:Theoretical and Practical Advances in Information Systems Development
language:
Short-container-title:

Author:

Niu Baoning¹,Martin Patrick²,Powley Wendy²

Affiliation:

1. Taiyuan University of Technology, China & Queen’s University, Canada

2. Queen’s University, Canada

Abstract

Workload management is the discipline of effectively managing, controlling and monitoring work flow across computing systems. It is an increasingly important requirement of database management systems (DBMSs) in view of the trends towards server consolidation and more diverse workloads. Workload management is necessary so the DBMS can be business-objective oriented, can provide efficient differentiated service at fine granularity and can maintain high utilization of resources with low management costs. We see that workload management is shifting from offline planning to online adaptation. In this paper we discuss the objectives of workload management in autonomic DBMSs and provide a framework for examining how current workload management mechanisms match up with these objectives. We then use the framework to study several mechanisms from both DBMS products and research efforts. We also propose directions for future work in the area of workload management for autonomic DBMSs.

Publisher

IGI Global

Reference31 articles.

1. Brown, D. P., Richards, A., Zeehandelaar, R., & Galeazzi, D. (2002). “Teradata Active System Management”. Retrieved February 15, 2008. [Online]. Available: http://www.teradata.com/t/page/ 145613/index.html.

2. Brown, K. P., Mehta, M., Carey, M. J., & Livny, M. (1994). Towards automated performance tuning for complex workloads. Proceedings of the 20th Very Large Data Base Conference, Santiago, Chile, 72-84.

3. Brown Associate, D. H. Inc. (2004). HP raises the bar for UNIX workload management. Retrieved February 15, 2008. [Online]. Available: http://whitepapers.silicon.com/ 0,39024759,60104905p- 39000654q,00.htm.

4. Castro, S., Tezulas, N., Yu, B., Berg, J., Kim, H., & Gfroerer, D. (2001). AIX 5L Workload Manager.

5. Chandramouli, B., Bond, C. N., Babu, S., & Yang, J. (2007). Query suspend and resume. Proceedings of the ACM SIGMOD International Conference on Management of Data, Beijing, China, 557-568.

Cited by 1 articles. 订阅此论文施引文献订阅此论文施引文献，注册后可以免费订阅5篇论文的施引文献，订阅后可以查看论文全部施引文献

1. Autonomic workload performance tuning in large-scale data repositories;Knowledge and Information Systems;2018-09-04