Utilizing Staging Tables in Data Integration to Load Data into Materialized Views

rces. A data warehouse can be abstractly seen as a set of materialized views. Selecting views for materialization in a data warehouse is one of the most important decisions making tasks in its design. However, there are few facilities in data integration systems that consider these important issues. In this paper, we propose the approach of introducing staging table's schema that can be utilized to load required data from source tables into corresponding staging tables. Staging tables will be assumed to be temporary tables and each staging table will be empty before loading new data and using simple non-join queries to load data. We then focus on an approach to load data into data warehouse materialized views through staging tables including maintenance of materialized views. References:

• Type: Conference
• Year: 2004
• Where: CIS
• Authors: Ahmed Ejaz, Kenneth Revett
• Keywords: Applied Computing, CIS 2004, Data Warehouse, Materialized Views, Staging Tables