基于XML异构数据库数据转换技术的研究

Research on Heterogeneous Database Based on XML Data Conversion Technology

文章是对数据共享和同步技术的研究,主要是针对不同部门数据库之间的数据转换技术,采用系统服务组件的设计理念,耦合程度低。主要实现方式是采用XML文件格式来描述异构数据库的结构信息,然后采用模糊匹配的方式计算两个数据库的异构程度,抽象出符合目标数据库的表结构。最后按照这个结构抽取源数据库的有用数据,导入目标数据库中。

This article is a research on the data sharing and synchronization, mainly for the data exchange technology between databases of different sectors. The file of XML is used to describe the heterogeneous structure of the database information, and then calculate heterogeneous degree of two databases by using the fuzzy matching after taking out the table structure which in line with the target database. Finally, according to the structure of source database which contain useful data, it could be imported to the target database.