An Approach for Query Optimization by using Schema Object Base View

Abstract

Mining of Data is the extraction of hidden prognosticative information from large databases or set of data, is a strong new technology with great prospective to help companies focus on the most important information in their data base. Query optimization is a purpose of many relational database management systems. The query optimizer experiments to dictate the most efficient way to implement a given query by examining the possible query plans. There are different techniques is given for optimizing query using schema based and materialized views in data base namelyQuery Graph, Tableaus, Optimization of Queries having Aggregates. In this paper we are using Different query optimization parameter and create an effective approach by using this approach we are reduce query execution cost, query space and more effectible for the query. The complexity of Queries severely increase the execution cost of the queries and have a critical effect on performance and productivity of decision support systems. It is required to perform expensive join and aggregation operations frequently on the databases. Now if they are not pre calculated in advanced then it leads to reduce query performance. Schema object improve query performance by pre calculating expensive join and aggregation operations on the database prior to execution and storing the results in the database. Schema object define not only relationships, but also allow you to recompute expensive joins and aggregations which lead to optimized query performance in possible ways. Schema object leads to the decrease Query processing cost and Query Maintenance cost in terms of Time factor. Schema object improve query performance by pre calculating expensive join and aggregation operations on the database prior to execution and storing the results in the database. The big advantage of a Schema object based views is extremely fast retrieval of aggregate data, since it is precomputed and stored, at the expense of insert/update/delete so that it increase query performance than the ordinary view and table. Schema object based view is also called Materialized view.