Improving query processing performance in database management systems

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%.