CN103237065A - Automatic synchronization method of multistate data in integrated substation monitoring system - Google Patents
Automatic synchronization method of multistate data in integrated substation monitoring system Download PDFInfo
- Publication number
- CN103237065A CN103237065A CN2013101283287A CN201310128328A CN103237065A CN 103237065 A CN103237065 A CN 103237065A CN 2013101283287 A CN2013101283287 A CN 2013101283287A CN 201310128328 A CN201310128328 A CN 201310128328A CN 103237065 A CN103237065 A CN 103237065A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- file
- synchronous
- monitoring system
- 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
Abstract
The invention relates to an automatic synchronization method of multistate data in an integrated substation monitoring system. The method is technically characterized by including: firstly, allowing for source data file synchronization among multiple computer nodes by means of creating a file server; secondly, allowing a model database to automatically sync to an operational database through a data incremental mechanism; and thirdly, syncing the operational database to the model database by means of table change record real-time loading. The method is reasonable in design, data are kept constantly consistent in the source data files, the operational database and the model database among the computer nodes of the dual-mode integrated system, field engineering efficiency is greatly increased for intelligent substation automation engineering, and maintenance operations are simpler.
Description
Technical field
The present invention is applied to the intelligent substation technical field of automation, particularly the automatic synchronous method of the polymorphic data in the integrated monitoring system of a kind of transformer station.
Background technology
Along with promoting the use of of projects such as State Grid Corporation of China " integrated monitoring system of transformer station ", " long-range having access to ", station level in transformer station, need set up a transformer station's integral system platform with multiple integration capability, be used for various automated systems in the unified transformer station, this system has multinomial functions such as monitoring, telemechanical, prudential sub-station, gateway simultaneously.The thing followed is, the data of intelligent substation are also increasingly sophisticated, realized on the one hand that based on the data of model the standardization of data uses, and guaranteed the flexible association of multi-specialized data; On the other hand, the relevance of data, complexity also improve greatly.Originally in runtime database, carry out online editing the stability of system has been caused considerable influence, therefore, for using intelligent transformer station development trend, new integral system has proposed the double mode system that system configuration pattern, system running pattern combine on structure system.Under the double mode system, the system configuration pattern stresses data maintenance in enormous quantities and the check of model data, and system running pattern stresses supervision and the simple-to-maintain of service data.Increment mechanism by the centre realizes that configuration is to the online updating of operation, the source data unification is stored in text type or the binary file, while is as the data source of system configuration pattern and system running pattern, under this structure system, for improving the stable operation after the integrated monitoring system drops into and more reaching the standard grade after the verification of new data, good basis is provided, but when reality is used, has also had certain problem.
Under the existing systems configuration mode, realize the editor of transformer station's end data.The delta data that produces in editing process can not be reflected in the runtime database in real time, must delta data be updated in the based on network real time execution storehouse by the artificial mode of submitting to, and realize the synchronously real-time of total system data.Double mode architectural framework had both guaranteed the reliability service of system, also guaranteed between the model database, runtime database of integrated monitoring system by the delta data increment mode implementation model database-one-way synchronization of runtime database.Safeguard in reality, in the debug process, model database, runtime database can occur safeguarding respectively and cause the inconsistent situation of data, and also can't guarantee data consistent between the source data file, the phenomenon that legacy data covers new data happens occasionally.Trace it to its cause, source data file is distributed on each computer node, does not carry out unified management, and model database, runtime database can't realize that reasons such as bi-directional synchronization cause.
The data tissue part of integral automation system is made of model database, runtime database, model file three parts.Though existing system realized from model database-runtime database synchronously, but, consider less for runtime database synchronistic model database, therefore, in the exploitation and implementation process of transformer station, can often carry out the modification of service data, editing data, cause the asynchronous of service data, editing data easily.
Summary of the invention
The objective of the invention is to remedy the technical deficiency of existing product, the automatic synchronous method of the polymorphic data in the integrated monitoring system of a kind of transformer station is provided, and it solves the data consistency problem between the model database and runtime database in system maintenance/implementation process synchronously by bi-directional data.
The objective of the invention is to realize by following technological means:
The automatic synchronous method of the polymorphic data in the integrated monitoring system of a kind of transformer station may further comprise the steps:
⑴ it is synchronous to carry out source data file by the mode of setting up file server between the multicomputer node;
⑵ model database is synchronized to runtime database automatically by data increment mechanism;
⑶ runtime database is synchronized to model database by the real-time load mode of table change records.
And the method for synchronous of described step ⑴ may further comprise the steps:
⑴ when system started, the computer node local machine node of Qi Donging was set to the file server of integrated monitoring system at first, and source data file is loaded in the runtime database;
⑵ after other computer nodes start, at first from file server loading source data file to local computer nodes, obtain the data of runtime database then from network, carry out the runtime database mirror image between a plurality of computer nodes, thereby realize the synchronizing function of internal storage data, source data file.
And, the method for synchronous of described step ⑵ is: trigger incremental update mechanism when model database is saved in source data file automatically, the verification of implementation model database, the data increment of runtime database loads from model database to this computer node, automatically be synchronized to other computer nodes of network, the delta data that other computer nodes are obtained is saved in other computer nodes and file server at last.
And the method for synchronous of described step ⑵ uses the thread and automatically perform on the backstage of working alone.
And, the method for synchronous of described step ⑶ is: the method by real-time inspection change records file is synchronized in the runtime database of other computer nodes immediately, and be synchronized in the source data file of each computer node, thereby the online editing data are synchronized in the runtime database in time.
Advantage of the present invention and good effect are:
The present invention has realized model database by the bi-directional data method for synchronous, runtime database, the function that source data file omnidirectional is synchronous, guaranteed the source data file between each computer node in the double mode integrated supervisory control system down, runtime database, data between the model database remain unanimity, solved the data consistency problem between the model database and runtime database in system maintenance/implementation process, and at the data sync of multicomputer node, the mode unification that combines with file server by version management manages project data.The present invention is improved a lot for the field engineering efficient of intelligent substation automation engineering, has simplified attended operation simultaneously.
Description of drawings
Fig. 1 is based on the schematic diagram of the source data file method for synchronous between the multicomputer node of file server;
Fig. 2 is model database is synchronized to the runtime database method automatically by data increment mechanism schematic diagram;
Fig. 3 is runtime database is synchronized to model database by the real-time load mode of table change records method schematic diagram.
Embodiment
The automatic synchronous method of the polymorphic data in the integrated monitoring system of a kind of transformer station may further comprise the steps:
1, it is synchronous to carry out source data file by the mode of setting up file server between the multicomputer node.
As shown in Figure 1, the source data of integrated monitoring system is stored with file mode, and for the source data file that guarantees each computer node remains unanimity, the integrated monitoring system need arrange unique file server.Concrete method for synchronous may further comprise the steps:
When (1) system started, the computer node local machine node of Qi Donging was set to the file server of integrated monitoring system at first, and source data file is loaded in the runtime database;
(2) after other computer nodes start, at first from file server loading source data file to local computer nodes, obtain the data of runtime database then from network, carry out the runtime database mirror image between a plurality of computer nodes, thereby realize the synchronizing function of internal storage data, source data file.
2, model database is synchronized to runtime database automatically by data increment mechanism.
Because the existing systems design is under model configuration environment, realize the renewal of incremental data from the model database to the runtime database by manual triggering mode, its maintenance efficiency is low, difficulty is big, in order to improve system maintenance efficient, to reduce the dimension difficulty, the automatically synchronous this method of incremental data is to realize synchronously automatically by data increment mechanism under the configuration mode.As shown in Figure 2, model database by the method that data increment mechanism is synchronized to runtime database automatically is: trigger incremental update mechanism when model database is saved in source data file automatically, the verification of implementation model database, the data increment of runtime database loads from model database to this computer node, automatically be synchronized to other computer nodes of network, the delta data that other computer nodes are obtained is saved in other computer nodes and file server at last.Said process is to automatically perform by worker thread independently and on the backstage.
3, runtime database is synchronized to model database by the real-time load mode of table change records.
The integrated monitoring system edits under operational mode and preserves operation, and amended service data database data need be updated in other databases synchronously.After carrying out the online editing preservation, to cause heavily loaded change list under the system configuration environment, therefore, this method is synchronized in the runtime database of other computer nodes immediately by the method for real-time inspection change records file, and be synchronized in the source data file of each computer node, thereby the online editing data are synchronized in the runtime database in time, guarantee that the data under three kinds of states are consistent, as shown in Figure 3.
The present invention is by the comprehensive use of above three kinds of method for synchronous, realized in configuration mode, the operational mode while running, runtime database in the same computer node and the data of model database remain synchronously, and be synchronized in real time in the model database, runtime database of other computer nodes, solved the issuable double mode inconsistent situation of data down in the maintenance process.By the use of file server, also solved based on the automated system multi-user of file type and the problem of edlin.
It is emphasized that; embodiment of the present invention is illustrative; rather than it is determinate; therefore the present invention is not limited to the embodiment described in the embodiment; every other execution modes that drawn by those skilled in the art's technical scheme according to the present invention belong to the scope of protection of the invention equally.
Claims (5)
1. the automatic synchronous method of the polymorphic data in the integrated monitoring system of transformer station is characterized in that: may further comprise the steps:
⑴ it is synchronous to carry out source data file by the mode of setting up file server between the multicomputer node;
⑵ model database is synchronized to runtime database automatically by data increment mechanism;
⑶ runtime database is synchronized to model database by the real-time load mode of table change records.
2. the automatic synchronous method of the polymorphic data in the integrated monitoring system of transformer station according to claim 1, it is characterized in that: the method for synchronous of described step ⑴ may further comprise the steps:
⑴ when system started, the computer node local machine node of Qi Donging was set to the file server of integrated monitoring system at first, and source data file is loaded in the runtime database;
⑵ after other computer nodes start, at first from file server loading source data file to local computer nodes, obtain the data of runtime database then from network, carry out the runtime database mirror image between a plurality of computer nodes, thereby realize the synchronizing function of internal storage data, source data file.
3. the automatic synchronous method of the polymorphic data in the integrated monitoring system of transformer station according to claim 1, it is characterized in that: the method for synchronous of described step ⑵ is: trigger incremental update mechanism when model database is saved in source data file automatically, the verification of implementation model database, the data increment of runtime database loads from model database to this computer node, automatically be synchronized to other computer nodes of network, the delta data that other computer nodes are obtained is saved in other computer nodes and file server at last.
4. according to the automatic synchronous method of the polymorphic data in claim 1 or the 3 integrated monitoring systems of described transformer station, it is characterized in that: the method for synchronous of described step ⑵ uses the thread and automatically perform on the backstage of working alone.
5. the automatic synchronous method of the polymorphic data in the integrated monitoring system of transformer station according to claim 1, it is characterized in that: the method for synchronous of described step ⑶ is: the method by real-time inspection change records file is synchronized in the runtime database of other computer nodes immediately, and be synchronized in the source data file of each computer node, thereby the online editing data are synchronized in the runtime database in time.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310128328.7A CN103237065B (en) | 2013-04-15 | 2013-04-15 | The automatic synchronous method of the Multi-state data in transformer station's integrated monitoring system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310128328.7A CN103237065B (en) | 2013-04-15 | 2013-04-15 | The automatic synchronous method of the Multi-state data in transformer station's integrated monitoring system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103237065A true CN103237065A (en) | 2013-08-07 |
| CN103237065B CN103237065B (en) | 2016-03-02 |
Family
ID=48885081
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310128328.7A Active CN103237065B (en) | 2013-04-15 | 2013-04-15 | The automatic synchronous method of the Multi-state data in transformer station's integrated monitoring system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103237065B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2021057459A1 (en) * | 2019-09-29 | 2021-04-01 | 国网福建省电力有限公司 | Synchronization system and method for monitoring background database, scd and rcd |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020083182A1 (en) * | 2000-12-18 | 2002-06-27 | Alvarado Juan C. | Real-time streamed data download system and method |
| CN1489052A (en) * | 2002-10-11 | 2004-04-14 | 鸿富锦精密工业（深圳）有限公司 | Multi-node file syn chronizing system and method |
| CN101127915A (en) * | 2007-09-20 | 2008-02-20 | 中兴通讯股份有限公司 | Electronic program navigation data synchronization method and system based on incremental mode |
| CN102045400A (en) * | 2010-12-29 | 2011-05-04 | 北京世纪互联工程技术服务有限公司 | Method and system for synchronizing file content |
-
2013
- 2013-04-15 CN CN201310128328.7A patent/CN103237065B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020083182A1 (en) * | 2000-12-18 | 2002-06-27 | Alvarado Juan C. | Real-time streamed data download system and method |
| CN1489052A (en) * | 2002-10-11 | 2004-04-14 | 鸿富锦精密工业（深圳）有限公司 | Multi-node file syn chronizing system and method |
| CN101127915A (en) * | 2007-09-20 | 2008-02-20 | 中兴通讯股份有限公司 | Electronic program navigation data synchronization method and system based on incremental mode |
| CN102045400A (en) * | 2010-12-29 | 2011-05-04 | 北京世纪互联工程技术服务有限公司 | Method and system for synchronizing file content |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2021057459A1 (en) * | 2019-09-29 | 2021-04-01 | 国网福建省电力有限公司 | Synchronization system and method for monitoring background database, scd and rcd |
| US11630847B2 (en) | 2019-09-29 | 2023-04-18 | State Grid Fujian Electric Power Co., Ltd. | Synchronization system and method for substation monitoring backend database, SCD, and RCD |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103237065B (en) | 2016-03-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104317843A (en) | Data synchronism ETL (Extract Transform Load) system | |
| CN104598376A (en) | Data driving layered automation test system and method | |
| CN104573056A (en) | Database large data volume online migration method based on oracle | |
| CN103221891A (en) | Intelligent interface for a distributed control system | |
| CN108009258A (en) | It is a kind of can Configuration Online data collection and analysis platform | |
| US10019467B2 (en) | Method, system and computer readable medium for managing design updates in a manufacturing execution system | |
| CN105260810A (en) | Method for constructing distribution network standby scheduling and controlling system based on major network scheduling system | |
| KR20140115108A (en) | Screen generation method of energy management system | |
| CN106951593B (en) | Method and device for generating configuration file of protection measurement and control device | |
| CN104468586B (en) | Based on the photovoltaic plant remotely intelligently monitoring means of communication of MODBUS agreement | |
| CN115660620A (en) | Personnel DB library management method and device based on RPA and storage medium | |
| CN102185381B (en) | Method for processing SCD (substation configuration description) iteration of SCD model during automatic switching | |
| CN105279234A (en) | Cross-platform data acquisition and conversion method of state overhaul data of electric transmission and transformation equipment | |
| CN103237065B (en) | The automatic synchronous method of the Multi-state data in transformer station's integrated monitoring system | |
| CN108847714A (en) | A kind of high voltage direct current transmission transient data wave recording device and control protective unit | |
| CN110941615A (en) | Distributed hierarchical CNC data acquisition and dump method and system | |
| CN103810258A (en) | Data aggregation scheduling method based on data warehouse | |
| CN104184612A (en) | Power supply fault processing method and device | |
| CN103118121A (en) | Application method of high availability cluster in virtualization technology | |
| CN116095146A (en) | Source configuration method of relay protection information model of main substation and sub station based on block chain | |
| CN109271350A (en) | A kind of database and information point table automatic comparison and synchronous method based on telemechanical communication | |
| CN105323289A (en) | Distributed data synchronization method | |
| CN113194124B (en) | Distributed real-time database-based DCS background multi-node directory synchronization method | |
| CN112860657B (en) | Method and system for constructing address space of real-time database of TIAS (geographic information System) | |
| CN106648648B (en) | Zookeeper-based configuration management method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |