Facebook pixel tracking

The Science and Information (SAI) Organization publishes open-access peer-reviewed journals in computer science and artificial intelligence.

Contact Info
Email info@thesai.org
Website thesai.org
Follow Us
Contact Info
Email info@thesai.org
Follow Us
Research Article | Open Access |

An Adaptive Hybrid Controller for DBMS Performance Tuning

Author 1: Sherif Mosaad Abdel Fattah Author 2: Maha Attia Mahmoud Author 3: Laila Abd-Ellatif Abd-Elmegid
International Journal of Advanced Computer Science and Applications (IJACSA) · Vol. 5, No. 5 · Published 2014

DOI: https://doi.org/10.14569/IJACSA.2014.050523

Download PDF Cite Call for Papers

Abstract

Performance tuning process of database management system (DBMS) is an expensive, complex and time consuming process to be handled by human experts. A proposed adaptive controller is developed that utilizes a hybrid model from fuzzy logic and regression analysis to tune the memory-resident data structures of DBMS. The fuzzy logic module uses flexible rule matrix with adaption techniques to deal with fluctuations and abrupt changes in the operation environment. The regression module predicts fluctuations in operation environment so the controller can take former action. Experimental results on standard benchmarks showed significant performance enhancement as compared to built-in self-tuning features.

Keywords

automatic database tuning fuzzy logic adaptive controller regression self-tuning DBMS

How to Cite this Article

Fattah, S. M. A., Mahmoud, M. A., & Abd-Elmegid, L. A. (2014). An Adaptive Hybrid Controller for DBMS Performance Tuning. International Journal of Advanced Computer Science and Applications, 5(5). https://doi.org/10.14569/IJACSA.2014.050523

Fattah, Sherif Mosaad Abdel, et al.. "An Adaptive Hybrid Controller for DBMS Performance Tuning." International Journal of Advanced Computer Science and Applications, vol. 5, no. 5, 2014, https://doi.org/10.14569/IJACSA.2014.050523.

@article{Fattah2014,
  title     = {An Adaptive Hybrid Controller for DBMS Performance Tuning},
  journal   = {International Journal of Advanced Computer Science and Applications},
  volume    = {5},
  number    = {5},
  year      = {2014},
  publisher = {The Science and Information Organization},
  author    = {Sherif Mosaad Abdel Fattah and Maha Attia Mahmoud and Laila Abd-Ellatif Abd-Elmegid},
  doi       = {10.14569/IJACSA.2014.050523},
  url       = {https://doi.org/10.14569/IJACSA.2014.050523}
}

Open Access — licensed under a Creative Commons Attribution 4.0 International License. Unrestricted use, distribution, and reproduction in any medium, even commercially, as long as the original work is properly cited.

Back to Issue
IJACSA Journal Cover

IJACSA