实用化数据同步技术在新型配电系统规划多人协同机制中的应用  

Application of Practical Data Synchronization Technology in Multi Person Cooperation Mechanism of New Distribution System Planning

作　　者：郭镥 刘永礼 张媛 吴倩 李跃辉 侯晓宇 张雅静 GUO Lu;LIU Yongli;ZHANG Yuan;WU Qian;LI Yuehui;HOU Xiaoyu;ZHANG Yajing(Shenzhen Power Supply Bureau Co.,Ltd.,Shenzhen 518028,Guangdong Province,China;Beijing T&D Science and Technology Corporation,Changping District,Beijing 102206,China;School of Automation,Beijing Information Science and Technology University,Haidian District,Beijing 100192,China)

机构地区：[1]深圳供电局有限公司,广东省深圳市518028 [2]天地电研(北京)科技有限公司,北京市昌平区102206 [3]北京信息科技大学自动化学院,北京市海淀区100192

出　　处：《发电技术》2024年第2期363-372,共10页Power Generation Technology

基　　金：国家自然科学基金项目(52237008)。

摘　　要：随着能源互联网时代的到来,将各能源部门内部或部门之间使用的不同数据库整合成统一的数据平台,既适应能源互联网发展趋势,又能为新型配电系统网格化规划多人协同机制的实现奠定基础。异构数据库的同步,关键在于源端数据变更的捕获、目的端数据操作的辨识以及目的端数据的同步。在源端变更数据捕获方面,通过创建临时表获取源端的变更数据,大大减少了传输数据量。在数据操作辨识方面,采用源端利用组合编码统一标识更新数据、目的端自行解析的方式,避免了解读的混乱。为省去大量同类语句的解析时间,在目的端事先制定好各类数据操作的存储过程,以实现同步数据的便捷写入。将该实用化数据同步技术应用在株洲市新型配电系统能源互联网规划多人协同机制中,成功提高了效率,证明了方法的有效性和可行性。实用化数据同步技术既能将源端的变更数据以系统开销最小的方式准确抓取出来,又能使目的端的数据写入更加快捷。With the development of energy internet,it is necessary to lay the foundation for the integration of data between different energy departments,which can also adapt to the development trend of the internet.The key to the synchronization of heterogeneous databases lies in the capture of data changes at the source,the identification of data operations at the destination,and the synchronization of data at the destination.In the aspect of source side change data capture,the amount of transmitted data was greatly reduced by the source side change data based on the creation of temporary table.In terms of data operation identification,the source side used combined coding to uniformly identify and update data,and the destination side analyzed it by itself,so as to avoid the confusion of interpretation.In order to save the parsing time of a large number of similar statements,the storage procedures of various data operations were formulated in advance at the destination to realize the convenient writing of synchronous data.The practical data synchronization technology was applied to the multi person cooperation mechanism of energy internet planning of Zhuzhou new distribution system,which successfully improves the efficiency,effectiveness and feasibility of the method.The proposed technology of practical data synchronization can not only accurately capture the changed data at the source with the least system overhead,but also make the data at the destination write more quickly.

关 键 词：新型配电系统 异构数据库 组合编码 存储过程 多人协同 触发器 变更表 

分 类 号：TK01[动力工程及工程热物理] TP31[自动化与计算机技术—计算机软件与理论]