Research And Application Of Materialized Views In The Data Warehouse

Data warehouse is a subject-oriented, integrated, time-variant, non-volatile data collection, management support decision-making process. In today’s society, any business decision makers for the survival and development of enterprises, all in the decision support efforts. In the past period of time, many large enterprises have spent a lot of manpower and material resources to build enterprise-wide data warehouse.Materialized view technology is a technology that can achieve many normal view can not be achieved Oracle Corporation. Materialized view is the result of a query database object, which is a local copy of the remote data. Materialized view simple operation, supports incremental refresh, One of the biggest advantages is to improve the performance, materialized views precomputed way to save various tables or gathered more time-consuming operation results in the creation process through, thus greatly improving the query operational efficiency, and speed up the response time, but also reduce the server load.Large amount of data in the data warehouse, the query needs are more complex, real-time data changes need to be synchronized to the data warehouse, these problems have a very high demand for the Design and Implementation of the data warehouse. The many advantages of the materialized view technology just to meet the demands of the data warehouse, so build the materialized view is particularly important in the data warehouse.This paper describes a data warehouse, the materialized view technology concept. And materialized view technical in land tax Guizhou provincial bureau data set project to create a data warehouse. Large amount of data materialized view fast refresh mechanism to do the test, combined with the actual situation of the project data refresh adjusted accordingly.