疑难电子数据修复方案库数据同步方法比较  

Comparison of data synchronization methods in difficult electronic data restoration solution database

作　　者：高梓铭 韦同胜 王鲲 赵文涛[3] GAO Ziming;WEI Tongsheng;WANG Kun;ZHAO Wentao(School of Communication and Information Engineering,Xi＇an University of Posts and Telecommunications,Xi＇an 710121,China;Key Laboratory of Electronic Information Application Technology for Scene Investigation Ministry of Public Security,Xi＇an 710121,Shaanxi;Science and Technology Information Office,Public Security Department,Xi＇an 710018,Shaanxi)

机构地区：[1]西安邮电大学通信与信息工程学院,陕西西安710121 [2]电子信息现场勘验应用技术公安部重点实验室,陕西西安710121 [3]陕西省公安厅科技信息化处,陕西西安710018

出　　处：《西安邮电大学学报》2018年第4期99-104,共6页Journal of Xi’an University of Posts and Telecommunications

基　　金：国家重点研发计划重点专项资助(2017YFC0803805)

摘　　要：根据业务数据主要特征,给出疑难电子数据修复方案库同步技术要求。分别将SQL SERVER数据库发布/订阅机制和PowerBuilder开发工具数据管道对照修复方案库同步技术要求进行比较,最终借鉴SQL SERVER发布/订阅思路,结合PowerBuilder开发工具数据管道优势,设计基于PowerBuilder开发的同步系统。对照修复方案库同步技术要求梳理得出,该系统可对所有源及目标数据库相关标识列、触发器,甚至数据库其他对象实现同步。According to the main characteristics of business data, the technical requirements for the synchronization of difficult electronic data restoration solution database are presented. The technical requirements for the synchronization of the restoration solution database between SQL SERVER database publication and subscription mechanism with the data pipeline of PowerBuilder development tool are respectively compared. A synchronization system based on PowerBuilder is designed after borrowing the ideas of SQL SERVER publication and subscription, and combining with the data pipeline advantage of PowerBuilder development tool. As per the technical requirements for the synchronization of the restoration solution database, this system can synchronize all sources, target database related identity columns, triggers and even synchronize other objects in the database.

关 键 词：数据管道 数据窗口 同步复制 

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