发电技术2024，Vol.45Issue(2)：363-372,10.DOI:10.12096/j.2096-4528.pgt.21138
实用化数据同步技术在新型配电系统规划多人协同机制中的应用
Application of Practical Data Synchronization Technology in Multi Person Cooperation Mechanism of New Distribution System Planning
摘要
Abstract
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.关键词
新型配电系统/异构数据库/组合编码/存储过程/多人协同/触发器/变更表Key words
new distribution system/heterogeneous database/combined coding/stored procedure/multi person cooperation/trigger/change table分类
能源科技引用本文复制引用
郭镥,刘永礼,张媛,吴倩,李跃辉,侯晓宇,张雅静..实用化数据同步技术在新型配电系统规划多人协同机制中的应用[J].发电技术,2024,45(2):363-372,10.基金项目
国家自然科学基金项目(52237008). Project Supported by National Natural Science Foundation of China(52237008). （52237008）
