数据交换平台中异构数据转换技术的研究

Research of heterogeneous data transformation in data exchange platform

为了有效地解决数据交换时数据表示的通用性问题,使得数据在不同的业务系统间都能够被识别,本课题采用调查研究和文献研究相结合的方法,首先对淮北矿业集团各业务系统数据库中数据表进行统计和分析,重点分析了需要转换数据的类型和逻辑关系,总结出其所有数据转换的逻辑关系,然后参考现有文献资料中提出的数据转换模型,最后制定出有独创性的数据源标准和数据映射标准。并采用通用的数据描述语言——XML(eXtensive MakeupLanguage)将其主要部分表示出来。该数据标准有着数据表示范围超越数据表、数据转换的静态模型和动态模型相结合、数据表示和实体数据库相分离等特点。通过项目实践,证明了该标准能够解决数据表示的通用性问题,能够实现了数据在不同业务系统之间识别与转换。

In order to effectively solve the question of data representation generality when data wanted to exchange, allow data between different business systems can be identified, through survey and literature research, firstly, this topic statistical analysised the database tables of each business systems in huaibei coal mine group company, and mainly analysised the types and logical relationships of data wanted to exchange, summarized all of the logical relationships of data exchanging, then referenced data exchanging models put forward in reference literatures, and finally worked out one ingenious standard of data resource and data mapping standards. Using universal data description Language - XML （eXtensive Makeup Language）, represented it. This data standards had serval features, such as data representation scope was beyond the data table, unions the data transformation static models and dynamic models, data representation and actual database is separated. With the project practice, this standard could been proved to solve the questions of data representation generality and can realize data recognition and transformation between the different business systems.