Abstract:
Improving Query Processing Performance in Database Management Systems has been
a research challenge. This is the most important and is a real problem, this happens to
be very crucial in large organizations with heterogeneous data, online system, billing
systems and so on. Among other issues in the query optimization problem, faced by
everyday query optimizers, get more and more complex with the server increasing
complexity of user queries. During the last decade, database management systems have
become important information processing system supporting business activities of
geographically decentralized organizations.
The Performance monitoring has been evaluated and used by various tools. Most DBA's
agreed that these tools are valuable. Our research also tried to identify how performance
problems could be reduced and which methods were used in practice. Besides hardware
upgrades, the following areas in tuning are known to have major impacts.
The main aim of this thesis is to produce flexible database monitoring tool and query
optimization techniques that is capable of get basic idea of database server, database
log, missing indexes, graphical user interface of currently running queries, optimizing
large queries in a complex database. Among other issues in a database, such as
deadlock, expensive query, primary key missing places, badly design quarries can be
simply identified.
This database monitoring tool and proposed new optimization techniques will more
helpful to identify database performance issues and provide better solutions. During the
evaluation, it was shown that system was successful more than 70%.
