Research And Design On The Data Warehouse Of The Inner Mongolia PICC

In recent years,China's insurance industry has maintained a sustained,rapid and healthy development of the good momentum,expanding business scale.With the gradual opening of China's insurance market,more and more foreign insurance companies have entered the domestic market,the market competition is becoming increasingly fierce.Through the research on the construction of data warehouse in insurance companies,the significance is to establish a data warehouse model which is close to the actual business of the insurance company.In the end,the quick feedback of the insurance data can provide the data base for the insurance company's management to make scientific decision.The purpose of this research is to use data warehouse design principle to analyze the actual business of the Inner Mongolia PICC,and combine with the actual business needs,set up a set of data warehouse for Inner Mongolia PICC.In this paper,the data standardization rules are set up according to the use of the data in Inner Mongolia,and the logical model of the operation data storage model and data mart is sorted out.Finally,the ETL construction through the data warehouse to get through the various levels.Finally build a data warehouse system which is suitable for the Inner Mongolia PICC to protect the actual needs.In this paper,the function of the main modules in the data warehouse system of Inner Mongolia PICC are discussed in detail,and the design and function of the system are realized.All functions of the system have been developed and tested,and the trial operation is carried out in some pilot areas And achieved good results.