Self-Prediction of Performance Metrics for the Database Management System Workload
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.