Development of Intelligent Tools for Detecting Resource-intensive Database Queries

The detection of resource-intensive queries which consume an excessive amount of time, processor, disk, and memory resources is one of the most popular vulnerabilities of Database Management Systems (DBMS). The tools for monitoring and optimizing queries typically used in modern DBMS were analyzed, and their shortcomings were identified. Subsequently, the relevance of new intelligent tools’ development for timely and reliable detection of resource-intensive queries to databases was distinctly justified. The study concluded a set of analysis of an extended statistical parameter which indicated to be of interest for identifying resource-intensive queries. The initial set of queries’ parameters reduced by two consecutive methods. Firstly, normalizing the set of indicators using a sigmoid function. Secondly, selecting a finite number of principal components based on the Cattell test. Whereas the clustering of a set of queries performed using self-organizing Kohonen maps. Suggestions for further studies in the classification algorithm context were indicated in lights of the study’s conclusions.

@article{Alghazali2021,
  title     = {Development of Intelligent Tools for Detecting Resource-intensive Database Queries},
  journal   = {International Journal of Advanced Computer Science and Applications},
  volume    = {12},
  number    = {7},
  year      = {2021},
  publisher = {The Science and Information Organization},
  author    = {Salah M.M. Alghazali and Konstantin Polshchykov and Ahmad M. Hailan and Lyudmila Svoykina},
  doi       = {10.14569/IJACSA.2021.0120704},
  url       = {https://doi.org/10.14569/IJACSA.2021.0120704}
}