CN107943829A - A kind of cross-safety zone database synchronization method - Google Patents
A kind of cross-safety zone database synchronization method Download PDFInfo
- Publication number
- CN107943829A CN107943829A CN201710983010.5A CN201710983010A CN107943829A CN 107943829 A CN107943829 A CN 107943829A CN 201710983010 A CN201710983010 A CN 201710983010A CN 107943829 A CN107943829 A CN 107943829A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- key assignments
- file
- synchrodata
- 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 16
- 238000002955 isolation Methods 0.000 claims abstract description 22
- 238000005516 engineering process Methods 0.000 claims abstract description 11
- 230000001360 synchronised effect Effects 0.000 claims description 23
- 230000005540 biological transmission Effects 0.000 claims description 6
- 238000012545 processing Methods 0.000 abstract description 6
- 238000004891 communication Methods 0.000 description 6
- 238000012544 monitoring process Methods 0.000 description 4
- 238000010276 construction Methods 0.000 description 3
- 238000012546 transfer Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000012806 monitoring device Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000002457 bidirectional effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 239000004575 stone Substances 0.000 description 1
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
- G06F16/275—Synchronous replication
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06312—Adjustment or analysis of established resource schedule, e.g. resource or task levelling, or dynamic rescheduling
-
- 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—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- Health & Medical Sciences (AREA)
- Databases & Information Systems (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Entrepreneurship & Innovation (AREA)
- General Health & Medical Sciences (AREA)
- Educational Administration (AREA)
- Development Economics (AREA)
- Quality & Reliability (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- Game Theory and Decision Science (AREA)
- Primary Health Care (AREA)
- Computing Systems (AREA)
- Operations Research (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of cross-safety zone database synchronization method, comprise the following steps：A, increase synchrodata position in key assignments, update the naming rule of key assignments；B, source database is linked by physics isolation technology and purpose Database, and sends data or file to purpose database, produces key assignments change notification；C, when purpose database receives key assignments change notification, the synchrodata position of key assignments in the data or file received is judged, if synchrodata position is expressed as synchronization, purpose database root carries out data synchronously according to the data or file that receive and updates, and return to step B, continue waiting for producing key assignments change notification；If synchrodata position is expressed as asynchronous, termination, return to step B, continues waiting for producing key assignments change notification.So be no longer needed for from purpose database take out data judged, greatly reduce the visit capacity of database, improve data processing performance.
Description
Technical field
The present invention is used for electric power scheduling automatization system, the especially cross-safety zone of electric power scheduling automatization system data
Data are synchronous, are a kind of cross-safety zone database synchronization method.
Background technology
According to《National electric power secondary system security protection overall plan》Requirement, electric power scheduling automatization system is divided into 4
A place of safety, is respectively：One area of safety, is real time control area；2nd area of safety, are non-controlling production district；3rd area of safety, for production
Directorial area；4th area of safety, are management information area.Wherein one, the communication security in 3rd area is ensured by isolating communication device.One area arrives
The communication in 3rd area carries out one-way communication by positive isolating device；The communication in 3rd area a to area is carried out single by reverse isolation device
To communication.The basic characteristics of forward and reverse isolation be exactly positive isolation can only one-way data transfer, reverse isolation can only transmit file,
One area transmits data to 3rd area by positive isolating device, and the data in 3rd area are passed in a manner of file by reverse isolation device
Mono- areas of Shu Dao.In order to reduce the pressure of forward and reverse isolation, the mode of Partial synchronization is taken in one, three section key-value pair data storehouses.Key
Data are first taken out database across the synchronous needs of isolation and judge whether to need synchronization by value, then pass through forward and reverse isolation
Realize the synchronization of one, three area's data.
Real-time data base is the foundation stone of real-time monitoring system, and the key index for evaluating real-time data base is the visit of unit interval
The amount of asking.In large-scale real-time monitoring system, in order to lift data-handling capacity it is necessary to reducing real-time data base as far as possible
Visit capacity.
At present, following steps are synchronously taken in key-value pair data storehouse：
When the 1st, receiving the change notification of key assignments, data are taken out from database；
2nd, judge whether to need synchronization；
3rd, if desired synchronous then written document or directly transmit.
From above step as can be seen that no matter whether data need synchronously to be required for taking out data from database
Judge, even if data that need not be synchronous also in this way, add operation bidirectional, while the access times of database also significantly increase
Add.
The content of the invention
To solve the above problems, it is an object of the invention to provide a kind of cross-safety zone database synchronization method, Neng Gouyou
Effect reduces the visit capacity of database, and the disposal ability of system data is substantially improved.
Technical solution is used by the present invention solves the problems, such as it：
A kind of cross-safety zone database synchronization method, it is characterised in that comprise the following steps：
A, increase synchrodata position in key assignments, update the naming rule of key assignments；
B, source database is linked by physics isolation technology and purpose Database, and sends data or file extremely
Purpose database, produces key assignments change notification；
C, when purpose database receives key assignments change notification, key assignments in the data or file received it is same
Step data position judged, if synchrodata position is expressed as synchronization, purpose database root according to the data or file received into
Row data are synchronous and update, and return to step B, continue waiting for producing key assignments change notification；If synchrodata position is expressed as difference
Step, then termination, return to step B, continue waiting for producing key assignments change notification.
So be no longer needed for from purpose database take out data judged, greatly reduce the access of database
Amount, improves data processing performance.
Further, the naming rule of key assignments is updated in the step A, the naming rule of key assignments is：Area code data bit+synchronization
Data bit+priority data position+data.Wherein, area code data bit is used to indicate the place of safety belonging to key assignments；Synchrodata position
Value includes 1 and 0, when the value of synchrodata position is 1, represents synchronous, when the value of synchrodata position is 0, represents asynchronous；It is excellent
The value of first level data position includes 1 and 0, when the value of priority data position is 1, represents synchronous immediately, when priority data position
Be worth for 0 when, represent cycle synchronisation；Data value is the data or file that source database sends over.Using the key assignments
Naming rule construction key assignments have the characteristics that it is easy-to-understand, purpose database can quickly judge key assignments place place of safety,
Whether key message synchronous, that whether need preferential immediately synchronization is needed.
Further, when when source database is to purpose database transmissions data, the physics isolation technology in the step B
For positive isolating device；When purpose database is to source database transmissions file, the physics isolation technology in the step B is
Reverse isolation device.
Further, in the step C, purpose database root is according to data or file the progress data synchronization received and more
Newly, read first the data received either file then receive data or file write-in purpose database in it is complete
It is synchronous into data.
The beneficial effects of the invention are as follows：A kind of cross-safety zone database synchronization method that the present invention uses, by source
Construction includes the key assignments for whether needing synchronizing information in data or file that database is sent, and purpose database receives source
The data that database sends over either file when can judge the data according to the key assignments or file whether need into
Row is synchronous.So be no longer needed for from purpose database take out data judged, greatly reduce the visit capacity of database,
Improve data processing performance.
Brief description of the drawings
The invention will be further described with example below in conjunction with the accompanying drawings.
Fig. 1 is a kind of schematic diagram of cross-safety zone database synchronization method of the present invention.
Embodiment
With reference to Fig. 1, a kind of cross-safety zone database synchronization method of the invention, it is characterised in that comprise the following steps：
A, increase synchrodata position in key assignments, update the naming rule of key assignments；
B, source database is linked by physics isolation technology and purpose Database, and sends data or file extremely
Purpose database, produces key assignments change notification；
C, when purpose database receives key assignments change notification, key assignments in the data or file received it is same
Step data position judged, if synchrodata position is expressed as synchronization, purpose database root according to the data or file received into
Row data are synchronous and update, and return to step B, continue waiting for producing key assignments change notification；If synchrodata position is expressed as difference
Step, then termination, return to step B, continue waiting for producing key assignments change notification.
So be no longer needed for from purpose database take out data judged, greatly reduce the access of database
Amount, improves data processing performance.
Further, the naming rule of key assignments is updated in the step A, the naming rule of key assignments is：Area code data bit+synchronization
Data bit+priority data position+data.Wherein, area code data bit is used to indicate the place of safety belonging to key assignments；Synchrodata position
Value includes 1 and 0, when the value of synchrodata position is 1, represents synchronous, when the value of synchrodata position is 0, represents asynchronous；It is excellent
The value of first level data position includes 1 and 0, when the value of priority data position is 1, represents synchronous immediately, when priority data position
Be worth for 0 when, represent cycle synchronisation；Data value is the data or file that source database sends over.Using the key assignments
Naming rule construction key assignments have the characteristics that it is easy-to-understand, purpose database can quickly judge key assignments place place of safety,
Whether key message synchronous, that whether need preferential immediately synchronization is needed.
Further, when source database is to purpose database transmissions data, the physics isolation technology in the step B is
Positive isolating device；When purpose database is to source database transmissions file, the physics isolation technology in the step B is anti-
To isolating device.
Further, in the step C, purpose database root is according to data or file the progress data synchronization received and more
Newly, read first the data received either file then receive data or file write-in purpose database in it is complete
It is synchronous into data.
Embodiment one：
There occurs minor variations, real time monitoring device monitoring source number for existing one area's database of electric power scheduling automatization system
According to storehouse and after being found that this minor variations, constructed according to key assignments naming rule set in advance comprising whether needing synchronous letter
The key assignments 110 of breath, the key assignments represent data that place of safety where key assignments transfers out for an area, this time from an area need synchronization,
Receive data and carry out cycle synchronisation afterwards；Right latter zone database passes through positive isolating device and three area's purpose Databases
Link and send data to three area's purpose databases；Three area's database roots judge the data source in one according to the key assignments received
Area, need synchronous and carry out cycle synchronisation, then reads the data received and writes in this three area's database and completes this number
According to synchronization.Whole synchronizing process need not read data to determine whether needing synchronization from three area's databases, greatly reduce
The visit capacity of database, improves data processing performance.
Embodiment two：
There occurs minor variations, real time monitoring device monitoring source number for existing three area's database of electric power scheduling automatization system
According to storehouse and after being found that this minor variations, constructed according to key assignments naming rule set in advance comprising whether needing synchronous letter
The key assignments 300 of breath, the file that place of safety where which represents key assignments transfers out as 3rd area, this time from 3rd area need not be same
Step；Then three area's databases are linked with area's purpose Database by reverse isolation device and send file to area's purpose
Database；One area database root according to the key assignments received judge this document from 3rd area, need not be synchronous, directly return after
It is continuous to wait three area's databases to come again by reverse isolation device transmission file.Whole synchronizing process need not be from area's data
Data are read to determine whether needing synchronization in storehouse, are greatly reduced the visit capacity of database, are improved data processing performance.
The above, is presently preferred embodiments of the present invention, the invention is not limited in the above embodiment, as long as
It reaches the technique effect of the present invention with identical means, should all belong to protection scope of the present invention.
Claims (4)
1. a kind of cross-safety zone database synchronization method, it is characterised in that comprise the following steps：
A, increase synchrodata position in key assignments, update the naming rule of key assignments；
B, source database is linked by physics isolation technology and purpose Database, and sends data or file to purpose
Database, produces key assignments change notification；
C, when purpose database receives key assignments change notification, the same step number of the key assignments in the data or file received
Judged according to position, if synchrodata position is expressed as synchronization, purpose database root is according to the data or file received into line number
According to synchronization and update, and return to step B, continue waiting for producing key assignments change notification；If synchrodata position be expressed as it is asynchronous,
Termination, return to step B, continues waiting for producing key assignments change notification.
A kind of 2. cross-safety zone database synchronization method according to claim 1, it is characterised in that：In the step A more
The naming rule of new key assignments, the naming rule of key assignments are：Area code data bit+synchrodata position+priority data position+data.Its
In, area code data bit is used to indicate the place of safety belonging to key assignments；The value of synchrodata position includes 1 and 0, when the value of synchrodata position
For 1 when, represent synchronous, when the value of synchrodata position is 0, represent asynchronous；The value of priority data position includes 1 and 0, when excellent
When the value of first level data position is 1, represent synchronous immediately, when the value of priority data position is 0, represent cycle synchronisation；Data value
The data or file that as source database sends over.
A kind of 3. cross-safety zone database synchronization method according to claim 1, it is characterised in that：When source database to
During purpose database transmissions data, the physics isolation technology in the step B is positive isolating device；When purpose database is to source
When client database transmits file, the physics isolation technology in the step B is reverse isolation device.
A kind of 4. cross-safety zone database synchronization method according to claim 1, it is characterised in that：In the step C, mesh
Database root according to the data that receive, either file carries out that data are synchronous and the data received or text are read in renewal first
Part, it is then synchronous data are completed in data or file the write-in purpose database received.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710983010.5A CN107943829A (en) | 2017-10-20 | 2017-10-20 | A kind of cross-safety zone database synchronization method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710983010.5A CN107943829A (en) | 2017-10-20 | 2017-10-20 | A kind of cross-safety zone database synchronization method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107943829A true CN107943829A (en) | 2018-04-20 |
Family
ID=61935430
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710983010.5A Pending CN107943829A (en) | 2017-10-20 | 2017-10-20 | A kind of cross-safety zone database synchronization method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107943829A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108875012A (en) * | 2018-06-19 | 2018-11-23 | 南京国电南自电网自动化有限公司 | The filter method of real-time data synchronization under the conditions of a kind of physical isolation |
| CN110620800A (en) * | 2018-06-20 | 2019-12-27 | 北京金风慧能技术有限公司 | Method and device for synchronously processing configuration data of power secondary system across safety zones |
| CN110933144A (en) * | 2019-11-09 | 2020-03-27 | 许继集团有限公司 | Substation master station system and database synchronization method |
| CN112084254A (en) * | 2019-06-14 | 2020-12-15 | 北京京东尚科信息技术有限公司 | Data synchronization method and system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102289469A (en) * | 2011-07-26 | 2011-12-21 | 国电南瑞科技股份有限公司 | Method for supporting universal database to synchronize data based on physical isolating equipment |
| CN103279358A (en) * | 2013-06-08 | 2013-09-04 | 北京首钢自动化信息技术有限公司 | Interpreted dynamic business component construction method for industrial applications |
| CN103634185A (en) * | 2013-11-26 | 2014-03-12 | 国家电网公司 | Information exchange bus-based secondary safety protective synchronous trans-regional service method |
| CN104699760A (en) * | 2015-02-11 | 2015-06-10 | 安徽继远电网技术有限责任公司 | Data synchronization method used for heterogeneous system and based on safety isolation |
| CN105183898A (en) * | 2015-09-29 | 2015-12-23 | 北京奇艺世纪科技有限公司 | Data sync method and data sync system |
| CN106815218A (en) * | 2015-11-27 | 2017-06-09 | 华为技术有限公司 | Data bank access method, device and Database Systems |
-
2017
- 2017-10-20 CN CN201710983010.5A patent/CN107943829A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102289469A (en) * | 2011-07-26 | 2011-12-21 | 国电南瑞科技股份有限公司 | Method for supporting universal database to synchronize data based on physical isolating equipment |
| CN103279358A (en) * | 2013-06-08 | 2013-09-04 | 北京首钢自动化信息技术有限公司 | Interpreted dynamic business component construction method for industrial applications |
| CN103634185A (en) * | 2013-11-26 | 2014-03-12 | 国家电网公司 | Information exchange bus-based secondary safety protective synchronous trans-regional service method |
| CN104699760A (en) * | 2015-02-11 | 2015-06-10 | 安徽继远电网技术有限责任公司 | Data synchronization method used for heterogeneous system and based on safety isolation |
| CN105183898A (en) * | 2015-09-29 | 2015-12-23 | 北京奇艺世纪科技有限公司 | Data sync method and data sync system |
| CN106815218A (en) * | 2015-11-27 | 2017-06-09 | 华为技术有限公司 | Data bank access method, device and Database Systems |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108875012A (en) * | 2018-06-19 | 2018-11-23 | 南京国电南自电网自动化有限公司 | The filter method of real-time data synchronization under the conditions of a kind of physical isolation |
| CN110620800A (en) * | 2018-06-20 | 2019-12-27 | 北京金风慧能技术有限公司 | Method and device for synchronously processing configuration data of power secondary system across safety zones |
| CN112084254A (en) * | 2019-06-14 | 2020-12-15 | 北京京东尚科信息技术有限公司 | Data synchronization method and system |
| CN110933144A (en) * | 2019-11-09 | 2020-03-27 | 许继集团有限公司 | Substation master station system and database synchronization method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107943829A (en) | A kind of cross-safety zone database synchronization method | |
| CN107729366A (en) | A kind of pervasive multi-source heterogeneous large-scale data synchronization system | |
| CN103345435A (en) | Data backup and restoration method and destination sever system for backup | |
| CN101778134A (en) | Data synchronization method and mobile communication terminal | |
| MX2022005569A (en) | Control information indicating method, communication node and computer readable storage medium. | |
| CN107908897A (en) | A kind of differentiation priority polling system based on FPGA | |
| CN104243495A (en) | Reverse isolating device cross method and system for JMS (java message service) | |
| CN103390252B (en) | A kind of control centre and intelligent substation graphical information exchange method | |
| CN105759754A (en) | Province-prefecture-county integrated dispatching automatic system graphic data management and sharing method | |
| CN104182818B (en) | A kind of method and system of substation information intelligence automatic data collection | |
| CN106855869A (en) | A kind of methods, devices and systems for realizing database High Availabitity | |
| CN105471654A (en) | FC network based configuration data automatic uploading method | |
| CN106971272A (en) | Synchronous system and method is operated between a kind of dispatching automation main preparation system | |
| CN106649418A (en) | High-performance method for importing data into distributed database through direct connection of fragments in driver | |
| CN103618753B (en) | Trans-secret-region data exchange method based on one-way transmission equipment | |
| CN102769495A (en) | Optical access network equipment communication method, device and system | |
| CN104270374A (en) | Method and system of JMS cross forward isolating device | |
| CN105303467B (en) | Keep the method and its system of Electric Power Marketing System and power distribution system data consistency | |
| CN202758228U (en) | Pumping station group monitoring system | |
| CN103581064A (en) | Message reassembly method applicable to communication of substation monitoring system | |
| CN101615338B (en) | Electric data transmission method of remote meter-reading system | |
| CN107070955A (en) | The transmission method and device of a kind of electric power system data | |
| CN103326466B (en) | Wireless public network communication data transmission system based on multiple key stations | |
| CN102256276B (en) | Road test information processing method and device | |
| CN102647331B (en) | Programmable logic controller with historical variable and data communication method of controller |
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 | ||
| CB03 | Change of inventor or designer information |
Inventor after: Hu Qihong Inventor after: Hai Tao Inventor after: Xu Jun Inventor after: Fang Yinghui Inventor after: Xu Guang Inventor after: Xue Hongying Inventor before: Hu Qihong Inventor before: Xu Jun Inventor before: Fang Yinghui Inventor before: Xu Guang Inventor before: Xue Hongying |
|
| CB03 | Change of inventor or designer information | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180420 |
|
| RJ01 | Rejection of invention patent application after publication |