The Data Warehouse System Design And Achievement Basic On Oracle

In the current enterprise management,the role of information is becoming more and more obvious.The data warehouse provides the data support for enterprises in decision-making process,and greatly improves the efficiency and accuracy of enterprise management.This article is based on the project requirements of the Pacific Insurance Group M5 information management data warehouse project,has developed the overall implementation plan of DW,and used Oracle 11 g and ETL tools to enable the project to be successfully deployed.The traditional architecture of DW integrated mode is improved,the hierarchical structure construction of various departments in the Pacific Insurance Group and Pacific Insurance Group,enhance the controllability and safety of the whole process of updating DW data.Use the ETL tool in this project is IBM DataStage,the interface is simple,quality after thoroughly tempered,can according to the specific needs of the project two times to develop the relevant function.At present,the project has entered the stage of continuous improvement,the project team has completed all the tasks of the development phase,and successfully used in line production environment.The design and implementation of the capital market data warehouse has high practical value in the construction and improvement of the information platform of the Pacific Insurance group.