Design And Implementation Of The SVG-Based Data Migration System

With the rapid development of information technology, information management systems have been constantly upgraded and integrated. Thus, it is necessary to discuss problems of data migration. Data migration tools existing have deficiencies on data conversion, data mapping relations and so on. Therefore, we research on data migration technologies,and make a relevant tool.Based on comparison and analysis of existing data conversion methods, we design a DataSet-based method. Data migration is not simple data transfer, also involves access to the heterogeneous databases, data conversion, visually mapping model, mapping document analysis, and data engine. By dynamicly setting a data source of the ODBC, we can access heterogeneous databases. The ususal data conversion method is to design a data type mapping table. However, it is passive, and lack of flexibility. Therefore, we design an ODBC data type mapping model to accomplish data mapping automatically. At present, research on the establishment of data mapping is not too much. We have a dynamic and visual approach to migrate data by means of SVG(Scalable Vector Graphics, SVG) technology applied to data mapping model involving SVG object model description and SVG elements design. Every SVG element will be preserved in a mapping document. Then we build a mapping tree by analyzing the mapping document using the DOM technology. As the traversing tree algorithm used to implement the mapping tree, will increase complexity of data structure and running time, we design a data engine to drive data in the right direction to the corresponding mapping data nodes.The SVG-based data migration system can complete data migration not only between heterogeneous databases, but also between the database and XML document. Test showes that this system runs well.