Design And Application Of ETL In Insurance Management System

The management system is an important basic tool for management of insurance companies.The purpose is to establish a grafting platform between the company's strategy and the overall budget management,and promote the management of all levels of management with the common data language services to guide the company's overall budget management,in order to achieve profit targets and achieve performance incentives.The thesis gives the design and implementation of the management system with the characteristics of the insurance industry.This thesis analyzes and designs the demand of the management system of the insurance company,and introduces the overall structure design of the system.In ETL(Extract Transform Clear Load)detailed design and implementation phase,the ETL is set up regularly,and then the ETL process is designed in detail.ORACLE stored procedure and JOB scheduling are used as ETL tools to realize the ETL process of source data to target database and task scheduling.Finally,the design of data warehouse model and the realization of function are introduced.The online analytical processing tool uses IBM's Cognos.Front-end display development tools using Microsoft Silverlight and Cognos perfect combination of business intelligence application visualization.For the insurance industry scale,branch,business complex these characteristics,the topic to solve the most important problem is that the system can be a variety of business systems to collect and summarize the data,so that users from a variety of dimensions and a variety of Data comprehension to view the data,so as to make the right decisions.At the same time,in order to realize the open,transparent,multidimensional and dynamic construction requirements of the management system,and to ensure the security of the data and the rigor of the budget,this thesis gives the system authority management method.Since the decision maker will use this tool to analyze the data in real time,it is necessary to consider its ease of use,making it simple and powerful.The research work of the thesis will realize the combination of business intelligence multidimensional data table and insurance industry,and put forward a complete design scheme.Management system through the deployment,testing and practical application of the test,the system functions and performance are able to meet the requirements of the system design,implementation and application to meet the demand.The system is running stable.