• May 27, 2016 News!The submission for Special Issue is officially open now!   [Click]
  • May 03, 2016 News!Vol.6, No.6 has been indexed by EI (Inspec).   [Click]
  • Mar 17, 2017 News!Vol.9, No.2 has been published with online version. 13 peer reviewed articles from 4 specific areas are published in this issue.   [Click]
General Information
Editor-in-chief
Prof. Wael Badawy
Department of Computing and Information Systems Umm Al Qura University, Canada
I'm happy to take on the position of editor in chief of IJCTE. We encourage authors to submit papers concerning any branch of computer theory and engineering.
IJCTE 2012 Vol.4(2): 198-201 ISSN: 1793-8201
DOI: 10.7763/IJCTE.2012.V4.450

Self-Prediction of Performance Metrics for the Database Management System Workload

Basit Raza, Abdul Mateen, Muhammad Sher, and Mian Muhammad Awais

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.

Index Terms—Workload management, prediction, performance metrics

Basit Raza, Abdul Mateen are with the Computer Science scholar at International Islamic University, Islamabad, Pakistan (e-mail: basitrazasaeed@gmail.com, abdulmateen@fuuastisb.edu.pk).
Mian Muhammad Awais is with the Department of Computer Science, Lahore University of Management Sciences, Lahore, Pakistan (e-mail: awais@lums.edu.pk).
Muhammad Sher is with the Department of Computer Science and Software Engineering, International Islamic University, Islamabad, Pakistan (e-mail: m.sher@iiu.edu.pk).

[PDF]

Cite: Basit Raza, Abdul Mateen, Muhammad Sher, and Mian Muhammad Awais, "Self-Prediction of Performance Metrics for the Database Management System Workload," International Journal of Computer Theory and Engineering vol. 4, no. 2, pp. 198-201, 2012.

Copyright © 2008-2015. International Journal of Computer Theory and Engineering. All rights reserved.
E-mail: ijcte@vip.163.com