International Journal of Computer Theory and Engineering

Abstract

Workload in Database Management System (DBMS) consists of huge amount of data and number of concurrent users who are executing different requests that require some resources. To manage these types of activities, organizations hire different database experts. There is versatility in workload due to the huge data size and different types of requests (workload). These factors contribute to some new challenges in the workload management. These challenges are identification of the workload and decision about the problem queries, identification of resource oriented and contention queries, accurate workload classification, optimal plan selection, prediction and adoption. In DBMS, where workload management and tuning is performed through if-then approach, unforeseen behavior of the workload cannot be handled and sometime leads to unpredictable state. In this research a prediction framework has been proposed called as workload queries performance Predictor. The predictor will predict the performance metrics (workload size, elapsed time, record accessed, record used, disk I/Os, memory required, message count and bytes) for queries in a given workload. We are improving efficiency and reducing search time when projection of query feature vector is performed over performance feature vector. The predictor will take help from the optimizer and store the information in database which saves the information as history for the future.