Future of Information and Communication Conference (FICC) 2024
4-5 April 2024
Publication Links
IJACSA
Special Issues
Future of Information and Communication Conference (FICC)
Computing Conference
Intelligent Systems Conference (IntelliSys)
Future Technologies Conference (FTC)
International Journal of Advanced Computer Science and Applications(IJACSA), Volume 5 Issue 5, 2014.
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.
Sherif Mosaad Abdel Fattah, Maha Attia Mahmoud and Laila Abd-Ellatif Abd-Elmegid, “An Adaptive Hybrid Controller for DBMS Performance Tuning” International Journal of Advanced Computer Science and Applications(IJACSA), 5(5), 2014. http://dx.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},
doi = {10.14569/IJACSA.2014.050523},
url = {http://dx.doi.org/10.14569/IJACSA.2014.050523},
year = {2014},
publisher = {The Science and Information Organization},
volume = {5},
number = {5},
author = {Sherif Mosaad Abdel Fattah and Maha Attia Mahmoud and Laila Abd-Ellatif Abd-Elmegid}
}
Copyright Statement: This is an open access article licensed under a Creative Commons Attribution 4.0 International License, which permits unrestricted use, distribution, and reproduction in any medium, even commercially as long as the original work is properly cited.