Based On The Iaa In The Insurance Industry Database System Design And Realization

Insurance industry in China keeps on developing at tremendous speed. Information technology will play an important role in the sustained and healthy development of insurance industry.Many companies started to set up the insurance data warehouse system to make them more competitive.To CPIC(China' s pacific insurance company),setting up the data warehouse system can help to improve the decision-making capabilities for analyzing, enhance customer satisfaction,keep the policy continue rate.In this paper,we use the underwriting data of life insurance in CPIC. By analyzing the business needs,designing the system architecture and data model,designing the ETL system,we do the research of building the insurance data warehouse.(1) By analyzing the business needs,choose the IAA(Insurance Application Architecture) mode andâ…¡W(Insurance Information Warehouse) level architecture to design the system architecture.(2) Considering the specificity of insurance' s data,we use some methods to solve the problems of designing the data model.We use anchor to solve the problem of complex and changeable of primary key which caused by Multi-system integration.The anchor also improves the system' s scalability.We use partition key to improve the efficiency of data warehouse.We Use relationship table and use Left/Right Entity ID in relationship and relation Entity to improve the flexibility of relationship.We add status table to entity table of policy and claim to solve the problem of frequent changes of policy and claim.(3) Use the products of Congnos to enhance the interface display.The EDW system has been tested and is running well now.On the next step,we will focus on the data mining part to find the solution of analysis decision.