异构数据库高效数据交换引擎设计

黄学彬,赵春,郑伟

doi:10.13718/j.cnki.xsxb.2014.09.018

西南师范大学学报(自然科学版)

留言板

尊敬的读者、作者、审稿人, 关于本刊的投稿、审稿、编辑和出版的任何问题, 您可以本页添加留言。我们将尽快给您答复。谢谢您的支持!

姓名
	姓名不能为空！
邮箱
	邮箱不能为空！非法的邮箱地址。
手机号码
	电话不能为空！请输入有效手机号!
标题
	标题不能为空！
留言内容
	内容不能为空！
验证码
	验证码不能为空！验证码错误！

异构数据库高效数据交换引擎设计

黄学彬,赵春,郑伟. 异构数据库高效数据交换引擎设计[J]. 西南师范大学学报(自然科学版), 2014, 39(9). doi: 10.13718/j.cnki.xsxb.2014.09.018

引用本文:

黄学彬,赵春,郑伟. 异构数据库高效数据交换引擎设计[J]. 西南师范大学学报(自然科学版), 2014, 39(9). doi: 10.13718/j.cnki.xsxb.2014.09.018

HUANG Xue-bin,ZHAO Chun,ZHENG Wei. On Design of Heterogeneous Database Efficient Data Exchange Engine[J]. Journal of Southwest China Normal University(Natural Science Edition), 2014, 39(9). doi: 10.13718/j.cnki.xsxb.2014.09.018

Citation:

HUANG Xue-bin,ZHAO Chun,ZHENG Wei. On Design of Heterogeneous Database Efficient Data Exchange Engine[J]. Journal of Southwest China Normal University(Natural Science Edition), 2014, 39(9). doi: 10.13718/j.cnki.xsxb.2014.09.018

异构数据库高效数据交换引擎设计

黄学彬,赵春,郑伟

四川大学锦城学院教务部,成都,611731 四川大学锦城学院计算机科学系,成都,611731

On Design of Heterogeneous Database Efficient Data Exchange Engine

HUANG Xue-bin,ZHAO Chun,ZHENG Wei

摘要: 针对异构数据库之间数据交换软件的数据交换不规范、网状数据不通畅、数据同步无保证等问题，设计了一个通用安全高效的数据交换引擎。该设计采用影子表法获取数据，利用文本差异比较得出变化的数据量，并运用差异分析算法解析出数据变化结果集。设计中的数据交换规则与数据更新结果存储均采用了XM L文件格式作为媒介，为了保证数据的安全性与可靠性，设计要求对需要传输的数据进行加密处理，并采用可靠的TCP作为数据传输协议的载体。实验表明，该文设计的异构数据库交换引擎可以高效率地完成异构数据库之间可靠、安全的数据交换。
- 异构数据库 /
- 高效数据交换 /
- XML /
- 差异分析 /
- 影子表法
Abstract: To solve the problems such as the irregular of the data exchange software in data exchange ,the unobstructed network data and the unguaranteed data synchronism of the heterogeneous database data ex-change ,an common ,safe ,efficiency data exchange engine has been proposed in this paper .With this en-gine ,the shadow table method has been adopted to get the proper data ,and diff method used to get the changed data ,and an algorithm designed to analyze the diff files to get the changed data set .This engine defines the rules and store the changed data use the common ,portable XML ,and takes advantage of TCP protocol and multi-threads and breakpoint transmission to make sure the quality of the file transmission . The encode method has been utilized to make sure the safety of the data .The experiment indicates that the data exchange engine this paper designed can complete the data exchange between the heterogeneous data-bases .
- heterogeneous database，efficient data exchange，XM L，differential analysis，shadow table method /

计量

文章访问数: 718
HTML全文浏览数: 537
PDF下载数: 0
施引文献: 0

异构数据库高效数据交换引擎设计

黄学彬,赵春,郑伟

四川大学锦城学院教务部,成都,611731 四川大学锦城学院计算机科学系,成都,611731

关键词:

摘要: 针对异构数据库之间数据交换软件的数据交换不规范、网状数据不通畅、数据同步无保证等问题，设计了一个通用安全高效的数据交换引擎。该设计采用影子表法获取数据，利用文本差异比较得出变化的数据量，并运用差异分析算法解析出数据变化结果集。设计中的数据交换规则与数据更新结果存储均采用了XM L文件格式作为媒介，为了保证数据的安全性与可靠性，设计要求对需要传输的数据进行加密处理，并采用可靠的TCP作为数据传输协议的载体。实验表明，该文设计的异构数据库交换引擎可以高效率地完成异构数据库之间可靠、安全的数据交换。

English Abstract

On Design of Heterogeneous Database Efficient Data Exchange Engine

四川大学锦城学院教务部,成都,611731 四川大学锦城学院计算机科学系,成都,611731

Keywords:

Abstract: To solve the problems such as the irregular of the data exchange software in data exchange ,the unobstructed network data and the unguaranteed data synchronism of the heterogeneous database data ex-change ,an common ,safe ,efficiency data exchange engine has been proposed in this paper .With this en-gine ,the shadow table method has been adopted to get the proper data ,and diff method used to get the changed data ,and an algorithm designed to analyze the diff files to get the changed data set .This engine defines the rules and store the changed data use the common ,portable XML ,and takes advantage of TCP protocol and multi-threads and breakpoint transmission to make sure the quality of the file transmission . The encode method has been utilized to make sure the safety of the data .The experiment indicates that the data exchange engine this paper designed can complete the data exchange between the heterogeneous data-bases .