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.

Keywords

• new distribution system
• heterogeneous database
• combined coding
• stored procedure
• multi person cooperation
• trigger
• change table