Study on Integration Model Based on Two-Stage Transformation

Data importing and exporting are essential processes in data integration. Although the present tools of data integration could efficiently extract and transform data, they could hardly handle data aggregation in the establishment of database. Therefore, the paper advances two-step transformation integration model to resolve the problem. The model could automatically determine order conversion and efficiently integrating data such as accumulate plus and subtract without users programming. The model is convenient to use with the GUI interface. It is realized with XML script with portability and extensive application field. Moreover, aiming at the transformation failure caused by transformation order, the paper presents algorithms for automatically determining transformation order conversions.