Research And Design Of Etl In Process Assess System Based Cn Business Intelligence

With a wide application of business intelligence applications, a large number of records stored in business systems and people began to concern the business process execution log information. Full use of these data to achieve business process reengineering and optimization has become the focus of enterprise. With the development of business process intelligence, it tends to be a practical application that enterprises can get the business knowledge through the analysis, collection, and management of process data. Process evaluation system is based on the practical application of business intelligence business process intelligence system. It will process the data collected from the process logs in the warehouse and evaluate the process and then analyze the data by means of business intelligence, gives quantitative assessment results and finally help companies improve their decision-making. ETL is an important part of building process warehouse, and it is also a bridge between business systems and business intelligence system. It is useful for the quality improvement of the process data evaluation system and the efficiency improvement of building process warehouse.In order to meet the requirement of process evaluation system based on business intelligence, this paper verifies the object of process data conversion with ETL by description of process evaluation system based on business intelligence. It includes the construction of ETL model based on CWM standard, and particular introduced the extraction of process data in heterogeneous data sources. Through analyzing the types and causes of incorrectness data and inconsistent data, this article makes rules suitable to the process data conversion and gives the application and conversion framework for data conversion.To improve the efficiency of ETL and make full use of limited computer resources, the mathematical model of ETL task scheduling is established. By analyzing the mathematical model, the method of ETL task scheduling is proposed based on non-empty strategy and analysis hierarchy process. Finally, this paper put forward the implementation way of ETL based on CWM standard and verifies the task scheduling model through the examples of insurance and claims in an insurance company.In this paper, process data transformation can be better realized through the ETL model based on CWM standards. It can meet the needs of process evaluation system based on business intelligence, and lay a solid foundation for the follow-up work of the construction of process warehouse.