The Etl In The Business Systems Of The Isbn Center Applications

This paper introduces ETL principle, data transformation technology, the development status of transformation tools. After analyzing the data integration theory and technology, this paper has pointed out the weak point of the existing tool. This paper proposes ETL tool solution based on XML technology, which according to the actual demand of ISBN center's system. The solution partly transfers the large loading pressure of existing database server, solves the loading problem of the database server, and balances utilization ratio of every server to a certain extent.Accounting to the new demand that the actual project puts forward, this paper adopts XML as the main technological means, and sets up the model such as the model to obtain the metadata of heterogeneous database, the model based on XML language which used to transform and clean data and the task scheduling model to execute the working flow. The author has studied the technological problem to be solved in the transforming course. Based on the model told in the past, the author develops the integrated tools for data which corresponding the four stages of ETL tools, this tool can support RDBMS, Excel file and data from multi-source. User can design transform flow and transform rules himself. Author had test this tool with multiple data source and give a example how the data to be transformed. At the end of the paper, the author thinks what needs to do in the further.