A Review Paper on Different Approaches for Query Optimization using Schema Object base View
Dhaval J. Patel, Pratik Patel · International Journal of Computer Applications · 2015
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 warehouses.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.In this paper, the different techniques is given for optimizing query using schema based and materialized views in data warehouse namely-view adaptation & synchronization, view selection and view maintenance.