UPM Institutional Repository

Database workload management through CBR and fuzzy based characterization


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


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.

Download File

PDF (Abstract)
Database workload management through CBR and fuzzy based characterization.pdf

Download (85kB) | Preview

Additional Metadata

Item Type: Article
Divisions: Faculty of Computer Science and Information Technology
DOI Number: https://doi.org/10.1016/j.asoc.2014.04.030
Publisher: Elsevier
Keywords: Workload; Autonomic DBMS; Characterization; Scheduling; Idleness detection
Depositing User: Nabilah Mustapa
Date Deposited: 30 May 2015 01:30
Last Modified: 29 Nov 2019 03:32
Altmetrics: http://www.altmetric.com/details.php?domain=psasir.upm.edu.my&doi=10.1016/j.asoc.2014.04.030
URI: http://psasir.upm.edu.my/id/eprint/36964
Statistic Details: View Download Statistic

Actions (login required)

View Item View Item