CN103646353A - Database synchronization method for substation automated monitoring system - Google Patents
Database synchronization method for substation automated monitoring system Download PDFInfo
- Publication number
- CN103646353A CN103646353A CN201310612340.5A CN201310612340A CN103646353A CN 103646353 A CN103646353 A CN 103646353A CN 201310612340 A CN201310612340 A CN 201310612340A CN 103646353 A CN103646353 A CN 103646353A
- Authority
- CN
- China
- Prior art keywords
- real
- synchronous
- database
- node
- time
- 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
- 238000000034 method Methods 0.000 title claims abstract description 22
- 238000012544 monitoring process Methods 0.000 title claims abstract description 12
- 230000000712 assembly Effects 0.000 claims abstract description 8
- 238000000429 assembly Methods 0.000 claims abstract description 8
- 230000001360 synchronised effect Effects 0.000 claims description 47
- 230000008569 process Effects 0.000 claims description 10
- 238000012217 deletion Methods 0.000 claims description 8
- 230000037430 deletion Effects 0.000 claims description 8
- 230000009471 action Effects 0.000 claims description 7
- 230000008859 change Effects 0.000 claims description 3
- 238000007596 consolidation process Methods 0.000 claims description 2
- 230000004048 modification Effects 0.000 claims description 2
- 238000012986 modification Methods 0.000 claims description 2
- 238000012545 processing Methods 0.000 abstract description 3
- 230000005856 abnormality Effects 0.000 description 2
- 238000004321 preservation Methods 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
Images
Abstract
The invention discloses a database synchronization method for a substation automated monitoring system. According to the database synchronization method of the invention, three assemblies which are additionally mounted in the substation monitoring system are respectively data service programs, real-time base management programs and synchronization service programs; machines which are deployed in a substation are server nodes and an operation station node, wherein the server nodes are machines which are provided with commercial databases; and the data service programs and the synchronization service programs are only needed to be deployed on the server nodes, and the real-time base management programs are needed to be deployed on each node. According to the database synchronization method of the invention, the service programs jointly coordinate processing, and therefore, not only can the synchronization among a plurality of node commercial bases be ensured, but also the synchronization among a plurality of node real-time bases can be ensured; and further, the expansion of the number of the nodes is supported. The database synchronization method is suitable for the deployment architecture of a current intelligent substation.
Description
Technical field
The invention belongs to power automatic system technical field, relate to more precisely a kind of database synchronization method of automatic monitoring system of transformer substation.
Background technology
In electric substation automation system, need to substation operation situation monitor, control and management, not only need to safeguard a large amount of shared data and control knowledge; And the completing and there is the strict time limit of these application activities.Therefore in monitoring system of electric substation, both needed business database also to need real-time data base.
For adapting to the needs of large-scale substation and concentrator station, system adopts layered distribution type structure,, object of protection monitored according to transformer station and systemic-function, distribute many computing machines be set, and they are connected to and can on the network of shared resource, realize distributed treatment; Real Time Data of Substation storehouse is the distributing real-time data bank distributing by function, and being different application provides the real-time data base of service to be distributed on different nodes.In order to guarantee that the reliability of monitoring system of electric substation carries out redundant configuration to server, independently business data library software is installed on every station server, complete the preservation of historical data and configuration parameter.
No matter be business storehouse or in real time storehouse all exists on different nodes, how correctly, reliably what guarantee data between them is to be synchronously badly in need of a problem solving.
Summary of the invention
The object of the invention is to: the database synchronization method that a kind of automatic monitoring system of transformer substation is provided, by the common Coordination Treatment of service routine, both guaranteed synchronous between a plurality of node business storehouse, also guarantee synchronous between the real-time storehouse of a plurality of nodes, and the expansion of support node number, adapt to the deployment framework of current intelligent substation.
The present invention takes following technical scheme to realize: in monitoring system of electric substation, increase by three assemblies, be respectively data services, real-time library manager and synchronous service program, the machine that transformer station disposes is server node and active station node, server node refers to the machine that business database is installed, two assemblies of data services and synchronous service program only need be deployed on server node, and library manager need to be deployed on each node in real time.
Need to delete database, when change, update, calling interface sends to the data services of server node according to consolidation form, data services receive after this order, the machine business database is operated, after operation is correct, the sql statement of operation is sent to synchronous service program, by synchronous service program, complete the operation to the synchronous database of needs; After said process finishes, data services calculate the database of synchronous which node of this action need, real-time library manager to corresponding node sends real-time storehouse synchronous operation message afterwards, the real-time library manager of each node deployment is responsible for receiving operation information, and message is parsed local real-time data base operation.
Data services possess following functions: the data operation request message that 1. receives application; 2. complete the parsing to this request message; 3. complete the operation in the machine business storehouse and transmit operation message to synchronous service program; 4. complete the message of real-time library manager is sent; Library manager possesses following functions in real time: 1. receive message and this message of parsing that data services send; 2. complete deletion, change, update to local data base; Synchronous service program possesses following functions: 1. receive data synchronous operation message; 2. complete needing the maintenance of synchrodata connecting state; 3. in the preservation that connects complete paired data synchronous operation under abnormality; 4. complete after connecting normal condition or recovering normally needing the corresponding operating of sync database.
The present invention has the following advantages: 1, by data manipulation service routine and real-time library manager, the synchronous of real-time data base that mutually cooperated, completes the synchronous of business database by data manipulation service routine and synchronous service program; 2, data manipulation service routine provides data operating interface for application call, and will after the unified processing of information, send to the real-time library manager of different machines to carry out synchronously real-time storehouse; 3, data manipulation service routine provides data operating interface for application call, and corresponding operating is carried out in the machine business storehouse, provides information to synchronous service program simultaneously; 3, every machine of library manager is all disposed in real time, the operation information in receiving real-time data storehouse, and complete the real-time storehouse operation to the machine; 4, synchronous service program completes needing the judgement of sync database state and maintaining link, completes the synchronous operation of its data and the mechanism of the data Save and restore under abnormality simultaneously; 5, data synchronous operation keeps being connected by network with needing sync database, after receiving corresponding data manipulation, it is carried out to network operation and completes the synchronous of database; 6, when synchronous service program exception or with database, be connected when abnormal, the operation that need are synchronous preserved to corresponding SQL statement with file layout, generation recover normal after, after the content in file is operated, be transformed into again normal reception & disposal state.
Accompanying drawing explanation
Fig. 1 is structured flowchart of the present invention.
Fig. 2 is business of the present invention storehouse synchronous operation schematic flow sheet.
Fig. 3 is real-time storehouse synchronous operation schematic flow sheet of the present invention.
Embodiment
Below by specific embodiment, the present invention is described in detail, makes those skilled in the art clearlyer understand all sidedly the inventive method, but do not limit the present invention in any way.
Embodiment: coordinated database synchronization function by increase batch processing in original supervisory system, the structure of Fig. 1 of take is example, this transformer station is deployed with three nodes, two-server, Yi Tai operator station, in server deploy data services, in real time library manager, three assemblies of synchronous service program, in active station deploy real-time library manager.
With application, database is carried out to deletion action explanation business storehouse synchronous operation process and real-time storehouse synchronous operation process below.
(1) business storehouse synchronous operation: application is according to the assembled delete database message of agreement form, by third party's plug-in unit, send to the data services of resident server, data services are resolved it, obtain table to be modified and record, then complete the assembled of corresponding sql statement, call packaged in advance interface the machine business database is carried out to deletion action, and this sql statement is sent to synchronous service program; Synchronous service program receives after this sql statement, if connecting the next direct sync database of normal situation, otherwise preserves this sql statement in file; After pending data storehouse connection status is normal, operate again; Cooperation relation between these assemblies as shown in Figure 2;
(2) storehouse synchronous operation in real time: the process of having applied and the complete process of data services are the same, just at data services, be successfully completed after the modification in business storehouse, beginning is according to the assembled deletion real-time data base of agreement form message, and will delete message and send to the real-time library manager of each machine node, library manager receives and resolves after this message in real time, deletion action is carried out in the real-time storehouse of the machine, thereby guaranteed that the data between each node are synchronous; Cooperation relation between these assemblies as shown in Figure 3.
By above method, can well complete the data synchronization problems of multi-computer system, also can be applied in the software that one-of-a-kind system upgrades to multi-computer system.
Claims (2)
1. the database synchronization method of automatic monitoring system of transformer substation, it is characterized in that: in monitoring system of electric substation, increase by three assemblies, be respectively data services, real-time library manager and synchronous service program, the machine that transformer station disposes is server node and active station node, server node refers to the machine that business database is installed, two assemblies of data services and synchronous service program only need be deployed on server node, and library manager need to be deployed on each node in real time; Need to delete database, when change, update, calling interface sends to the data services of server node according to consolidation form, data services receive after this order, the machine business database is operated, after operation is correct, the sql statement of operation is sent to synchronous service program, by synchronous service program, complete the operation to the synchronous database of needs; After said process finishes, data services calculate the database of synchronous which node of this action need, real-time library manager to corresponding node sends real-time storehouse synchronous operation message afterwards, the real-time library manager of each node deployment is responsible for receiving operation information, and message is parsed local real-time data base operation.
2. the database synchronization method of automatic monitoring system of transformer substation according to claim 1, is characterized in that: business storehouse synchronous operation process and synchronous operation process in storehouse is as follows in real time:
(1) business storehouse synchronous operation: application is according to the assembled delete database message of agreement form, by third party's plug-in unit, send to the data services of resident server, data services are resolved it, obtain table to be modified and record, then complete the assembled of corresponding sql statement, call packaged in advance interface the machine business database is carried out to deletion action, and this sql statement is sent to synchronous service program; Synchronous service program receives after this sql statement, if connecting the next direct sync database of normal situation, otherwise preserves this sql statement in file; After pending data storehouse connection status is normal, operate again;
(2) storehouse synchronous operation in real time: the process of having applied and the complete process of data services are the same, just at data services, be successfully completed after the modification in business storehouse, beginning is according to the assembled deletion real-time data base of agreement form message, and will delete message and send to the real-time library manager of each machine node, library manager receives and resolves after this message in real time, deletion action is carried out in the real-time storehouse of the machine, thereby guaranteed that the data between each node are synchronous.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310612340.5A CN103646353A (en) | 2013-11-28 | 2013-11-28 | Database synchronization method for substation automated monitoring system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310612340.5A CN103646353A (en) | 2013-11-28 | 2013-11-28 | Database synchronization method for substation automated monitoring system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103646353A true CN103646353A (en) | 2014-03-19 |
Family
ID=50251563
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310612340.5A Pending CN103646353A (en) | 2013-11-28 | 2013-11-28 | Database synchronization method for substation automated monitoring system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103646353A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112187916A (en) * | 2020-09-27 | 2021-01-05 | 中国银联股份有限公司 | Cross-system data synchronization method and device |
-
2013
- 2013-11-28 CN CN201310612340.5A patent/CN103646353A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112187916A (en) * | 2020-09-27 | 2021-01-05 | 中国银联股份有限公司 | Cross-system data synchronization method and device |
| CN112187916B (en) * | 2020-09-27 | 2023-12-05 | 中国银联股份有限公司 | Cross-system data synchronization method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102945195A (en) | Master-standby redundancy replication method based on SQLite databases | |
| CN102866690B (en) | Redundancy switching method between Redundant process control station in scattered control system | |
| CN104461752A (en) | Two-level fault-tolerant multimedia distributed task processing method | |
| CN104601383B (en) | A kind of power telecom network fault piecewise analysis method | |
| CN104506357A (en) | High-usability cluster node management method | |
| CN104252500A (en) | Method and device for carrying out fault repairing on database management platform | |
| CN103036719A (en) | Cross-regional service disaster method and device based on main cluster servers | |
| CN106452854B (en) | A kind of subway comprehensive monitoring system synchronous communication method based on multi-connection master-slave redundancy | |
| CN103995868A (en) | Distributed system oriented global transaction manager and transaction handling method | |
| CN103226483A (en) | DHBS (dual hot-backup system) and method thereof based on SOA (service-oriented architecture) and cloud storage | |
| CN106878466A (en) | A kind of Hydropower Unit data management and equipment control unified platform | |
| CN101546189B (en) | Method for controlling real-time database system | |
| CN104486394A (en) | Non-interrupting service software upgrading method and device | |
| CN104394018A (en) | Communication device and active-standby system data online exchange method for hot master control panel backup | |
| CN111600385A (en) | Information interaction method and monitoring system | |
| CN102957623A (en) | Maintenance method and equipment of neighborhood of border gate protocol | |
| CN103441878A (en) | Method and device for processing ownership of PE device in VCF network | |
| CN103488726A (en) | Method for establishing unified grid data platform based on WEB-SERVICE | |
| CN105938490A (en) | Intelligent switching method and system for connecting web application system with data source | |
| CN105743695A (en) | Monitoring method and system based on IEC 104 protocol | |
| CN103646353A (en) | Database synchronization method for substation automated monitoring system | |
| CN102868218A (en) | Transition method for improving monitoring system in intelligent improvement of ordinary transformer substation | |
| CN102722797B (en) | The information layered method of electric power scheduling automatization system based on zone of responsibility | |
| CN104796283A (en) | Monitoring alarm method | |
| CN102819252B (en) | Method for realizing multi-redundancy of process control station in distributed control system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20140319 |