Research And Implementation Of Data Migration Based On Similarity Of Business Process Model

Data migration plays a very important role in the updating process of information systems.The general data migration is often based on the clear documentation of the old system.By establishing the correct data mapping,using appropriate engineering management tools and migration tools,the progress and quality of the migration are guaranteed.However,in the absence of data documents,whether we can solve the problem of data mapping and complete the task of data migration is the main problem to be studied in this paper.The research of paper is based on the actual project of a liquefied petroleum gas company in Shanghai.The main work includes:(1)Found the way to solve the data mapping problem from the perspective of process model similarity comparison.Through the analysis of the correlation between the data flow model and the business process model,this paper proposed to find the solution to the data mapping from the similarity of the process model.(2)Analyzed and compared the common business process modeling methods and applied them.Based on the actual project requirements,this paper analyzed and compared the common process modeling methods IDEF,UML,Petri net,and conducted Petri net modeling for the actual project.(3)Analyzed and compared different types of model similarity algorithms and applied them.Based on the actual project requirements and the characteristics of the Petri net model,this paper selected the tree edit distance algorithm based on the task structure tree and the TAR algorithm to calculate the similarity between the old and new models respectively,and obtained the matching relationship between the process and the process nodes.(4)Studied the method of obtaining data mapping through process model and process node matching.This paper found the table association relationship through MS Sqlserver Profiler,and found the possible data mapping relationship by analyzing the table structure and the way the business defines the data.(5)Data migration implementation.This paper used a combination of programming and data migration tool Kettle to migrate data from old system to new system.The data migration implementation results of the actual project showed that the migrated data can pass the double-run test and report verification.Therefore,in the absence of data documents,it is feasible to solve the data migration problem from the perspective of business process model mapping,which provides a new idea for the design of data migration,and has certain research and practical value.