Abstract:
An intelligent database monitoring and touring 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 applications, 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. The learning algorithms and their applicability to database applications are reviewed. 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.
Page(s):
36-50
DOI:
DOI not available
Published:
Journal: New Horizons: Journal of the Institution of Electrical & Electronics Engineers Pakistan, Volume: 35, Issue: , Year: 1997