Data Extraction Using Materialized Views

Abstract

A data warehouse uses multiple materialized views to efficiently process a given set of queries. Materialized views selection is one of the crucial decisions in designing a data warehouse for optimal efficiency. The idea of reusing materialized results of previous data mining queries may lead to improve the performance of the system. In creating the materialized views, SQL statements are automatically generated from the system to create view table and to entry data. However, Query views need to select the desired field names and table names from the database. Materialized views are required to achieve faster query in the data warehouse. This paper also compares the execution time of the materialized view and database query view. To get fast answer, creating materialized views on photo studio data warehouse is the best.