دانلود رایگان مقاله انگلیسی مدیریت حجم کاری در سیستم های مدیریت پایگاه داده: یک طبقه بندی - IEEE 2017

Abstract

Workload management is the discipline of effectively monitoring, managing and controlling work flow across computing systems. In particular, workload management in database management systems (DBMSs) is the process or act of monitoring and controlling work (i.e., requests) executing on a database system in order to make efficient use of system resources in addition to achieving any performance objectives assigned to that work. In the past decade, workload management studies and practice have made considerable progress in both academia and industry. New techniques have been proposed by researchers, and new features of workload management facilities have been implemented in most commercial database products. In this paper, we provide a systematic study of workload management in today’s DBMSs by developing a taxonomy of workload management techniques. We apply the taxonomy to evaluate and classify existing workload management techniques implemented in the commercial databases and available in the recent research literature. We also introduce the underlying principles of today’s workload management technology for DBMSs, discuss open problems and outline some research opportunities in this research area.

5 CONCLUSIONS AND FUTURE RESEARCH

5.1 Summary

In this paper, we present a systemic study of workload management in DBMSs. We surveyed workload management systems implemented in today’s commercial DBMSs and techniques proposed in the recent research literature. We propose a taxonomy of workload management techniques to classify workload management techniques and identity the techniques employed in a workload management system. The taxonomy categorizes workload management techniques into four major technique classes, namely workload characterization, query admission control, query scheduling and query execution control technique classes. In a workload management technique class, the techniques may be further divided into subclasses based on their distinct technique mechanisms. We also introduce the underlying principles of workload management technology used by today’s commercial DBMSs, which are outlined as defining performance objectives for arriving queries based on a given SLA, identifying the arriving queries present on a data server, and imposing controls on the queries to manage their behaviors in order to achieve the performance goals.

In the taxonomy of workload management techniques, we show that the typical technique used in the workload characterization technique class is workload definition associated with resource allocation. The typical technique used in the query admission control techniques class is setting thresholds for queries. The typical techniques used in the query scheduling technique class are managing query waiting queues and query restructure, and in the query execution control technique class, the typical techniques are query suspension, resource reallocation and query kill, in which the query suspension type techniques can be further divided into query throttling and query suspend-and-resume subtypes.