JISE


  [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13] [14] [15]


Journal of Information Science and Engineering, Vol. 29 No. 5, pp. 793-810


Harnessing Cloud Computing for Dynamic Resource Requirement by Database Workloads


CHEE-HENG TAN1 AND YING-WAH TEH2
1,2Faculty of Computer Science and Information Technology
University of Malaya
50603 Kuala Lumpur, Malaysia
E-mail: {
1cheeheng@siswa; 2tehyw@}um.edu.my

 


    In this paper we illustrate a mechanism to address a very important aspect in the Cloud hosting strategy – resource management. We want to show how database hosting can benefit from this technology better, together with analysis on some of the causes and concerns of hosting databases in the Cloud. A graphical presentation is illustrated, where input is obtained from database workloads to gauge the adequacy of the resource, and plan for future. The essence of the proposal is based on linear regression correlation between workloads’ execution time and corresponding server load. This paper strives to address the requirement prior to resource contention, so that underlying hardware planning in the Private Cloud can be carried out in orderly fashion and with adequate timeline. Subsequently Fuzzy Logic concept is utilized to represent the variables’ relationship in the proposal, to ease the deterministic calculation in the algorithm during development phase. A supervisory mechanism to ensure validity of SQL response time used as input to the algorithm is proposed, so to ensure solidarity on the input parameters. The objective is to ensure credible transactions can run freely without hardware resource constraint throughout the tenure of the application offering, in association with the Cloud computing technology.


Keywords: resource planning, workload management, cloud computing, SQL performance tuning, private cloud, database hosting

  Retrieve PDF document (JISE_201305_01.pdf)