Efficient Algorithms for Materialized View Selection in Data for Materialized View Selection in Data for Materialized View Selection in Data for Materialized View Selection in Data Warehousing Environment Warehousing Environment Warehousing Environment Warehousing Environment

The notion of data warehouse can be defined as subject-oriented, integrated, nonvolatile and time-variant collection of data in support of making management’s decision effectively, for the success of data warehouse accurate and timely consolidated information as well as quick query response times is the fundamental requirement. To avoid accessing from base table and increase the speed of queries posted to a Data warehouse, we can use some pre-computed intermediate results from the query processing stored in the data warehouse called materialized views. The result of effective Materialized view selection provides an efficient data warehousing system. However, the materialized view needs to be effectively maintained to keep its contents integrated and consistent with the contents of its data sources. The materialized views have maintenance cost, that’s why materialization of all views is not possible.