为解决基于商务智能的业务流程评估系统中的ETL问题,确保评估系统能够更加高效、及时、准确地从异构数据源中获取流程数据,在既有流程评估模型的基础上,搭建应用于流程数据的ETL架构,并对整个架构进行详细的描述。以此为基础,分析现有ETL解决方案以及流程数据的特点,制定应用于业务流程数据的转换规则,确保流程日志中的数据能够快速准确地转换成评估系统需要的标准数据;设计流程数据转换算法。通过某保险公司的流程数据进行了仿真分析,分析结果表明了该模型的可行性和算法的有效性。
To resolve ETL problems in business process assessment system based on business intelligence, ensure the assessment system being more efficient, timely and accurate when accesses process data from heterogeneous data sources, firstly an ETL architecture applied to process data on the basis of the existing evaluation process model was proposed, and a detailed description on the entire structure was given. Based on this structure, the existing ETL solutions and characteristics of the process data were analyzed, and a data transform algorithm was designed to make sure that the data in event logs were quickly and accurately con verted into standard data that the system needed. Finally, process data of an insurance company were simulated to verify the feasibility of the model and the effectiveness of the algorithm.