Keyword Search:


Bookmark and Share

Database workload management through CBR and fuzzy based characterization

Abdul, Mateen and Muhammad, Awais Mian and Mustapha, Norwatti and Muhammad, Sher and Ahmad, Nisar (2014) Database workload management through CBR and fuzzy based characterization. Applied Soft Computing, 22 . 605 - 621. ISSN 1568-4946; ESSN: 1872-9681

[img] PDF (Abstract)
83Kb

Abstract

Database Management System (DBMS) is used as a data source with financial, educational, web and other applications from last many years. Users are connected with the DBMS to update existing records and retrieving reports by executing workloads that consist of complex queries. In order to get the sufficient level of performance, arrangement of workloads is necessary. Rapid growth in data, maximum functionality and changing behavior tends the database workload to be more complex and tricky. Each DBMS experiences complex workloads that are difficult to manage by the humans; human experts take much time to manage database workload efficiently; even in some cases it may become impossible and leads toward malnourishment. This problem leads database practitioners, vendors and researchers toward new challenges. To achieve a satisfactory level of performance, either Database Administrator (DBA) or DBMSs must have the knowledge about the workload shifts. Efficient execution and resource allocation of workload is dependent on the workload type that may be either On Line Transaction Processing (OLTP) or Decision Support System (DSS). The research introduces a way to manage the workload in DBMSs on the basis of the workload type. The main goal of the research is to manage the workload in DBMSs through characterization, scheduler and idleness detection modules. The database workload management is performed by using the case based reasoning characterization; Fuzzy logic based scheduling and finally detection of CPU Idleness. Results are validated through experiments that are performed on real time and benchmark workload to reveal effectiveness and efficiency.

Item Type:Article
Keyword:Workload; Autonomic DBMS; Characterization; Scheduling; Idleness detection
Faculty or Institute:Faculty of Computer Science and Information Technology
Publisher:Elsevier
DOI Number:10.1016/j.asoc.2014.04.030
Altmetrics:http://www.altmetric.com/details.php?domain=psasir.upm.edu.my&doi=10.1016/j.asoc.2014.04.030
ID Code:36964
Deposited By: Nabilah Mustapa
Deposited On:30 May 2015 09:30
Last Modified:21 Aug 2015 15:49

Repository Staff Only: Edit item detail

Document Download Statistics

This item has been downloaded for since 30 May 2015 09:30.

View statistics for "Database workload management through CBR and fuzzy based characterization"