CN112328574A - Relay protection fault information master station data migration method and device - Google Patents
Relay protection fault information master station data migration method and device Download PDFInfo
- Publication number
- CN112328574A CN112328574A CN202011210368.2A CN202011210368A CN112328574A CN 112328574 A CN112328574 A CN 112328574A CN 202011210368 A CN202011210368 A CN 202011210368A CN 112328574 A CN112328574 A CN 112328574A
- Authority
- CN
- China
- Prior art keywords
- data
- relay protection
- fault information
- protection fault
- master station
- 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.)
- Pending
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/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
-
- 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/22—Indexing; Data structures therefor; Storage structures
-
- 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
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
-
- H—ELECTRICITY
- H02—GENERATION; CONVERSION OR DISTRIBUTION OF ELECTRIC POWER
- H02H—EMERGENCY PROTECTIVE CIRCUIT ARRANGEMENTS
- H02H1/00—Details of emergency protective circuit arrangements
- H02H1/0092—Details of emergency protective circuit arrangements concerning the data processing means, e.g. expert systems, neural networks
-
- H—ELECTRICITY
- H02—GENERATION; CONVERSION OR DISTRIBUTION OF ELECTRIC POWER
- H02H—EMERGENCY PROTECTIVE CIRCUIT ARRANGEMENTS
- H02H7/00—Emergency protective circuit arrangements specially adapted for specific types of electric machines or apparatus or for sectionalised protection of cable or line systems, and effecting automatic switching in the event of an undesired change from normal working conditions
- H02H7/26—Sectionalised protection of cable or line systems, e.g. for disconnecting a section on which a short-circuit, earth fault, or arc discharge has occured
Abstract
The invention relates to a method and a device for transferring relay protection fault information main station data. The transferred historical data and the data in the new system are unified in format, storage mode and processing flow. By implementing the method, the new master station system can realize the viewing and operation of historical data, and the purpose that the new information-protecting master station system completely replaces the old master station system is achieved.
Description
Technical Field
The invention relates to the field of relay protection of a power system, in particular to a relay protection fault information master station data migration method and device.
Background
With the continuous development of information technology and the gradual and deep application of a relay protection fault information master station (called a 'information protection master station' for short), users put higher requirements on the aspects of service function, system safety, stability, access capability and the like of a system, and each master station gradually upgrades the old information protection system and reconstructs the system from the aspects of system storage, system performance and the like. The relay protection fault information master station (namely a signal protection master station) is a monitoring decision system which is used for collecting and processing information of various power secondary devices, analyzing and processing power grid faults by utilizing the information, providing state maintenance decisions of a protection device, serving relay protection operation and management and serving relay protection operation management.
After the system is reconstructed and upgraded, due to the fact that technologies such as a data model, a database model selection technology, a message bus technology and the like are changed greatly, storage formats and storage modes of new and old system data are different, the old system data cannot be synchronized to a new information protection master station system, historical data of the information protection master station cannot be recovered, the historical data are lost, only protection information data after the new system is put into operation can be inquired on the system, and the historical data cannot be effectively utilized.
At present, in order to view and operate data in an old system, the same main station simultaneously operates the old information-guaranteeing main station system and the upgraded information-guaranteeing main station system, so that the situation that the same main station operates a plurality of sets of information-guaranteeing systems is caused, and the method has the following defects:
(1) the reconstructed information protection system cannot completely replace an old system, which causes troubles to the work of relay protection personnel, and the historical data cannot be effectively utilized.
(2) The two sets of systems operate simultaneously, and the old system does not access new operating data any more and only needs to be checked and used; the new system is responsible for accessing new operation data, and system users need to operate two sets of systems simultaneously, so that the workload of relay protection personnel is increased.
(3) Historical data cannot be effectively analyzed by a new system, and failure information cannot be analyzed in association with newly received operating data.
(4) The old system cannot be shut down, resulting in resource waste.
Disclosure of Invention
Based on the above situation in the prior art, an object of the present invention is to provide a data migration scheme for a relay protection fault information master station, which can automatically migrate data in an old system to a new system through a background program without configuration by engineering staff.
In order to achieve the above object, according to an aspect of the present invention, there is provided a relay protection fault information master station data migration method, including:
reading a data model in the new relay protection fault information main station;
synchronizing the data model in the new relay protection fault information master station to the old relay protection fault information master station and performing data model matching;
and after mapping the historical data in the old relay protection fault information master station, reversely generating source acquisition data, and sending the source acquisition data to a message bus of the new relay protection fault information master station so that the new relay protection fault information master station can distribute the source acquisition data to different databases for storage.
Further, the data migration method is triggered to execute in a timing task triggering mode.
Further, the data model matching comprises:
in the old relay protection fault information master station, a data table with the same structure as that of the data table in the new relay protection fault information master station is newly built;
newly building an information mapping table in an old relay protection fault information master station;
synchronizing the read data in the new relay protection fault information master station to the old relay protection fault information master station;
and storing the relationship between the data of the new relay protection fault information master station and the old relay protection fault information master station and the relationship between the master station and the old relay protection fault information master station to the information mapping table.
Further, the reversely generating the source acquisition data comprises reversely generating substation source data according to the historical data in the old relay protection fault information main station according to the data mapping relation between the new relay protection fault information main station and the old relay protection fault information main station.
Further, the new relay protection fault information master station distributes the source data to different databases for storage, including analyzing the source data, and distributing the source data to different databases for storage according to different service logics.
According to another aspect of the invention, the relay protection fault information master station data migration device comprises a data model reading module, a data model matching module, a historical data mapping module and a source acquisition data sending module; wherein the content of the first and second substances,
the data model reading module reads a data model in the new relay protection fault information main station;
the data model matching module synchronizes the data model in the new relay protection fault information master station to the old relay protection fault information master station and performs data model matching;
the historical data mapping module is used for reversely generating source acquisition data after mapping the historical data in the old relay protection fault information main station;
the source acquisition data sending module is used for sending the source acquisition data to a message bus of the new relay protection fault information main station so that the new relay protection fault information main station can distribute the source acquisition data to different databases for further storage, and the source acquisition data sending module further comprises a timing task triggering module which is used for triggering all modules to work in a timing mode.
Further, the data model matching module performs data model matching, including:
in the old relay protection fault information master station, a data table with the same structure as that of the data table in the new relay protection fault information master station is newly built;
newly building an information mapping table in an old relay protection fault information master station;
synchronizing the read data in the new relay protection fault information master station to the old relay protection fault information master station;
and storing the relationship between the data of the new relay protection fault information master station and the old relay protection fault information master station and the relationship between the master station and the old relay protection fault information master station to the information mapping table.
Furthermore, the historical data mapping module reversely generates source acquisition data, and the historical data in the old relay protection fault information main station is reversely generated into substation source data according to the day according to the data mapping relation between the old relay protection fault information main station and the new relay protection fault information main station.
Further, the new relay protection fault information master station distributes the source data to different databases for storage, including analyzing the source data, and distributing the source data to different databases for storage according to different service logics.
In summary, the present invention provides a method and an apparatus for migrating relay protection failure information master station data, the method utilizes the characteristic that although a communication-protecting master station system is modified, a slave station is not modified, and therefore, data sent by the slave station is received by a new system and an old system are consistent, historical data in the old system is reversely generated into slave station source data, and the source data is analyzed into data compatible with the new system after being sent to the new system. The transferred historical data and the data in the new system are unified in format, storage mode and processing flow. By implementing the method, the new master station system can realize the viewing and operation of historical data, and the purpose that the new information-protecting master station system completely replaces the old master station system is achieved.
Drawings
FIG. 1 is a schematic diagram of an implementation of a relay protection fault information master station data migration method according to the present invention;
FIG. 2 is a flow chart of a data migration method of a relay protection fault information main station according to the invention;
FIG. 3 is a flow chart of the timed task trigger mode of the present invention;
fig. 4 is a schematic diagram of the data migration device of the relay protection fault information main station.
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 an embodiment of the present invention, a relay protection fault information primary station data migration method is provided, fig. 1 shows an implementation schematic diagram of the data migration method, fig. 2 shows a flow chart of the data migration method, and with reference to fig. 1 and fig. 2, a data migration process is as follows:
1. and the data migration device is simultaneously connected with the database of the new and old information-guaranteeing master stations and reads the data model in the new information-guaranteeing master station system.
2. And the data migration device synchronizes the new data model to the old information-preserving master station system, and performs new and old data model matching, such as station name matching, equipment id matching, action, alarm, switching value configuration information matching and the like.
2.1, in the old system, a new station information table, a secondary equipment table, an alarm information definition table, an action information definition table, a switching value information definition table, a characteristic quantity definition table and an action information definition table, wherein the table structures of the new station information table, the secondary equipment table, the alarm information definition table, the action information definition table, the switching value information definition table and the characteristic quantity definition table are the same as the corresponding table structures in the new information protection main station.
2.2, in the old information-guaranteeing master station system, a new station building information mapping table and a secondary equipment information mapping table.
And 2.3, synchronizing the station data, the secondary equipment data, the alarm information, the action information, the switching value information and the like read in the step 1 to an old information-keeping master station system.
And 2.4, storing mapping information of the stations and the equipment in the old information-guaranteeing master station system into the station information mapping table and the secondary equipment information mapping table established in the step 2.2 according to the relation between the data of the new and old information-guaranteeing master stations and the data of the equipment.
3. And the data migration device maps the historical data in the old information-protecting master station system, reversely generates source acquisition data and sends the source acquisition data to the message bus of the new information-protecting master station system.
And 3.1, reversely generating the source data of the substation system by the data migration device according to the new and old data mapping relation and the historical data in the old information-preserving main station system by days. Because the data of the old and new information-guaranteeing main stations are all transmitted from the substation system, the workload is large if a mode of directly synchronizing the data of the old and new information-guaranteeing main stations is adopted, and the data in the information-guaranteeing main stations are distributed at all positions of the system. Therefore, the data of the old information-protecting main station reversely generate substation data (simulation data), the simulation data are sent to the new information-protecting main station, the new information-protecting main station processes the substation data according to the existing logic, historical data required by the main station are generated, and data migration of the new information-protecting main station and the old information-protecting main station is completed.
And 3.2, the data migration device sends the source data to a data acquisition message bus of the new information protection master station system.
4. And after receiving the source data, the system message bus of the new information protection master station analyzes the source data and distributes the source data to different databases for storage according to different service logics.
5. And finishing the data migration of the old and new information-guaranteeing main station systems.
Because historical data is more and the working time of data migration is longer, in order to reduce manual operation and reduce the workload of personnel, the data migration method adopts a timed task triggering mode and is triggered by timed task logic. A flow chart of this timed task triggering manner is shown in fig. 3.
To reduce the stress on the system from data migration, data migration work was performed every 1 am.
All dates contained in the history data are inquired, and migration is performed by taking the dates as units.
Circularly inquiring all dates, judging whether the current time is more than 4 points in the morning, and if the current time is less than 4 points in the morning, continuing to execute downwards; and if the current time is more than or equal to 4 am, ending the data migration task today.
Judging whether the date in the memory is larger than the alarm date in the acquired history record or not, and if so, continuing to execute downwards; otherwise, the loop is returned.
And generating raw data of the calendar history data, sending the raw data to a message bus, and updating the date in the memory.
According to another aspect of the invention, a data migration device of a relay protection fault information primary station is provided, and a schematic configuration diagram of the data migration device is shown in fig. 4. The device comprises a data model reading module, a data model matching module, a historical data mapping module and a source acquisition data sending module. And the data model reading module is used for reading the data model in the new relay protection fault information main station. And the data model matching module is used for synchronizing the data model in the new relay protection fault information master station to the old relay protection fault information master station and performing data model matching. And the historical data mapping module is used for reversely generating source acquisition data after mapping the historical data in the old relay protection fault information main station. And the source acquisition data sending module is used for sending the source acquisition data to a message bus of the new relay protection fault information master station so that the new relay protection fault information master station can distribute the source acquisition data to different databases for storage. According to some embodiments, the system further comprises a timing task triggering module which triggers the modules to work in a timing mode.
In summary, the invention relates to a data migration method and device for a relay protection fault information master station, wherein data migration work is automatically executed through a background program, data in an old security master station system is migrated to a new system, so that the situation that the new and old systems are operated on site is avoided, and the replacement of the old security master station system by a reconstructed system is completely realized through the scheme of the data migration system.
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. A relay protection fault information main station data migration method is characterized by comprising the following steps:
reading a data model in the new relay protection fault information main station;
synchronizing the data model in the new relay protection fault information master station to the old relay protection fault information master station and performing data model matching;
and after mapping the historical data in the old relay protection fault information master station, reversely generating source acquisition data, and sending the source acquisition data to a message bus of the new relay protection fault information master station so that the new relay protection fault information master station can distribute the source acquisition data to different databases for storage.
2. The method according to claim 1, wherein the data migration method is triggered to execute by adopting a timed task triggering mode.
3. The method of claim 2, wherein the data model matching comprises:
in the old relay protection fault information master station, a data table with the same structure as that of the data table in the new relay protection fault information master station is newly built;
newly building an information mapping table in an old relay protection fault information master station;
synchronizing the read data in the new relay protection fault information master station to the old relay protection fault information master station;
and storing the relationship between the data of the new relay protection fault information master station and the old relay protection fault information master station and the relationship between the master station and the old relay protection fault information master station to the information mapping table.
4. The method of claim 3, wherein reversely generating the source collected data comprises reversely generating substation source data by day from historical data in an old relay protection fault information main station according to a data mapping relation between the old and new relay protection fault information main stations.
5. The method of claim 4, wherein the new relay protection fault information master station distributes the source data to different databases for storage, including parsing the source data and distributing the source data to different databases for storage according to different business logic.
6. A data migration device of a relay protection fault information main station is characterized by comprising a data model reading module, a data model matching module, a historical data mapping module and a source acquisition data sending module; wherein the content of the first and second substances,
the data model reading module reads a data model in the new relay protection fault information main station;
the data model matching module synchronizes the data model in the new relay protection fault information master station to the old relay protection fault information master station and performs data model matching;
the historical data mapping module is used for reversely generating source acquisition data after mapping the historical data in the old relay protection fault information main station;
and the source acquisition data sending module is used for sending the source acquisition data to a message bus of the new relay protection fault information master station so that the new relay protection fault information master station can distribute the source acquisition data to different databases for storage.
7. The device of claim 6, further comprising a timed task triggering module, wherein each module is triggered to work in a timed mode.
8. The apparatus of claim 7, wherein the data model matching module performs data model matching, comprising:
in the old relay protection fault information master station, a data table with the same structure as that of the data table in the new relay protection fault information master station is newly built;
newly building an information mapping table in an old relay protection fault information master station;
synchronizing the read data in the new relay protection fault information master station to the old relay protection fault information master station;
and storing the relationship between the data of the new relay protection fault information master station and the old relay protection fault information master station and the relationship between the master station and the old relay protection fault information master station to the information mapping table.
9. The device of claim 8, wherein the historical data mapping module reversely generates source collected data, and comprises reversely generating substation source data by day from historical data in an old relay protection fault information main station according to a new relay protection fault information main station data mapping relation and old relay protection fault information main station data mapping relation.
10. The apparatus of claim 9, wherein the new relay protection fault information master station distributes the source data to different databases for storage, including parsing the source data and distributing the source data to different databases for storage according to different business logics.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011210368.2A CN112328574A (en) | 2020-11-03 | 2020-11-03 | Relay protection fault information master station data migration method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011210368.2A CN112328574A (en) | 2020-11-03 | 2020-11-03 | Relay protection fault information master station data migration method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112328574A true CN112328574A (en) | 2021-02-05 |
Family
ID=74323012
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011210368.2A Pending CN112328574A (en) | 2020-11-03 | 2020-11-03 | Relay protection fault information master station data migration method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112328574A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104504609A (en) * | 2014-12-05 | 2015-04-08 | 广东电网有限责任公司江门供电局 | Automatic maintenance method for parameters of master station and station end device in electrical power system |
| CN105868287A (en) * | 2016-03-23 | 2016-08-17 | 南京南瑞集团公司 | Multisource data-based WAMS application system data integration method |
| CN106709580A (en) * | 2017-01-13 | 2017-05-24 | 国家电网公司 | Substation secondary system operation and maintenance cloud platform |
| CN108614869A (en) * | 2018-04-17 | 2018-10-02 | 国家电网公司 | A kind of method of historical data in different automation system platform synchronous migrations |
| CN110347662A (en) * | 2019-07-12 | 2019-10-18 | 之江实验室 | A kind of multicenter medical data construction standard system based on generic data model |
-
2020
- 2020-11-03 CN CN202011210368.2A patent/CN112328574A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104504609A (en) * | 2014-12-05 | 2015-04-08 | 广东电网有限责任公司江门供电局 | Automatic maintenance method for parameters of master station and station end device in electrical power system |
| CN105868287A (en) * | 2016-03-23 | 2016-08-17 | 南京南瑞集团公司 | Multisource data-based WAMS application system data integration method |
| CN106709580A (en) * | 2017-01-13 | 2017-05-24 | 国家电网公司 | Substation secondary system operation and maintenance cloud platform |
| CN108614869A (en) * | 2018-04-17 | 2018-10-02 | 国家电网公司 | A kind of method of historical data in different automation system platform synchronous migrations |
| CN110347662A (en) * | 2019-07-12 | 2019-10-18 | 之江实验室 | A kind of multicenter medical data construction standard system based on generic data model |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106709580B (en) | Transformer substation secondary system operation and maintenance cloud platform | |
| CN103675600B (en) | Based on the Fault Diagnosis of Distribution Network system and method for topological knowledge | |
| CN108848132B (en) | Power distribution scheduling main station system based on cloud | |
| CN112698953A (en) | Power grid intelligent operation and detection platform based on micro-service | |
| CN112134357A (en) | Power distribution automation master station system based on cloud service | |
| CN104463696A (en) | Power grid operating risk recognition and prevention method and system | |
| CN104158286A (en) | Integrated main station system for regulation and control | |
| CN107910956A (en) | A kind of integrated power network schedule automation operation comprehensive supervision method of main plant stand | |
| CN111127250B (en) | Power data monitoring event analysis system and method | |
| CN104112183A (en) | Plug-and-play intelligent scheduling model management system and management method of intelligent substation | |
| CN112328574A (en) | Relay protection fault information master station data migration method and device | |
| CN111146868A (en) | Power communication machine room dynamic loop monitoring standardized access method and system | |
| Zheng et al. | Research and practice of intelligent operation and maintenance system for essential load guarantee based on 5G and IOT technology | |
| CN105761164A (en) | Hadoop-based electric power system accident recall method | |
| CN110675283B (en) | Power distribution equipment synchronous management system and method | |
| CN203101932U (en) | Power transformation equipment condition acquisition controller | |
| CN111090698B (en) | Alarm synchronization method and device for centralized monitoring of distribution network 1+ N system | |
| CN110008198B (en) | Database structure and dispatching automation system | |
| CN103679565A (en) | Intelligent community electricity consumption information collecting server system and data processing method | |
| Zhang et al. | Research on distribution network status management system based on cloud platform | |
| CN112085339A (en) | SOA (service oriented architecture) -based master and standby system real-time data checking device and method | |
| Zhang et al. | Open architecture design of universal terminal for multiple measurement and control scenarios of distribution network | |
| Sun et al. | Discussion on intelligent distribution automation system construction mode | |
| CN116737718B (en) | System capable of realizing interactive complement between water dispatching systems | |
| CN212905227U (en) | Recording fault finding device |
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 |