Database workload management through CBR and fuzzy based characterization
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 suf...
Saved in:
Main Authors: | , , , , |
---|---|
Format: | Article |
Language: | English |
Published: |
Elsevier
2014
|
Online Access: | http://psasir.upm.edu.my/id/eprint/36964/1/Database%20workload%20management%20through%20CBR%20and%20fuzzy%20based%20characterization.pdf http://psasir.upm.edu.my/id/eprint/36964/ https://www.sciencedirect.com/science/article/pii/S1568494614001951?via%3Dihub#! |
Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
id |
my.upm.eprints.36964 |
---|---|
record_format |
eprints |
spelling |
my.upm.eprints.369642019-11-29T03:32:53Z http://psasir.upm.edu.my/id/eprint/36964/ Database workload management through CBR and fuzzy based characterization Abdul, Mateen Muhammad, Awais Mian Mustapha, Norwati Muhammad, Sher Ahmad, Nisar 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. Elsevier 2014-09 Article PeerReviewed application/pdf en http://psasir.upm.edu.my/id/eprint/36964/1/Database%20workload%20management%20through%20CBR%20and%20fuzzy%20based%20characterization.pdf 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 https://www.sciencedirect.com/science/article/pii/S1568494614001951?via%3Dihub#! 10.1016/j.asoc.2014.04.030 |
institution |
Universiti Putra Malaysia |
building |
UPM Library |
collection |
Institutional Repository |
continent |
Asia |
country |
Malaysia |
content_provider |
Universiti Putra Malaysia |
content_source |
UPM Institutional Repository |
url_provider |
http://psasir.upm.edu.my/ |
language |
English |
description |
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. |
format |
Article |
author |
Abdul, Mateen Muhammad, Awais Mian Mustapha, Norwati Muhammad, Sher Ahmad, Nisar |
spellingShingle |
Abdul, Mateen Muhammad, Awais Mian Mustapha, Norwati Muhammad, Sher Ahmad, Nisar Database workload management through CBR and fuzzy based characterization |
author_facet |
Abdul, Mateen Muhammad, Awais Mian Mustapha, Norwati Muhammad, Sher Ahmad, Nisar |
author_sort |
Abdul, Mateen |
title |
Database workload management through CBR and fuzzy based characterization |
title_short |
Database workload management through CBR and fuzzy based characterization |
title_full |
Database workload management through CBR and fuzzy based characterization |
title_fullStr |
Database workload management through CBR and fuzzy based characterization |
title_full_unstemmed |
Database workload management through CBR and fuzzy based characterization |
title_sort |
database workload management through cbr and fuzzy based characterization |
publisher |
Elsevier |
publishDate |
2014 |
url |
http://psasir.upm.edu.my/id/eprint/36964/1/Database%20workload%20management%20through%20CBR%20and%20fuzzy%20based%20characterization.pdf http://psasir.upm.edu.my/id/eprint/36964/ https://www.sciencedirect.com/science/article/pii/S1568494614001951?via%3Dihub#! |
_version_ |
1651869049567576064 |
score |
13.19449 |