基于SDO的异构数据集成研究与应用  

Research and Application of Heterogeneous Data Integration Based on SDO

作　　者：郑垒[1] 曹宝香[1] 

机构地区：[1]曲阜师范大学计算机科学学院,山东日照276826

出　　处：《计算机技术与发展》2009年第11期163-166,共4页Computer Technology and Development

基　　金：山东省教育科研计划项目(J05G03)

摘　　要：为解决现存的异构数据集成解决方案中对异构数据处理没有统一的标准、硬编码多、集成系统扩展性差等问题,提出了基于SDO规范的异构数据集成方案。设计实现了一个统一的数据访问界面;利用数据访问服务封装了各种异构数据源,并将结果以同一种格式暴露给集成系统,实现了对数据源中数据访问、操作方式的统一;在查询分解方面,给出了基于数据源配置文件的查询分解方法,集成系统根据配置文件就可以与相应的数据源取得连接,而且只要修改相应的配置文件,就可以实现数据源的灵活修改;最后将该方案在基于WEB的PLM系统中进行了应用,验证了方案的可行性。实现结果表明该方案开发量小、扩展性好、效率高,能够很好地满足企业异构数据集成的需要。In order to resolve the problems of the existing solutions of heterogeneous data integration, including no uniform standard for the treatment of heterogeneous data, too much hard- coded and poor extendibility, propose a solution based on SDO for heterogeneous data integration. It designs and achieves a unified data access interface; Data access service encapsulates multiple data resources and returns results using the same format, which unifies the methods of data access and data manipulation; A query decomposition method based on configuration files of data sources is given in query decomposition respect. By the configuration files, the integration system can obtain connections with the corresponding data sources. And as long as the configuration file is modified, the system can implement the flexible modification of data sources. Finally, the integrated solution is applied to the PLM system based on WEB project, and its feasibility is verified. The experimental result illustrates that this solution can reduce the ease of development, and has good extendibility and high effi- ciency. It can very well meet the needs of heterogeneous data integration.

关 键 词：服务数据对象 数据集成 异构数据源 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]