CN112380291A - Automatic synchronization method and device of fault information protection system - Google Patents
Automatic synchronization method and device of fault information protection system Download PDFInfo
- Publication number
- CN112380291A CN112380291A CN202011309326.4A CN202011309326A CN112380291A CN 112380291 A CN112380291 A CN 112380291A CN 202011309326 A CN202011309326 A CN 202011309326A CN 112380291 A CN112380291 A CN 112380291A
- Authority
- CN
- China
- Prior art keywords
- format data
- area
- protection system
- data
- configuration library
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/11—File system administration, e.g. details of archiving or snapshots
- G06F16/116—Details of conversion of file system types or formats
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Computing Systems (AREA)
- Synchronisation In Digital Transmission Systems (AREA)
- Hardware Redundancy (AREA)
Abstract
The invention relates to an automatic synchronization method and a device of a fault information protection system, which automatically and regularly convert configuration library information needing synchronization in a II area of the fault information protection system into preset format data under an appointed path, and the preset format data is inserted into a configuration library of a III area of the fault information protection system after data conversion so as to realize automatic synchronization of the data of the II area and the III area, overcome the difference between the databases, support the data transmission between different configuration libraries and improve the efficiency of data synchronization.
Description
Technical Field
The invention relates to the related technical field of power distribution system fault protection, in particular to an automatic synchronization method and device of a fault information protection system.
Background
The whole fault information protection system can be divided into a production control area and a management information area. Wherein, the production control large area is divided into an area I and an area II, and the safety level is highest. The area III is a large area of management information and has a lower security level than the area II. There is a forward isolation device between zone II and zone III, i.e. data can only be transferred from zone II to zone III and must be transferred through the forward isolation device.
In the power distribution process of the power station, the data of the configuration database in the area II needs to be updated to the area III in time. The configuration library data comprises information of primary equipment and secondary equipment of a plant station, and the configuration library can be forgotten and cannot be updated timely when the property of a consumer is consumed. Due to the existence of the forward isolation device from the area II to the area III, the required factory station configuration library data is synchronized to the area III by a manual copy method every day, and the following defects can exist:
1. the configuration database data needs to be copied manually, and cannot be updated automatically at regular time.
2. The databases used in zone II and zone III may be different and cannot simply export data directly into or out of the database.
Disclosure of Invention
Based on the above situation in the prior art, the present invention aims to provide a method for automatically and periodically synchronizing data in a region II configuration library to a region III configuration library, which can overcome the difference between databases, support data transmission between different configuration libraries (e.g. MySQL, Oracle, dreams),
to achieve the above object, according to one aspect of the present invention, there is provided an automatic synchronization method of a fault information protection system, comprising the steps of:
converting configuration library information needing to be synchronized in a fault information protection system II area into first format data under an appointed path at a preset time point;
converting the text file under the specified path into third format data after a preset time period passes at a preset time point;
and inserting the information in the third format data into a configuration library of a fault information protection system III area.
Further, the converting the configuration library information to be synchronized in the area II of the failure information protection system into the first format data under the specified path includes the steps of:
querying a configuration library needing to be synchronized in a fault information protection system II area to obtain third format data comprising configuration library information;
converting the third format data to obtain second format data;
and converting the second format data to obtain the first format data under the appointed path.
Further, the converting the text file under the specified path into the third format data includes the steps of:
converting the first format data under the appointed path into second format data;
and converting the second format data into third format data.
Further, the inserting the information in the third format data into the configuration library of the area III of the fault information protection system includes the steps of:
deleting original information corresponding to the pre-inserted information in a configuration library of the fault information protection system III area;
and inserting the information of the third format data into a configuration library of a fault information protection system III area.
Further, the first format data is byte stream format data, the second format data is JSON format data, and the third format data is list format data.
According to another aspect of the present invention, there is provided an automatic synchronization apparatus of a fault information protection system, including a zone II synchronous data conversion module, a zone III synchronous data conversion module, and a zone III synchronous data insertion module; wherein the content of the first and second substances,
the area II synchronous data conversion module converts configuration library information needing to be synchronized in an area II of the fault information protection system into first format data under an appointed path at a preset time point;
the III-area synchronous data conversion module converts the text file under the specified path into third-format data after a preset time period passes at a preset time point;
and the III-area synchronous data inserting module is used for inserting the information in the third format data into a configuration library of a III area of the fault information protection system.
Further, the step of converting the configuration library information to be synchronized in the area II of the fault information protection system into the first format data in the specified path by the area II synchronous data conversion module includes:
querying a configuration library needing to be synchronized in a fault information protection system II area to obtain third format data comprising configuration library information;
converting the third format data to obtain second format data;
and converting the second format data to obtain the first format data under the appointed path.
Further, the step of converting the text file in the specified path into the data in the third format by the zone III synchronous data conversion module includes:
converting the first format data under the appointed path into second format data;
and converting the second format data into third format data.
Further, the inserting module of the III-zone synchronous data inserts the information in the third format data into the configuration library of the III-zone of the fault information protection system, and includes:
deleting original information corresponding to the pre-inserted information in a configuration library of the fault information protection system III area;
and inserting the information of the third format data into a configuration library of a fault information protection system III area.
Further, the first format data is byte stream format data, the second format data is JSON format data, and the third format data is list format data.
In summary, the present invention provides an automatic synchronization method and apparatus for a fault information protection system, which automatically and periodically converts configuration library information to be synchronized in a zone II of the fault information protection system into preset format data in an assigned path, and the preset format data is inserted into a configuration library in a zone III of the fault information protection system after data conversion, so as to achieve automatic synchronization of data in the zone II and the zone III, overcome differences between databases, support data transmission between different configuration libraries, and improve data synchronization efficiency.
Drawings
FIG. 1 is a schematic diagram of the automatic synchronization method of the fault information protection system of the present invention;
FIG. 2 is a flow chart of an automatic synchronization method of the fault information protection system of the present invention;
fig. 3 is a block diagram of the automatic synchronization device of the fault information protection system of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be described in further detail with reference to the accompanying drawings in conjunction with the following detailed description. It should be understood that the description is intended to be exemplary only, and is not intended to limit the scope of the present invention. Moreover, in the following description, descriptions of well-known structures and techniques are omitted so as to not unnecessarily obscure the concepts of the present invention.
The technical solution of the present invention will be described in detail below with reference to the accompanying drawings. According to one embodiment of the invention, an automatic synchronization method of a fault information protection system is provided, and a schematic diagram of the method is shown in fig. 1. In order to realize the automatic synchronization function from the area II to the area III of different databases, timing programs are respectively arranged in the area II and the area III, the timing programs are set by using @ Scheduled notes in a Spring framework, and the time and the interval for executing the programs can be set by modifying cron expressions. The timer program of the area II is configured to be executed at a preset time point, for example, the timer program may be executed once every night, and the information of the configuration library that the area II needs to be synchronized is converted into a TXT file under a specified path. The timing program of the area III is set after the preset time period of the timing program of the area II, for example, after one hour, the TXT file in the specified path is converted into the information corresponding to the area III configuration library, so as to insert the information into the area III configuration library.
The flow chart of the synchronization method is shown in fig. 2, and specifically, the timing program execution of the zone II can be divided into three phases: the first stage, using Mybatis frame to inquire the configuration library needing synchronizing in the II area, and the operation can obtain a List containing configuration library information; the second stage, using JSON. toJSONString () method (the method is used to convert the object into Json character string), converting the list format data into JSON format convenient for data exchange; and in the third stage, the JSON data is output into a byte stream by using an output putStreamWriter (the method is used for converting the character stream into the byte stream) byte output stream, so that the aim of converting the configuration library information into a TXT file under the specified path is fulfilled. The zone III procedure is divided into three phases: in the first stage, the character output stream of the InputStreamReader (the method is used for converting from a byte stream to a character stream) is used for reading the TXT file with the configuration library information as the character stream and storing the TXT file as a String type in the Java language. And in the second stage, reading the String type data into list types by using a JSON. And in the third stage, deleting the original information of the plant station to be inserted by using a Mybatis frame to delete the III area configuration library, and then inserting the information in the list into the III area configuration library.
In the synchronization method provided by the embodiment, the timing synchronization of the configuration library can be realized by setting the timing program. Data transmission is transmitted through a JSON format irrelevant to database languages, inquired and inserted database sentences are packaged by a Mybatis framework, and areas II and III are independently called, so that interaction among different database languages can be realized. Optionally, the III area may select all the stations or an individual station to update the data.
According to another embodiment of the present invention, there is provided an automatic synchronization apparatus of a fault information protection system, the apparatus having a block diagram as shown in fig. 3, including: the device comprises a region II synchronous data conversion module, a region III synchronous data conversion module and a region III synchronous data insertion module.
And the area II synchronous data conversion module converts the configuration library information needing to be synchronized in the area II of the fault information protection system into the first format data under the specified path at a preset time point. This can be achieved by carrying out the following steps: querying a configuration library needing to be synchronized in a fault information protection system II area to obtain third format data comprising configuration library information; converting the third format data to obtain second format data; and converting the second format data to obtain the first format data under the appointed path.
And the III-area synchronous data conversion module converts the text file under the specified path into third-format data after a preset time period passes at a preset time point. This can be achieved by carrying out the following steps: converting the first format data under the appointed path into second format data; and converting the second format data into third format data.
And the III-area synchronous data inserting module is used for inserting the information in the third format data into a configuration library of a III area of the fault information protection system. This can be achieved by carrying out the following steps: deleting original information corresponding to the pre-inserted information in a configuration library of the fault information protection system III area; and inserting the information of the third format data into a configuration library of a fault information protection system III area.
In the data formats related to the modules, the first format data may be byte stream format data, the second format data may be JSON format data, and the third format data may be list format data.
In summary, the present invention relates to an automatic synchronization method and apparatus for a fault information protection system, which automatically and periodically converts configuration library information to be synchronized in a zone II of the fault information protection system into preset format data in an assigned path, and the preset format data is inserted into a configuration library in a zone III of the fault information protection system after data conversion, so as to achieve automatic synchronization of data in the zone II and the zone III, overcome differences between databases, support data transmission between different configuration libraries, and improve data synchronization efficiency.
It is to be understood that the above-described embodiments of the present invention are merely illustrative of or explaining the principles of the invention and are not to be construed as limiting the invention. Therefore, any modification, equivalent replacement, improvement and the like made without departing from the spirit and scope of the present invention should be included in the protection scope of the present invention. Further, it is intended that the appended claims cover all such variations and modifications as fall within the scope and boundaries of the appended claims or the equivalents of such scope and boundaries.
Claims (10)
1. An automatic synchronization method of a fault information protection system is characterized by comprising the following steps:
converting configuration library information needing to be synchronized in a fault information protection system II area into first format data under an appointed path at a preset time point;
converting the text file under the specified path into third format data after a preset time period passes at a preset time point;
and inserting the information in the third format data into a configuration library of a fault information protection system III area.
2. The synchronization method according to claim 1, wherein the step of converting the configuration library information to be synchronized in the area II of the failure information protection system into the first format data under the specified path comprises the steps of:
querying a configuration library needing to be synchronized in a fault information protection system II area to obtain third format data comprising configuration library information;
converting the third format data to obtain second format data;
and converting the second format data to obtain the first format data under the appointed path.
3. The synchronization method according to claim 2, wherein the step of converting the text file under the specified path into the third format data comprises the steps of:
converting the first format data under the appointed path into second format data;
and converting the second format data into third format data.
4. The synchronization method according to claim 3, wherein the inserting the information in the third format data into the configuration library of the zone III of the fault information protection system comprises the steps of:
deleting original information corresponding to the pre-inserted information in a configuration library of the fault information protection system III area;
and inserting the information of the third format data into a configuration library of a fault information protection system III area.
5. The synchronization method according to claim 4, wherein the first format data is byte stream format data, the second format data is JSON format data, and the third format data is list format data.
6. An automatic synchronization device of a fault information protection system is characterized by comprising a zone II synchronous data conversion module, a zone III synchronous data conversion module and a zone III synchronous data insertion module; wherein the content of the first and second substances,
the area II synchronous data conversion module converts configuration library information needing to be synchronized in an area II of the fault information protection system into first format data under an appointed path at a preset time point;
the III-area synchronous data conversion module converts the text file under the specified path into third-format data after a preset time period passes at a preset time point;
and the III-area synchronous data inserting module is used for inserting the information in the third format data into a configuration library of a III area of the fault information protection system.
7. The synchronization apparatus according to claim 6, wherein the area II synchronization data conversion module converts the configuration library information that needs to be synchronized in the area II of the failure information protection system into the first format data under the specified path, and includes:
querying a configuration library needing to be synchronized in a fault information protection system II area to obtain third format data comprising configuration library information;
converting the third format data to obtain second format data;
and converting the second format data to obtain the first format data under the appointed path.
8. The synchronization apparatus according to claim 7, wherein the region III synchronization data conversion module converts the text file in the specified path into data in a third format, and comprises:
converting the first format data under the appointed path into second format data;
and converting the second format data into third format data.
9. The synchronization apparatus according to claim 8, wherein the zone III synchronization data insertion module inserts the information in the third format data into a configuration library of a zone III of the fault information protection system, and includes:
deleting original information corresponding to the pre-inserted information in a configuration library of the fault information protection system III area;
and inserting the information of the third format data into a configuration library of a fault information protection system III area.
10. The synchronization apparatus according to claim 9, wherein the first format data is byte stream format data, the second format data is JSON format data, and the third format data is list format data.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202011309326.4A CN112380291B (en) | 2020-11-20 | 2020-11-20 | Automatic synchronization method and device of fault information protection system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202011309326.4A CN112380291B (en) | 2020-11-20 | 2020-11-20 | Automatic synchronization method and device of fault information protection system |
Publications (2)
Publication Number | Publication Date |
---|---|
CN112380291A true CN112380291A (en) | 2021-02-19 |
CN112380291B CN112380291B (en) | 2022-10-21 |
Family
ID=74585334
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202011309326.4A Active CN112380291B (en) | 2020-11-20 | 2020-11-20 | Automatic synchronization method and device of fault information protection system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN112380291B (en) |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN203233238U (en) * | 2013-04-27 | 2013-10-09 | 四川省电力公司广元电业局 | Intelligent type fault recording online management system |
CN204557577U (en) * | 2015-04-23 | 2015-08-12 | 国家电网公司 | A kind of power distribution network infosystem based on IEC61968 and ESB |
CN105117654A (en) * | 2015-07-24 | 2015-12-02 | 中国电力科学研究院 | Data synchronization method between same systems under the circumstance of network physical isolation |
CN105554114A (en) * | 2015-12-17 | 2016-05-04 | 深圳市从晶科技有限公司 | Data synchronization method and data synchronization firmware platform |
CN111008712A (en) * | 2019-11-13 | 2020-04-14 | 广西电网有限责任公司 | Interface implementation method for realizing acquisition of confidence data in power grid fault diagnosis |
-
2020
- 2020-11-20 CN CN202011309326.4A patent/CN112380291B/en active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN203233238U (en) * | 2013-04-27 | 2013-10-09 | 四川省电力公司广元电业局 | Intelligent type fault recording online management system |
CN204557577U (en) * | 2015-04-23 | 2015-08-12 | 国家电网公司 | A kind of power distribution network infosystem based on IEC61968 and ESB |
CN105117654A (en) * | 2015-07-24 | 2015-12-02 | 中国电力科学研究院 | Data synchronization method between same systems under the circumstance of network physical isolation |
CN105554114A (en) * | 2015-12-17 | 2016-05-04 | 深圳市从晶科技有限公司 | Data synchronization method and data synchronization firmware platform |
CN111008712A (en) * | 2019-11-13 | 2020-04-14 | 广西电网有限责任公司 | Interface implementation method for realizing acquisition of confidence data in power grid fault diagnosis |
Non-Patent Citations (2)
Title |
---|
王晓莉: ""电力通信网网管数据采集框架的设计与实现"", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
陈健健: ""海南电网故障综合分析平台的设计与实现"", 《中国优秀硕士学位论文全文数据库 工程科技Ⅱ辑》 * |
Also Published As
Publication number | Publication date |
---|---|
CN112380291B (en) | 2022-10-21 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102867274B (en) | Management and graphical display system for intelligent substation SCL (substation configuration description language) configuration files | |
KR102613089B1 (en) | Internet of Things data transmission method and system | |
CN101595667B (en) | Method, device and system for facilitating synchronization of servers in coordinated timing network | |
CN202694021U (en) | Substation time synchronizing system | |
CN100371851C (en) | Time synchronizing method and device | |
CN108229799B (en) | Multi-source heterogeneous power grid operation real-time data access system and method | |
CN105262220B (en) | Substation's intelligence shutdown telecontrol information check method and system | |
CN103093334A (en) | Method of activity notice text recognition and transforming automatically into calendar term | |
CN103353871A (en) | Interoperation picture file checking method based on CIM/G standard | |
CN104269934B (en) | Based on the supervisory control of substation information adjustment method of moving analog scheduling station | |
CN109992571A (en) | A kind of intelligent substation configuration file line closed loop check system and method for calibration | |
CN103903075A (en) | Protection device constant value automatic management method based on fuzzy matching | |
CN112380291B (en) | Automatic synchronization method and device of fault information protection system | |
CN109495290A (en) | A kind of operational system boss stands exchange method and system | |
CN102185381B (en) | Method for processing SCD (substation configuration description) iteration of SCD model during automatic switching | |
CN103700024A (en) | Automatic importing method of provincial and prefectural integrated telecontrol information based on D5000 system | |
CN112565231B (en) | Safety II area and III area data synchronization method and device based on power dispatching data network | |
CN104112183B (en) | The intelligent scheduling model management system and management method of intelligent substation plug and play | |
CN106339511A (en) | Automatic synchronization system of power dispatching automation system and method thereof | |
CN110659323A (en) | Real-time and off-line big data processing system, method, storage medium and terminal | |
CN103379155A (en) | Method and system for distributing contents and content management system | |
CN111950978B (en) | Incremental updating system and method from scheduling master station electrorheological model to informatization system | |
CN110531724B (en) | Remote measurement automatic sampling definition method based on smart power grid dispatching control system | |
CN113837586A (en) | Virtual-real synchronous operation method and device of digital twin transformer substation | |
CN111626444A (en) | Model maintenance dynamic self-adaption method, device and system based on regulation cloud and storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |