CN104050246A - Pre-processing method and system for state monitoring data of electric transmission and transformation equipment - Google Patents
Pre-processing method and system for state monitoring data of electric transmission and transformation equipment Download PDFInfo
- Publication number
- CN104050246A CN104050246A CN201410245050.6A CN201410245050A CN104050246A CN 104050246 A CN104050246 A CN 104050246A CN 201410245050 A CN201410245050 A CN 201410245050A CN 104050246 A CN104050246 A CN 104050246A
- Authority
- CN
- China
- Prior art keywords
- data
- measurement period
- value
- analog data
- increment analog
- 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
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2272—Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
Abstract
The invention provides a pre-processing method and system for state monitoring data of electric transmission and transformation equipment. The method comprises the following steps: obtaining historical state monitoring data; dividing the historical state monitoring data into historical switching value data and historical analog quantity data; compressing historical switching value data and then storing; selecting a target statistical period; counting the historical analog quantity data corresponding to the target statistical period so as to obtain a maximum value, a minimum value, the epoch of the maximum value and the epoch of the minimum value of the analog quantity data corresponding to the historical analog quantity data; storing the data in a form of characteristic data corresponding to the target statistical period; judging whether the maximum value is larger than a preinstalled first threshold value, if no, updating the maximum value by using the first threshold value; judging whether the minimum value is smaller than a preinstalled second threshold value, if no, updating the minimum value by using the second threshold value; judging whether the minimum value is smaller than the preinstalled second threshold value, if no, updating the minimum value by using the second threshold value; establishing indexes for the stored history switching value and the stored characteristic data, so as to improve the efficiency in analyzing condition monitoring data.
Description
Technical field
The present invention relates to power transmission and transforming equipment monitoring field, particularly relate to a kind of preprocess method and system of power transmission and transformation equipment state Monitoring Data.
Background technology
Power transmission and transforming equipment is the main element in electric system.The maintenance mode of power transmission and transforming equipment develops into repair based on condition of component from trouble hunting or fixed cycle maintenance, greatly reduces the cost of overhaul, has guaranteed the reliability of system.The repair based on condition of component of power transmission and transforming equipment can produce large number quipments Condition Monitoring Data.When these equipment condition monitoring data are deposited in the historical data base of data acquisition and supervisor control, just become mass data.When power transmission and transforming equipment is carried out to state estimation, just need to from the historical data base of data acquisition and supervisor control, inquire about mass data, the important step in the process that its inquiry preprocessing process is equipment state assessment.
At present, in intelligent substation, monitoring of equipment device is more, and the device status data of its collection is all independent storage, analysis; Although or all enter in the historical data base of data acquisition and supervisor control, because data volume is large especially, after being only to get these mass datas from historical data base when Comprehensive analytical equipment Condition Monitoring Data, analyze, analysis efficiency is very low.
Summary of the invention
The object of the present invention is to provide a kind of preprocess method and system of power transmission and transformation equipment state Monitoring Data, can improve the efficiency of analysis state Monitoring Data.
Object of the present invention is achieved through the following technical solutions:
A preprocess method for power transmission and transformation equipment state Monitoring Data, comprises the steps:
Obtain the historic state Monitoring Data of the power transmission and transforming equipment of storing in data acquisition and supervisor control;
According to the data type of described historic state Monitoring Data, described historic state Monitoring Data is divided into historical switching value data, historical simulation amount data;
Described historical switching value data is compressed to the historical switching value data after store compressed;
Choose target measurement period;
Statistics historical simulation amount data corresponding to target measurement period obtain the time of occurrence of maximal value, the minimum value of the analog data that target measurement period is corresponding, described peaked time of occurrence, described minimum value;
The time of occurrence of described maximal value, described minimum value, described peaked time of occurrence, described minimum value is stored with the form of target measurement period characteristic of correspondence data;
Judge whether described maximal value is greater than the first default threshold value, if not, by described the first threshold value, upgrade described maximal value;
Judge whether described minimum value is less than the second default threshold value, if not, by described the second threshold value, upgrade described minimum value;
Calculate the historical switching value data of storage respectively, the hashed value of the characteristic of the measurement period of storage is stored as index by the described hashed value calculating, wherein, described index is for inquiring about Condition Monitoring Data to be analyzed.
A pretreatment system for power transmission and transformation equipment state Monitoring Data, comprising:
Acquisition module, for obtaining the historic state Monitoring Data of the power transmission and transforming equipment that data acquisition and supervisor control store;
Sort module, for being divided into historical switching value data, historical simulation amount data according to the data type of described historic state Monitoring Data by described historic state Monitoring Data;
Compression module, for described historical switching value data is compressed, the historical switching value data after store compressed;
Choose module, for choosing target measurement period;
Statistical module, obtains the time of occurrence of maximal value, the minimum value of the analog data that target measurement period is corresponding, described peaked time of occurrence, described minimum value for adding up historical simulation amount data that target measurement period is corresponding,
Memory module, for the historical switching value data after store compressed, also for the time of occurrence of described maximal value, described minimum value, described peaked time of occurrence, described minimum value is stored with the form of target measurement period characteristic of correspondence data;
First Characteristic is heavily marked module, for judging whether described maximal value is greater than the first default threshold value, if not, by described the first threshold value, upgrades described maximal value;
Second Characteristic is heavily marked module, for judging whether described minimum value is less than the second default threshold value, if not, by described the second threshold value, upgrades described minimum value;
Module set up in index, and for calculating the historical switching value data of storage respectively, the hashed value of the characteristic of the measurement period of storage is stored as index by the described hashed value calculating, wherein, described index is for inquiring about Condition Monitoring Data to be analyzed.
According to the scheme of the invention described above, it is after obtaining historic state Monitoring Data, this historic state Monitoring Data is divided into historical switching value data, historical simulation amount data, described historical switching value data is compressed, and the historical switching value data after store compressed, and after choosing target measurement period, by statistics, obtain the maximal value of the analog data that this target measurement period is corresponding, minimum value, peaked time of occurrence, the time of occurrence of minimum value, again by this maximal value, minimum value, peaked time of occurrence, the time of occurrence of minimum value is stored with the form of target measurement period characteristic of correspondence data, and by whether maximal value being greater than to the first default threshold value compare, the mode that minimum value and the second threshold value of presetting are compared is target-marking measurement period characteristic of correspondence data again, finally calculate the historical switching value data of storage, the hashed value of the characteristic of the measurement period of storage, the described hashed value calculating is stored as to index, wherein, described index is for inquiring about Condition Monitoring Data to be analyzed, due to historic state Monitoring Data is classified, compression, statistics, again marker characteristic, set up the processing such as index, therefore, when carrying out Condition Monitoring Data to analyze, can be based on this index fast query to the data of required analysis and the feature of required analysis data, improved analysis efficiency.
Accompanying drawing explanation
Fig. 1 is the schematic flow sheet of the preprocess method embodiment of power transmission and transformation equipment state Monitoring Data of the present invention;
Fig. 2 is the schematic flow sheet of another embodiment of preprocess method of power transmission and transformation equipment state Monitoring Data of the present invention;
Fig. 3 is the schematic flow sheet of preprocess method the 3rd embodiment of power transmission and transformation equipment state Monitoring Data of the present invention;
Fig. 4 is the structural representation of the pretreatment system embodiment of power transmission and transformation equipment state Monitoring Data of the present invention.
Embodiment
For making object of the present invention, technical scheme and advantage clearer, below in conjunction with drawings and Examples, the present invention is described in further detail.Should be appreciated that embodiment described herein, only in order to explain the present invention, does not limit protection scope of the present invention.
In following explanation, first the embodiment for the preprocess method of power transmission and transformation equipment state Monitoring Data of the present invention describes, then each embodiment of the pretreatment system of power transmission and transformation equipment state Monitoring Data of the present invention is described.
Shown in Figure 1, be the schematic flow sheet of the preprocess method embodiment of power transmission and transformation equipment state Monitoring Data of the present invention.As shown in Figure 1, the preprocess method of the power transmission and transformation equipment state Monitoring Data in the present embodiment comprises the steps:
Step S101: the historic state Monitoring Data of obtaining the power transmission and transforming equipment of storing in data acquisition and supervisor control;
Historic state Monitoring Data can be obtained from gather the database with supervisor control, and the data volume of this historic state Monitoring Data is large, time span is long;
Step S102: described historic state Monitoring Data is divided into historical switching value data, historical simulation amount data according to the data type of described historic state Monitoring Data;
Switching value data is that value is 0 and 1 integer, and analog data refers to real number, is floating point type;
Step S103: described historical switching value data is compressed to the historical switching value data after store compressed;
Therein in an embodiment, the specific implementation process of step S103 can be: obtain described historical switching value data and occur continuously a plurality of identical datas according to time sequencing, determine first data in a plurality of identical datas of described continuous appearance, and the data identical with described first data after described first data are counted to get to data amount check; Using described first data and described data amount check, the historical switching value data after compression is stored, for example, if occur a plurality of 1 continuously according to time sequencing, only store first 1, and to this first 11 counting below, until occur that 0 just stops counting, the scheme in employing the present embodiment, when occurring continuous a large amount of 0 or 1 for switching value data, compression degree is very high; But the mode of compression switch amount data is not limited to the mode in the present embodiment, for example, can also adopt LZW (Lempel Ziv Welch) compression algorithm or Rice compression algorithm, do not repeat them here;
Step S104: choose target measurement period;
Measurement period can be set according to actual needs, can also comprise as required multiple different measurement period, and for example, measurement period comprises year, season, the moon, week, day, chooses a measurement period at every turn and carries out subsequent step as target period;
Step S105: add up the time of occurrence that historical simulation amount data that described target measurement period is corresponding obtain maximal value, the minimum value of the analog data that this target measurement period is corresponding, described peaked time of occurrence, described minimum value;
Can also obtain in historical simulation amount data corresponding to the described target measurement period of statistics the mean value of the historical simulation amount data that this target measurement period is corresponding, variance as required;
Historical simulation amount data can comprise different analog quantitys, for example, comprise voltage and active power, need to add up respectively the time of occurrence of maximal value, the minimum value of voltage and active power, peaked time of occurrence, minimum value;
Target measurement period correspondence a timing statistics scope, can from historical simulation amount data, select the historical simulation amount data within the scope of this timing statistics, then determine the time of occurrence of maximal value, the minimum value of the data of selected taking-up, described peaked time of occurrence, described minimum value;
Step S106: the time of occurrence of described maximal value, described minimum value, described peaked time of occurrence, described minimum value is stored with the form of described target measurement period characteristic of correspondence data;
The maximal value obtaining in step S105 statistics, the time of occurrence of minimum value and described peaked time of occurrence and described minimum value can characterize the feature of the analog data in target measurement period, therefore these data are stored with the form of target measurement period characteristic of correspondence data, if also obtained the mean value of the analog data that target measurement period is corresponding by statistics, variance, also can be by the mean value of analog data corresponding to target measurement period, variance is together with maximal value, the time of occurrence of minimum value and peaked time of occurrence and minimum value is stored with the form of target measurement period characteristic of correspondence data,
Step S107: judge whether described maximal value is greater than the first default threshold value, if not, upgrade described maximal value by described the first threshold value;
In power transmission and transformation equipment state overhauling process, what maintainer was often concerned about is out-of-limit analog data, i.e. the analog data in range ability not, and for this reason, this step S107 is characteristic to having stored marker characteristic again;
If the maximal value of analog data is not more than the first default threshold value in target measurement period, by described the first threshold value, upgrade corresponding maximal value, if carried out peaked renewal, the peaked numerical value that target measurement period is corresponding has just become the numerical value of the first threshold value;
Step S108: judge whether described minimum value is less than the second default threshold value, if not, upgrade described minimum value by described the second threshold value;
This step is to be characteristic to having stored marker characteristic again in order to realize equally;
If the minimum value of analog data is not less than the second default threshold value in target measurement period, by described the second threshold value, upgrade corresponding minimum value, if carried out the renewal of minimum value, the numerical value of the minimum value that current goal measurement period is corresponding has just become the numerical value of the first threshold value;
Can realize the processing of the historic state Monitoring Data of each measurement period (statistics, storage, again marker characteristic etc.) by repeating above-mentioned steps S104～step S109;
Step S109: the calculating hashed value to the measurement period characteristic of correspondence data of historical switching value data, the storage of storage respectively, the described hashed value calculating is stored as to index, wherein, described index is for inquiring about Condition Monitoring Data to be analyzed;
After having stored historical switching value data, can generate a switching value hashed value, in every characteristic of storing a measurement period, for example, the characteristic of aforesaid target measurement period, can generate a new cycle hashed value;
The measurement period of take comprises that year, season, the moon, week, day are example, often obtain the characteristic of a day, correspondence generates day hashed value, often obtain the characteristic of a week, correspondence generates all hashed value, often obtains the characteristic in January, correspondence generates a month hashed value, often obtain the characteristic of a year, correspondence generates year hashed value, and each hashed value is stored as to index;
One preferably in embodiment therein: the calculating hashed value of the mode that can adopt MD5 to the measurement period characteristic of correspondence data of the historical switching value data of storage, storage.
Accordingly, according to scheme in the present embodiment, it is after obtaining historic state Monitoring Data, this historic state Monitoring Data is divided into historical switching value data, historical simulation amount data, described historical switching value data is compressed, and the historical switching value data after store compressed, and after choosing target measurement period, by statistics, obtain the maximal value of the analog data that this target measurement period is corresponding, minimum value, peaked time of occurrence, the time of occurrence of minimum value, again by this maximal value, minimum value, peaked time of occurrence, the time of occurrence of minimum value is stored with the form of target measurement period characteristic of correspondence data, and by whether maximal value being greater than to the first default threshold value compare, the mode that minimum value and the second threshold value of presetting are compared is target-marking measurement period characteristic of correspondence data again, finally calculate the historical switching value data of storage, the hashed value of the characteristic of the measurement period of storage, the described hashed value calculating is stored as to index, wherein, described index is for inquiring about Condition Monitoring Data to be analyzed, due to historic state Monitoring Data is classified, compression, statistics, again marker characteristic, set up the processing such as index, therefore, when carrying out Condition Monitoring Data to analyze, only need a given time query context, just can locate fast the data of required analysis and the feature of required analysis data, improved analysis efficiency.
It should be noted that, said process can be carried out not according to above-mentioned sequencing, and for example, the processing procedure of the processing procedure of historical switching value data and historical simulation amount data can be carried out simultaneously;
Above-described embodiment has been set forth the preprocessing process to historic state Monitoring Data, when having increment Condition Monitoring Data to produce, increment Condition Monitoring Data and above-mentioned historic state Monitoring Data can be updated to historic state Monitoring Data, according to the mode in above-described embodiment, carry out pre-service, can only to increment Condition Monitoring Data, carry out pre-service, owing to only increment Condition Monitoring Data being carried out to pre-service, data processing amount is little, efficiency is high, below increment Condition Monitoring Data is carried out to pretreated process sets forth.
In an embodiment, as shown in Figure 2, on the basis of above-described embodiment, the analytical approach of the power transmission and transformation equipment state Monitoring Data of the present embodiment, can also comprise step therein:
Step S201: obtain increment analog data;
The increment analog data analog data for producing after the pre-service in having carried out as above embodiment, can distinguish according to the time, for example in as above embodiment, completed the pre-service to analog data before sometime, the analog data after this time is increment analog data;
Can first obtain increment Condition Monitoring Data, from the increment Condition Monitoring Data obtaining, obtain increment analog data again, also can directly obtain increment analog data, because analog data is stored in analog data table, can directly from analog data table, obtain;
Step S202: if any one measurement period of measurement period corresponding to the described increment analog data measurement period corresponding with the characteristic of having stored is identical, the described increment analog data maximal value corresponding with the same measurement period of having stored compared, if described increment analog data is greater than the maximal value corresponding to same measurement period of having stored, enter step S203, if described increment analog data is not more than the maximal value corresponding to same measurement period of having stored, enter step S204;
Any one measurement period that measurement period that even described increment analog data is corresponding is corresponding with the characteristic of having stored is identical, carrying out the maximal value that increment analog data is corresponding with this measurement period compares, for example, stored the maximal value of this measurement period in this year,, for the incremental data in this year, need to compare with the maximal value in this year;
Step S203: the maximal value corresponding to same measurement period of having stored by described increment analog quantity Data Update, and upgrade with the time of occurrence of described increment analog data peaked time of occurrence corresponding to same measurement period of having stored;
Step S204: the minimum value that described increment analog data is corresponding with the same measurement period of having stored compares;
Step S205: if described increment analog data is less than the minimum value corresponding to same measurement period of having stored, the minimum value corresponding to same measurement period of having stored by described increment analog quantity Data Update, and with the time of occurrence of described increment analog data, upgrade the time of occurrence of the minimum value that the same measurement period stored is corresponding.
In an embodiment, as shown in Figure 3, on the basis of above-described embodiment, the analytical approach of the power transmission and transformation equipment state Monitoring Data of the present embodiment, can also comprise step therein:
Step 301: if measurement period corresponding to described increment analog data is a new measurement period, described increment analog data and described the first threshold value are compared;
For the situation that comprises multiple measurement period, measurement period corresponding to described increment analog data can be when being measurement period corresponding to the characteristic of having stored, also be a new measurement period, for example, the increment analog data producing this week can when pressing Zhou Zuowei measurement period, be a new measurement period, but to monthly as measurement period time, having can be a measurement period corresponding to characteristic of having stored;
Step 302: if described increment analog data is greater than described the first threshold value, the maximal value using described increment analog data as measurement period corresponding to described increment analog data, if described increment analog data is not more than described the first threshold value, the maximal value using described the first threshold value as measurement period corresponding to described increment analog data;
Step 303: described increment analog data and described the second threshold value are compared;
Step 304: if described increment analog data is less than described the second threshold value, the minimum value using described increment analog data as measurement period corresponding to described increment analog data, if described increment analog data is not less than described the second threshold value, the minimum value using described the second threshold value as measurement period corresponding to described increment analog data;
Step 305: the maximal value of measurement period corresponding to described increment analog data and this peaked time of occurrence, the minimum value of measurement period and the time of occurrence of this minimum value that described increment analog data is corresponding are stored with the characteristic of correspondence data of measurement period corresponding to described increment analog data;
Execute this step, owing to having stored again the characteristic of a measurement period, can go back to step S109, the characteristic computation of characteristic values to the measurement period of this new storage, and correspondingly this eigenwert is stored as to index.
It should be noted that, above-mentioned two embodiment, only set forth the processing to increment analog data, but can not illustrate and not need increment switch amount data to process, as many increment switches of needs amount data are processed, can also comprise compression, storage, generate the processes such as hashed value according to historical switching value data being carried out to processing mode processing in previous embodiment, at this, will not set forth.
According to the pre-service maintaining method of the power transmission and transformation equipment state Monitoring Data of the invention described above, the present invention also provides a kind of pre-service maintenance system of power transmission and transformation equipment state Monitoring Data, below with regard to the embodiment of the pre-service maintenance system of power transmission and transformation equipment state Monitoring Data of the present invention, is elaborated.The structural representation of embodiment of the pre-service maintenance system of power transmission and transformation equipment state Monitoring Data of the present invention has been shown in Fig. 4.For convenience of explanation, in Fig. 4, only show part related to the present invention.
As shown in Figure 4, the pre-service maintenance system of the power transmission and transformation equipment state Monitoring Data in the present embodiment, comprising:
Acquisition module 401, for obtaining the historic state Monitoring Data of the power transmission and transforming equipment that data acquisition and supervisor control store;
Sort module 402, for being divided into historical switching value data, historical simulation amount data according to the data type of described historic state Monitoring Data by described historic state Monitoring Data;
Compression module 403, for described historical switching value data is compressed, the historical switching value data after store compressed;
Choose module 404, for choosing target measurement period;
Statistical module 405, obtains the time of occurrence of maximal value, the minimum value of the analog data that target measurement period is corresponding, described peaked time of occurrence, described minimum value for adding up historical simulation amount data that target measurement period is corresponding,
Memory module 406, for the historical switching value data after store compressed, also for the time of occurrence of described maximal value, described minimum value, described peaked time of occurrence, described minimum value is stored with the form of target measurement period characteristic of correspondence data;
First Characteristic is heavily marked module 407, for judging whether described maximal value is greater than the first default threshold value, if not, by described the first threshold value, upgrades described maximal value;
Second Characteristic is heavily marked module 408, for judging whether described minimum value is less than the second default threshold value, if not, by described the second threshold value, upgrades described minimum value;
Module 409 set up in index, and for calculating the historical switching value data of storage respectively, the hashed value of the characteristic of the measurement period of storage is stored as index by the described hashed value calculating, wherein, described index is for inquiring about Condition Monitoring Data to be analyzed.
Therein in an embodiment, compression module 403 can obtain described historical switching value data and occur continuously a plurality of identical datas according to time sequencing, determine first data in a plurality of identical datas of described continuous appearance, and the data identical with described first data after described first data are counted to get to data amount check; Memory module 406 can the historical switching value data after compression be stored described first data and described data amount check.
In an embodiment, acquisition module 401 can also be for obtaining increment analog data therein;
When statistical module 405 can also be identical for any one measurement period at measurement period corresponding to the described increment analog data measurement period corresponding with the characteristic of having stored, the maximal value that described increment analog data is corresponding with the same measurement period of having stored compares, if described increment analog data is greater than the maximal value corresponding to same measurement period of having stored, the maximal value corresponding to same measurement period of having stored by described increment analog quantity Data Update, and upgrade with the time of occurrence of described increment analog data peaked time of occurrence corresponding to same measurement period of having stored, when described increment analog data is not more than maximal value corresponding to the same measurement period stored, the minimum value that described increment analog data is corresponding with the same measurement period of having stored compares, if described increment analog data is less than the minimum value corresponding to same measurement period of having stored, the minimum value corresponding to same measurement period of having stored by described increment analog quantity Data Update, and with the time of occurrence of described increment analog data, upgrade the time of occurrence of the minimum value that the same measurement period stored is corresponding.
Therein in an embodiment, statistical module 405 can also be when at measurement period corresponding to described increment analog data being a new measurement period, described increment analog data and described the first threshold value are compared, if described increment analog data is greater than described the first threshold value, the maximal value using described increment analog data as measurement period corresponding to described increment analog data, if described increment analog data is not more than described the first threshold value, the maximal value using described the first threshold value as measurement period corresponding to described increment analog data, described increment analog data and described the second threshold value are compared, if described increment analog data is less than described the second threshold value, if the described increment analog data of minimum value using described increment analog data as measurement period corresponding to described increment analog data is not less than described the second threshold value, the minimum value using described the second threshold value as measurement period corresponding to described increment analog data,
Memory module 406 can also be for storing the maximal value of measurement period corresponding to described increment analog data and this peaked time of occurrence, the minimum value of measurement period and the time of occurrence of this minimum value that described increment analog data is corresponding with the characteristic of correspondence data of measurement period corresponding to described increment analog data.
Therein in an embodiment, mode that module 409 can the adopt MD5 calculating hashed value to the measurement period characteristic of correspondence data of the historical switching value data of storage, storage set up in index.
The pre-service maintenance system of power transmission and transformation equipment state Monitoring Data of the present invention is corresponding one by one with the pre-service maintaining method of power transmission and transformation equipment state Monitoring Data of the present invention, in the embodiment of the pre-service maintenance system that the technical characterictic of setting forth at the embodiment of the pre-service maintaining method of above-mentioned power transmission and transformation equipment state Monitoring Data and beneficial effect thereof are all applicable to power transmission and transformation equipment state Monitoring Data, statement hereby.
The above embodiment has only expressed several embodiment of the present invention, and it describes comparatively concrete and detailed, but can not therefore be interpreted as the threshold value to the scope of the claims of the present invention.It should be pointed out that for the person of ordinary skill of the art, without departing from the inventive concept of the premise, can also make some distortion and improvement, these all belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be as the criterion with claims.
Claims (10)
1. a preprocess method for power transmission and transformation equipment state Monitoring Data, is characterized in that, comprises the steps:
Obtain the historic state Monitoring Data of the power transmission and transforming equipment of storing in data acquisition and supervisor control;
According to the data type of described historic state Monitoring Data, described historic state Monitoring Data is divided into historical switching value data, historical simulation amount data;
Described historical switching value data is compressed to the historical switching value data after store compressed;
Choose target measurement period;
Statistics historical simulation amount data corresponding to target measurement period obtain the time of occurrence of maximal value, the minimum value of the analog data that target measurement period is corresponding, described peaked time of occurrence, described minimum value;
The time of occurrence of described maximal value, described minimum value, described peaked time of occurrence, described minimum value is stored with the form of target measurement period characteristic of correspondence data;
Judge whether described maximal value is greater than the first default threshold value, if not, by described the first threshold value, upgrade described maximal value;
Judge whether described minimum value is less than the second default threshold value, if not, by described the second threshold value, upgrade described minimum value;
Calculate the historical switching value data of storage respectively, the hashed value of the characteristic of the measurement period of storage is stored as index by the described hashed value calculating, wherein, described index is for inquiring about Condition Monitoring Data to be analyzed.
2. the analytical approach of power transmission and transformation equipment state Monitoring Data according to claim 1, is characterized in that, described described historical switching value data is compressed, and the historical switching value data after store compressed comprises step:
Obtain described historical switching value data and occur continuously a plurality of identical datas according to time sequencing;
Determine first data in a plurality of identical datas of described continuous appearance, and the data identical with described first data after described first data are counted to get to data amount check;
Using described first data and described data amount check, the historical switching value data after compression is stored.
3. the analytical approach of power transmission and transformation equipment state Monitoring Data according to claim 1, is characterized in that, also comprises step:
Obtain increment analog data;
If the measurement period that described increment analog data is corresponding is identical with any one measurement period in measurement period corresponding to the characteristic of having stored, the described increment analog data maximal value corresponding with the same measurement period of having stored compared;
If described increment analog data is greater than the maximal value corresponding to same measurement period of having stored, the maximal value corresponding to same measurement period of having stored by described increment analog quantity Data Update, and upgrade with the time of occurrence of described increment analog data peaked time of occurrence corresponding to same measurement period of having stored;
If described increment analog data is not more than the maximal value corresponding to same measurement period of having stored, the described increment analog data minimum value corresponding with the same measurement period of having stored compared;
If described increment analog data is less than the minimum value corresponding to same measurement period of having stored, the minimum value corresponding to same measurement period of having stored by described increment analog quantity Data Update, and with the time of occurrence of described increment analog data, upgrade the time of occurrence of the minimum value that the same measurement period stored is corresponding.
4. the analytical approach of power transmission and transformation equipment state Monitoring Data according to claim 3, is characterized in that, also comprises step:
If the measurement period that described increment analog data is corresponding is a new measurement period, described increment analog data and described the first threshold value are compared;
If described increment analog data is greater than described the first threshold value, the maximal value using described increment analog data as measurement period corresponding to described increment analog data, if described increment analog data is not more than described the first threshold value, the maximal value using described the first threshold value as measurement period corresponding to described increment analog data;
Described increment analog data and described the second threshold value are compared;
If described increment analog data is less than described the second threshold value, if the described increment analog data of minimum value using described increment analog data as measurement period corresponding to described increment analog data is not less than described the second threshold value, the minimum value using described the second threshold value as measurement period corresponding to described increment analog data;
The maximal value of measurement period corresponding to described increment analog data and this peaked time of occurrence, the minimum value of measurement period and the time of occurrence of this minimum value that described increment analog data is corresponding are stored with the characteristic of correspondence data of measurement period corresponding to described increment analog data.
5. the analytical approach of power transmission and transformation equipment state Monitoring Data according to claim 1, the calculating hashed value of the mode that it is characterized in that adopting MD5 to the measurement period characteristic of correspondence data of the historical switching value data of storage, storage.
6. a pretreatment system for power transmission and transformation equipment state Monitoring Data, is characterized in that, comprising:
Acquisition module, for obtaining the historic state Monitoring Data of the power transmission and transforming equipment that data acquisition and supervisor control store;
Sort module, for being divided into historical switching value data, historical simulation amount data according to the data type of described historic state Monitoring Data by described historic state Monitoring Data;
Compression module, for described historical switching value data is compressed, the historical switching value data after store compressed;
Choose module, for choosing target measurement period;
Statistical module, obtains the time of occurrence of maximal value, the minimum value of the analog data that target measurement period is corresponding, described peaked time of occurrence, described minimum value for adding up historical simulation amount data that target measurement period is corresponding,
Memory module, for the historical switching value data after store compressed, also for the time of occurrence of described maximal value, described minimum value, described peaked time of occurrence, described minimum value is stored with the form of target measurement period characteristic of correspondence data;
First Characteristic is heavily marked module, for judging whether described maximal value is greater than the first default threshold value, if not, by described the first threshold value, upgrades described maximal value;
Second Characteristic is heavily marked module, for judging whether described minimum value is less than the second default threshold value, if not, by described the second threshold value, upgrades described minimum value;
Module set up in index, and for calculating the historical switching value data of storage respectively, the hashed value of the characteristic of the measurement period of storage is stored as index by the described hashed value calculating, wherein, described index is for inquiring about Condition Monitoring Data to be analyzed.
7. the analytic system of power transmission and transformation equipment state Monitoring Data according to claim 6, is characterized in that:
Described compression module obtains described historical switching value data and occurs continuously a plurality of identical datas according to time sequencing, determine first data in a plurality of identical datas of described continuous appearance, and the data identical with described first data after described first data are counted to get to data amount check;
Described memory module using described first data and described data amount check the historical switching value data after compression store.
8. the analytic system of power transmission and transformation equipment state Monitoring Data according to claim 6, is characterized in that:
Described acquisition module is also for obtaining increment analog data;
When described statistical module is also identical for any one measurement period at measurement period corresponding to the described increment analog data measurement period corresponding with the characteristic of having stored, the maximal value that described increment analog data is corresponding with the same measurement period of having stored compares, if described increment analog data is greater than the maximal value corresponding to same measurement period of having stored, the maximal value corresponding to same measurement period of having stored by described increment analog quantity Data Update, and upgrade with the time of occurrence of described increment analog data peaked time of occurrence corresponding to same measurement period of having stored, when described increment analog data is not more than maximal value corresponding to the same measurement period stored, the minimum value that described increment analog data is corresponding with the same measurement period of having stored compares, if described increment analog data is less than the minimum value corresponding to same measurement period of having stored, the minimum value corresponding to same measurement period of having stored by described increment analog quantity Data Update, and with the time of occurrence of described increment analog data, upgrade the time of occurrence of the minimum value that the same measurement period stored is corresponding.
9. the analytic system of power transmission and transformation equipment state Monitoring Data according to claim 8, is characterized in that:
Described statistical module is also when at measurement period corresponding to described increment analog data being a new measurement period, described increment analog data and described the first threshold value are compared, if described increment analog data is greater than described the first threshold value, the maximal value using described increment analog data as measurement period corresponding to described increment analog data, if described increment analog data is not more than described the first threshold value, the maximal value using described the first threshold value as measurement period corresponding to described increment analog data, described increment analog data and described the second threshold value are compared, if described increment analog data is less than described the second threshold value, if the described increment analog data of minimum value using described increment analog data as measurement period corresponding to described increment analog data is not less than described the second threshold value, the minimum value using described the second threshold value as measurement period corresponding to described increment analog data,
Described memory module is also for storing the maximal value of measurement period corresponding to described increment analog data and this peaked time of occurrence, the minimum value of measurement period and the time of occurrence of this minimum value that described increment analog data is corresponding with the characteristic of correspondence data of measurement period corresponding to described increment analog data.
10. the analytic system of power transmission and transformation equipment state Monitoring Data according to claim 6, is characterized in that:
Mode that module the adopts MD5 calculating hashed value to the measurement period characteristic of correspondence data of the historical switching value data of storage, storage set up in described index.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410245050.6A CN104050246B (en) | 2014-06-04 | 2014-06-04 | The preprocess method of power transmission and transformation equipment state Monitoring Data and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410245050.6A CN104050246B (en) | 2014-06-04 | 2014-06-04 | The preprocess method of power transmission and transformation equipment state Monitoring Data and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104050246A true CN104050246A (en) | 2014-09-17 |
| CN104050246B CN104050246B (en) | 2016-06-08 |
Family
ID=51503078
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410245050.6A Active CN104050246B (en) | 2014-06-04 | 2014-06-04 | The preprocess method of power transmission and transformation equipment state Monitoring Data and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104050246B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107765617A (en) * | 2016-08-19 | 2018-03-06 | 中车株洲电力机车研究所有限公司 | train axle temperature data processing method and device |
| CN110174174A (en) * | 2019-05-28 | 2019-08-27 | 广东电网有限责任公司 | Detection terminal and its application method based on infrared heat and visual light imaging |
| CN112885065A (en) * | 2021-01-14 | 2021-06-01 | 武汉宏佳启元科技有限公司 | Data transmission processing method |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101976248A (en) * | 2010-10-15 | 2011-02-16 | 陕西电力科学研究院 | Method for rapidly identifying environmental risk of power transmission and transformation project |
| WO2011156080A1 (en) * | 2010-06-09 | 2011-12-15 | Siemens Corporation | Systems and methods for learning of normal sensor signatures, condition monitoring and diagnosis |
| CN102685221A (en) * | 2012-04-29 | 2012-09-19 | 华北电力大学（保定） | Distributed storage and parallel mining method for state monitoring data |
| CN203587709U (en) * | 2013-08-20 | 2014-05-07 | 国家电网公司 | Intelligent transformer station integrated monitoring system |
-
2014
- 2014-06-04 CN CN201410245050.6A patent/CN104050246B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2011156080A1 (en) * | 2010-06-09 | 2011-12-15 | Siemens Corporation | Systems and methods for learning of normal sensor signatures, condition monitoring and diagnosis |
| CN101976248A (en) * | 2010-10-15 | 2011-02-16 | 陕西电力科学研究院 | Method for rapidly identifying environmental risk of power transmission and transformation project |
| CN102685221A (en) * | 2012-04-29 | 2012-09-19 | 华北电力大学（保定） | Distributed storage and parallel mining method for state monitoring data |
| CN203587709U (en) * | 2013-08-20 | 2014-05-07 | 国家电网公司 | Intelligent transformer station integrated monitoring system |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107765617A (en) * | 2016-08-19 | 2018-03-06 | 中车株洲电力机车研究所有限公司 | train axle temperature data processing method and device |
| CN107765617B (en) * | 2016-08-19 | 2020-05-08 | 中车株洲电力机车研究所有限公司 | Train axle temperature data processing method and device |
| CN110174174A (en) * | 2019-05-28 | 2019-08-27 | 广东电网有限责任公司 | Detection terminal and its application method based on infrared heat and visual light imaging |
| CN112885065A (en) * | 2021-01-14 | 2021-06-01 | 武汉宏佳启元科技有限公司 | Data transmission processing method |
| CN112885065B (en) * | 2021-01-14 | 2023-05-23 | 武汉宏佳启元科技有限公司 | Data transmission processing method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104050246B (en) | 2016-06-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111368890A (en) | Fault detection method and device and information physical fusion system | |
| CN103413188B (en) | A kind of monthly industrial power predicating method based on industry Business Process System | |
| CN104050246A (en) | Pre-processing method and system for state monitoring data of electric transmission and transformation equipment | |
| CN103887792B (en) | A kind of low-voltage distribution network modeling method containing distributed power source | |
| CN111861023A (en) | Statistical-based hybrid wind power prediction method and device | |
| US20220245096A1 (en) | Method and device for facilitating storage of data from an industrial automation control system or power system | |
| CN103809550B (en) | Cost-saving electric power energy management device and method | |
| CN111179108A (en) | Method and device for predicting power consumption | |
| CN108154259B (en) | Load prediction method and device for heat pump, storage medium, and processor | |
| CN104573858A (en) | Prediction, regulation and control method for electric network loads | |
| CN111798066A (en) | Multi-dimensional prediction method and system for cell flow under urban scale | |
| Wiest et al. | Synthetic Load Profiles of Various Customer Types for Smart Grid Simulations | |
| Ivanov et al. | Intelligent monitoring and control in transmission and distribution networks | |
| CN102981071A (en) | Electrical power system major parameter monitoring method supplied for electric network management automation system | |
| CN116402187A (en) | Enterprise pollution discharge prediction method based on power big data | |
| CN105021888A (en) | Harmonic wave data monitoring method based on data clustering | |
| CN105021876A (en) | Electric current monitoring instrument and electric current monitoring system | |
| CN112926777B (en) | Day-ahead load prediction method and system considering commercial building energy consumption behaviors | |
| CN115034472A (en) | Distributed photovoltaic operation intelligent prediction management system | |
| CN111832805A (en) | Economic early warning analysis system and method based on electric power big data | |
| CN102946394A (en) | Oscillation waveform characteristic based method for compression, transmission and reconfiguration of power grid dynamic process data in supervisory control and data acquisition (SCADA) system | |
| CN113033821A (en) | Load identification machine learning system applied to algorithm core unit | |
| CN108123436B (en) | Voltage out-of-limit prediction model based on principal component analysis and multiple regression algorithm | |
| CN105205627A (en) | Power grid electric power operation project determination method and system | |
| CN111612232A (en) | Power distribution network line re-jump probability prediction optimization method and device based on gradient descent |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C53 | Correction of patent of invention or patent application | ||
| CB02 | Change of applicant information |
Address after: 525000 Guangdong Province, Maoming City, Guan Shan Road, No. four, No. 2 Applicant after: MAOMING POWER SUPPLY BUREAU, GUANGDONG POWER GRID CO., LTD. Address before: 525000 Guangdong Province, Maoming City, Guan Shan Road, No. four, No. 2 Applicant before: Maoming Power Supply Bureau, Guangdong Grid Co., Ltd. |
|
| COR | Change of bibliographic data |
Free format text: CORRECT: APPLICANT; FROM: MAOMING POWER SUPPLY BUREAU OF GUANGDONG POWER GRID CORPORATION TO: GUANGDONG POWER GRID COMPANY MAOMING POWER SUPPLY BUREAU |
|
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |