Creation of Query View Using Materialized View

Abstract

A data warehouse is a redundant collection of data replicated from several possibly distributed and loosely coupled source databases organized to answer On-Line Analytical Processing (OLAP) queries. OLAP queries are typically aggregate queries over very large fact tables of Data Warehouse. This paper can create tables by organizing data that are mostly used by users and. can also show time comparison between the time taken to retrieve data from the original database and the time taken to retrieve data from the materialized views. To get fast answers, creating materialized views on that data warehouse is the best. A materialized view is the precalculated (materialized) result of a query. Materialized Views are used when immediate response is needed.