CN110990481A - Synchronization method and system for historical data of power distribution automation system - Google Patents
Synchronization method and system for historical data of power distribution automation system Download PDFInfo
- Publication number
- CN110990481A CN110990481A CN201911005938.1A CN201911005938A CN110990481A CN 110990481 A CN110990481 A CN 110990481A CN 201911005938 A CN201911005938 A CN 201911005938A CN 110990481 A CN110990481 A CN 110990481A
- Authority
- CN
- China
- Prior art keywords
- area
- log
- query
- synchronization
- automation 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.)
- 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/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
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Computing Systems (AREA)
- Remote Monitoring And Control Of Power-Distribution Networks (AREA)
Abstract
The invention relates to a synchronization method and a system for historical data of a power distribution automation system, which are used for realizing the following steps: s10, adding an identification character for representing log generation time and area to a character string uniquely identified by a historical data log in the distribution automation system; s20, setting the synchronization time of each area of the distribution automation system, initiating a query request to the queried area by the query initiating area, and returning the log generation time and the log generation area of the character string in the unique log identifier by the queried area; and S30, comparing the returned information by the query initiating area, if the query initiating area is consistent with the information of the queried area, not performing periodic data synchronization, otherwise, performing data synchronization. The invention has the beneficial effects that: the invention has the beneficial effects that: the synchronous flow of the historical data of the cross-isolation database is effectively reduced; redundant fields in the design of the database table are reduced, the storage space is saved, and the storage efficiency is improved.
Description
Technical Field
The invention relates to a data synchronization method of a power distribution automation system, in particular to a synchronization method and a synchronization system of historical data of the power distribution automation system.
Background
With the continuous improvement of the informatization degree, the security requirement on the information is higher and higher. Forward and reverse isolation between cross-regions (e.g., one and four regions) is essential, which can cause data synchronization trouble. The forward and reverse isolation is basically characterized in that the forward isolation can only transmit data in one direction, the reverse isolation can only transmit files, one area transmits the data to four areas in the forward direction, and the data of the four areas is transmitted to the one area in the file mode through the reverse isolation.
The synchronization of the historical data can be divided into real-time synchronization and periodic synchronization, wherein the real-time synchronization means that the data is written into a local area database and a counter area database at the same time, and refer to fig. 1; the periodic synchronization is a mode of periodically transmitting data generated in the local area in a specified time period to the opposite area and forcibly synchronizing the data. Mainly to repair data loss due to real-time synchronization failure, refer to fig. 2.
In the prior art, when the period is synchronized, the key is the synchronized data range, and the current general method is that a time field and an area field are newly added in a database table to filter local data of specified time. The general method of whether synchronization is required is unconditional synchronization for identifying region information. The required synchronization generally adopts a full data synchronization mode in a specified time period. And if the result is obtained, other fields Logid are generally generated by adopting the automatic growth of a main key of the database.
The prior art has the following disadvantages: the newly added fields occupy the database space; and when the synchronization is unconditional, a large amount of forward and reverse isolation flow is occupied.
Disclosure of Invention
The invention aims to solve at least one technical problem in the prior art and provide a method and a system for positioning a full-line quick-action fault of a power distribution network.
The technical scheme of the invention comprises a synchronization method of historical data of a power distribution automation system, which is characterized by comprising the following steps: s10, adding an identification character for representing log generation time and area to a character string uniquely identified by a historical data log in the distribution automation system; s20, setting the synchronization time of each area of the distribution automation system, initiating a query request to the queried area by the query initiating area, and returning the log generation time and the log generation area of the character string in the unique log identifier by the queried area; and S30, comparing the returned information by the query initiating area, if the query initiating area is consistent with the information of the queried area, not performing periodic data synchronization, otherwise, performing data synchronization.
According to the method for synchronizing historical data of the power distribution automation system, step S10 specifically includes: the method comprises the steps of adding identification characters for representing log generation time and areas to a character string uniquely identified by a historical data log in the distribution automation system, wherein the identification characters comprise current time, count in millisecond and an ID of the area to which the log generation time and the area belong.
The method for synchronizing historical data of a power distribution automation system, wherein the current time is accurate to milliseconds.
The method for synchronizing historical data of a power distribution automation system, wherein the character string uniquely identified by the historical data log in the power distribution automation system is configured to be long and integer.
According to the method for synchronizing historical data of the power distribution automation system, step S20 specifically includes: s21, the query initiating area sends a query command to the queried area, wherein the query command contains time period and area information; s22, after the inquired area receives the inquiry command, the area information inquires the information of the character string uniquely identified by the historical data log according to the time period; and S23, the query initiating area queries the information of the character string uniquely identified by the historical data log of the query initiating area, compares the information with the information returned by the queried area to obtain a judgment result, and executes a corresponding synchronization strategy according to the judgment result.
The method for synchronizing historical data of the power distribution automation system further comprises the following steps: and dividing the log file into a plurality of subfiles according to a preset query time period, wherein the character string of the unique identifier of each file is consistent with the divided time period.
According to the synchronization method for the historical data of the power distribution automation system, S30 specifically includes: according to the fed-back log files in the same time period, if the query initiating area is consistent with the queried area, periodic data synchronization is carried out; if the query initiating area is inconsistent with the queried area, the change synchronous operation is abnormal, and the periodic data synchronization is carried out.
The technical scheme of the invention also comprises a synchronization system of historical data of the power distribution automation system, wherein the synchronization system is used for any one of the methods, and is characterized in that: the file identification module is used for adding identification characters for representing log generation time and areas to a character string uniquely identified by a historical data log in the distribution automation system; the system comprises a region query module, a log unique identification module and a log generation module, wherein the region query module is used for setting synchronization time of each region of the distribution automation system, a query initiating region initiates a query request to a queried region, and the queried region returns log generation time and a region of a character string in the log unique identification; and the data synchronization module is used for comparing the returned information of the query initiating area, if the information of the query initiating area is consistent with that of the queried area, the periodic data synchronization is not carried out, and otherwise, the data synchronization is carried out.
The invention has the beneficial effects that: the synchronous flow of the historical data of the cross-isolation database is effectively reduced; redundant fields in the design of the database table are reduced, the storage space is saved, and the storage efficiency is improved.
Drawings
The invention is further described below with reference to the accompanying drawings and examples;
FIG. 1 is a schematic diagram of real-time synchronization;
FIG. 2 is a schematic diagram of a fault traveling wave bypass capacitance;
FIG. 3 illustrates an overall flow diagram according to an embodiment of the invention;
FIG. 4 is a block diagram of a system according to an embodiment of the invention;
FIG. 5 is a diagram illustrating a string of a log name according to an embodiment of the invention;
fig. 6 shows a first embodiment according to the present invention.
Detailed Description
Reference will now be made in detail to the present preferred embodiments of the present invention, examples of which are illustrated in the accompanying drawings, wherein like reference numerals refer to like elements throughout.
In the description of the present invention, it should be understood that the orientation or positional relationship referred to in the description of the orientation, such as the upper, lower, front, rear, left, right, etc., is based on the orientation or positional relationship shown in the drawings, and is only for convenience of description and simplification of description, and does not indicate or imply that the device or element referred to must have a specific orientation, be constructed and operated in a specific orientation, and thus, should not be construed as limiting the present invention.
In the description of the present invention, the meaning of a plurality of means is one or more, the meaning of a plurality of means is two or more, and larger, smaller, larger, etc. are understood as excluding the number, and larger, smaller, inner, etc. are understood as including the number. If the first and second are described for the purpose of distinguishing technical features, they are not to be understood as indicating or implying relative importance or implicitly indicating the number of technical features indicated or implicitly indicating the precedence of the technical features indicated.
In the description of the present invention, unless otherwise explicitly limited, terms such as arrangement, installation, connection and the like should be understood in a broad sense, and those skilled in the art can reasonably determine the specific meanings of the above terms in the present invention in combination with the specific contents of the technical solutions.
Fig. 3 shows a general flow diagram according to an embodiment of the invention. The flow is as follows: s10, adding an identification character for representing log generation time and area to a character string uniquely identified by a historical data log in the distribution automation system; s20, setting the synchronization time of each area of the distribution automation system, initiating a query request to the queried area by the query initiating area, and returning the log generation time and the log generation area of the character string in the unique log identifier by the queried area; and S30, comparing the returned information by the query initiating area, if the query initiating area is consistent with the information of the queried area, not performing periodic data synchronization, otherwise, performing data synchronization.
FIG. 4 is a block diagram of a system according to an embodiment of the present invention. The method comprises the following steps: the file identification module is used for adding identification characters for representing log generation time and areas to a character string uniquely identified by a historical data log in the distribution automation system; the system comprises a region query module, a log unique identification module and a log generation module, wherein the region query module is used for setting synchronization time of each region of the distribution automation system, a query initiating region initiates a query request to a queried region, and the queried region returns log generation time and a region of a character string in the log unique identification; and the data synchronization module is used for comparing the returned information of the query initiating area, if the information of the query initiating area is consistent with that of the queried area, the periodic data synchronization is not carried out, and otherwise, the data synchronization is carried out.
FIG. 5 is a diagram illustrating a string of a log name according to an embodiment of the present invention. A naming rule of logId (ID string) including the time and area of record generation is prepared. The logId naming convention can continue to translate number (24) to long type, reducing storage space if readability of logId is not considered as shown in FIG. 5.
Fig. 6 shows a first embodiment according to the present invention. The flow is as follows:
the period synchronization period is sliced. Preferably 30 minutes. The synchronous transmission file is prevented from being too large.
The local zone sends a query command to the opposite zone. The query command contains time period and area information.
After receiving the query command, the opposite region. According to the time period, the regional information inquires logId information (logId number and md5 is calculated)
The region is inquired in the same way and is compared and judged with the information returned by the region. Thereby deciding on the synchronization policy.
And the local area information is the opposite area information, which indicates that the synchronous operation of the change is normal. No periodic data synchronization is required.
Information of local area! For the region information, it is described that the change synchronization operation is abnormal, and the periodic data synchronization is required.
The embodiments of the present invention have been described in detail with reference to the accompanying drawings, but the present invention is not limited to the above embodiments, and various changes can be made within the knowledge of those skilled in the art without departing from the gist of the present invention.
Claims (8)
1. A method for synchronizing historical data of a power distribution automation system is characterized by comprising the following steps:
s10, adding an identification character for representing log generation time and area to a character string uniquely identified by a historical data log in the distribution automation system;
s20, setting the synchronization time of each area of the distribution automation system, initiating a query request to the queried area by the query initiating area, and returning the log generation time and the log generation area of the character string in the unique log identifier by the queried area;
and S30, comparing the returned information by the query initiating area, if the query initiating area is consistent with the information of the queried area, not performing periodic data synchronization, otherwise, performing data synchronization.
2. The method for synchronizing historical data of a power distribution automation system according to claim 1, wherein the step S10 specifically includes:
the method comprises the steps of adding identification characters for representing log generation time and areas to a character string uniquely identified by a historical data log in the distribution automation system, wherein the identification characters comprise current time, count in millisecond and an ID of the area to which the log generation time and the area belong.
3. The method of synchronizing power distribution automation system historical data of claim 2 wherein the current time is accurate to milliseconds.
4. The power distribution automation system history data synchronization method of claim 2 wherein the string uniquely identified by the history data log in the power distribution automation system is configured as a long integer.
5. The full-line quick-action fault location method for the power distribution network according to claim 1, wherein the step S20 specifically includes:
s21, the query initiating area sends a query command to the queried area, wherein the query command contains time period and area information;
s22, after the inquired area receives the inquiry command, the area information inquires the information of the character string uniquely identified by the historical data log according to the time period;
and S23, the query initiating area queries the information of the character string uniquely identified by the historical data log of the query initiating area, compares the information with the information returned by the queried area to obtain a judgment result, and executes a corresponding synchronization strategy according to the judgment result.
6. The full-line fast-moving fault location method for the power distribution network according to claim 5, characterized in that the method further comprises:
and dividing the log file into a plurality of subfiles according to a preset query time period, wherein the character string of the unique identifier of each file is consistent with the divided time period.
7. The full-line quick-action fault location method for the power distribution network according to claim 1, wherein the S30 specifically includes:
according to the fed log files in the same time period, if the query initiating area is consistent with the queried area, carrying out periodic data synchronization; and the inquiry initiating area is inconsistent with the inquired area, which shows that the change synchronous operation is abnormal, and the periodic data synchronization is carried out.
8. A synchronization system for historical data of a power distribution automation system, the synchronization system configured to perform the method of any of claims 1-7, wherein:
the file identification module is used for adding identification characters for representing log generation time and areas to a character string uniquely identified by a historical data log in the distribution automation system;
the system comprises a region query module, a log unique identification module and a log generation module, wherein the region query module is used for setting synchronization time of each region of the distribution automation system, a query initiating region initiates a query request to a queried region, and the queried region returns log generation time and a region of a character string in the log unique identification;
and the data synchronization module is used for comparing the returned information of the query initiating area, if the information of the query initiating area is consistent with that of the queried area, the periodic data synchronization is not carried out, and otherwise, the data synchronization is carried out.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911005938.1A CN110990481A (en) | 2019-10-22 | 2019-10-22 | Synchronization method and system for historical data of power distribution automation system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911005938.1A CN110990481A (en) | 2019-10-22 | 2019-10-22 | Synchronization method and system for historical data of power distribution automation system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110990481A true CN110990481A (en) | 2020-04-10 |
Family
ID=70082312
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911005938.1A Pending CN110990481A (en) | 2019-10-22 | 2019-10-22 | Synchronization method and system for historical data of power distribution automation system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110990481A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103237075A (en) * | 2013-04-24 | 2013-08-07 | 广州市动景计算机科技有限公司 | Data synchronizing method, device and system |
| CN103455599A (en) * | 2013-09-03 | 2013-12-18 | 北京网秦天下科技有限公司 | Method, equipment and system for data synchronism |
| CN104636353A (en) * | 2013-11-07 | 2015-05-20 | 中国科学院沈阳自动化研究所 | High-performance log record query method for integrated circuit production line carrying system |
| CN106126730A (en) * | 2016-07-01 | 2016-11-16 | 百势软件(北京)有限公司 | A kind of method and device of Mass production warning information |
-
2019
- 2019-10-22 CN CN201911005938.1A patent/CN110990481A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103237075A (en) * | 2013-04-24 | 2013-08-07 | 广州市动景计算机科技有限公司 | Data synchronizing method, device and system |
| CN103455599A (en) * | 2013-09-03 | 2013-12-18 | 北京网秦天下科技有限公司 | Method, equipment and system for data synchronism |
| CN104636353A (en) * | 2013-11-07 | 2015-05-20 | 中国科学院沈阳自动化研究所 | High-performance log record query method for integrated circuit production line carrying system |
| CN106126730A (en) * | 2016-07-01 | 2016-11-16 | 百势软件(北京)有限公司 | A kind of method and device of Mass production warning information |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| ZA200509949B (en) | Method and device for configuring data in communication device | |
| CN106533762A (en) | Device switching method and device switching device | |
| CN101876924A (en) | Database fault automatic detection and transfer method | |
| CN201497981U (en) | Database failure automatic detecting and shifting system | |
| CN102740160A (en) | Method and apparatus for recording failures of television software | |
| US11329866B2 (en) | Battery management system and communication method thereof | |
| CN111740877B (en) | Link detection method and system | |
| CN112764956B (en) | Database exception handling system, database exception handling method and device | |
| CN101436209A (en) | Method and apparatus for synchronizing multiple databases | |
| WO2018112869A1 (en) | Alarm synchronization method and system | |
| CN104753712A (en) | Alarming report method, alarming report node and alarming report system | |
| CN108833451B (en) | Domestic safety control platform-based multistage control system and control method | |
| CN110990481A (en) | Synchronization method and system for historical data of power distribution automation system | |
| CN104378427A (en) | Method for maintaining consistency of key data of clusters | |
| CN111309515B (en) | Disaster recovery control method, device and system | |
| CN106649814A (en) | Method for consistency checking of distribution automation cross-domain database | |
| CN101207513A (en) | Apparatus and method for saving historical data | |
| CN109995848B (en) | System configuration data management method based on block chain and intelligent contract | |
| CN111090648B (en) | Relational database data synchronization conflict resolution method | |
| CN103500179B (en) | A kind of data source change method for early warning | |
| CN114331092A (en) | Equipment shadow, remote scheduling management method, device and system for engineering mechanical equipment | |
| CN101997718A (en) | Fault positioning method and device | |
| CN102571827B (en) | Lots of real time data storage distribution and query information processing method | |
| CN108897645B (en) | Database cluster disaster tolerance method and system based on standby heartbeat disk | |
| CN112118165A (en) | 1553B bus message channel switching control method |
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 |