| Author(s) | Hassan Mathkour |
| Affiliation | Computer Science Department. College of Computer & Information Sciences. King Saud University. P.O. Box 5Il7B. Riyadh Il543. Saudi Arabia |
| Title | An Intelligent Tool for Boosting Database Performance |
| Source | Journal of King Saud University. Computer & Information Sciences. Volume 10, No 1. (1998/1418) |
| Abstract | An intelligent database monitoring and tuning tool is designed and developed. The tool is an integration of a learning system, an expert system shell, and a tuning system that is linked to an RDBMS. The learning system makes use of two learning algorithms to extract commonalties exhibited by the database queries. The concepts learnt by the learning system are verified by a knowledge based system (KBS) maintaining knowledge about the database application, heuristics, and expertise about database systems. The KBS is constructed using the expert system shell. The tool is implemented using the programming language C and the shell Exsys Professional Version 4.0 and linked to the RDBMS Oracle. It is argued that the learning algorithms alone are not sufficient to arrive at the most suitable tuning decisions as they only recognize the syntactical forms of the queries. The presence of knowledge based systems makes it possible to see through the semantic aspects of the attributes involved in the queries. |
