CN111639141A - Data testing method and device and computer terminal - Google Patents
Data testing method and device and computer terminal Download PDFInfo
- Publication number
- CN111639141A CN111639141A CN202010455352.1A CN202010455352A CN111639141A CN 111639141 A CN111639141 A CN 111639141A CN 202010455352 A CN202010455352 A CN 202010455352A CN 111639141 A CN111639141 A CN 111639141A
- Authority
- CN
- China
- Prior art keywords
- data
- parameter
- transformer substation
- substation operation
- operation data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
-
- 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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- 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/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2477—Temporal data queries
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Supply And Distribution Of Alternating Current (AREA)
Abstract
The invention discloses a data testing method, a device and a computer terminal, which are characterized by firstly extracting a data label sequence of transformer substation operation data after the transformer substation operation data is collected and determining a plurality of groups of operation parameter sections, secondly comparing each group of operation parameter sections of the transformer substation operation data with each reference parameter section in a preset parameter set to obtain a comparison result, then determining a data state track of the transformer substation operation data according to the parameter characteristics corresponding to a target operation parameter section of which the comparison result accords with the transformer substation state stability condition, and finally testing equipment loss data of the transformer substation to obtain a test result based on the transformer substation operation data and the determined data state track of the transformer substation operation data. Therefore, the accuracy and the reliability of the transformer substation operation data test can be improved, and whether the transformer substation breaks down or not can be accurately and reliably detected.
Description
Technical Field
The disclosure relates to the technical field of data processing of transformer substations, in particular to a data testing method and device and a computer terminal.
Background
With the development of science and technology, the types and the number of electric equipment are more and more, and the load demand of the electric equipment faced by a power grid is higher and higher. In this case, an operation failure may occur in the power grid during operation, thereby causing a production accident. In the operation process of the power grid, the operation state of the substation is directly related to the safe and reliable operation of the power grid, and in order to monitor the operation state of the power grid, the operation data of the substation needs to be tested in real time, so that whether the substation breaks down or not is detected. However, in practical application, the method for performing data testing on the transformer substation has poor accuracy and reliability.
Disclosure of Invention
In order to solve the technical problems in the related art, the present disclosure provides a data testing method, an apparatus and a computer terminal.
A data testing method is applied to a computer terminal communicated with a transformer substation, and comprises the following steps:
after transformer substation operation data stored in the transformer substation in real time are collected, extracting a data tag sequence of the transformer substation operation data, and performing data segmentation processing on the transformer substation operation data based on the data tag sequence to obtain a plurality of groups of operation parameter sections; the data tag sequence is a sequence formed by device tags related to target electric equipment in the substation operation data;
comparing each group of operation parameter sections of the transformer substation operation data with each reference parameter section in a preset parameter set; a plurality of groups of reference parameter sections and parameter weights corresponding to each group of reference parameter sections are stored in the preset parameter set, and the plurality of groups of reference parameter sections are state parameter sets of a power grid area where the target electric equipment is located; if each group of extracted operation parameter sections of the substation operation data comprises a plurality of parameter weights, comparing the extracted operation parameter sections in the following mode: performing multi-stage comparison according to the priorities preset for the parameter weights; in each stage of comparison, comparison is carried out only based on one parameter weight in each group of operation parameter sections, and the operation parameter sections meeting preset conditions are input into a next stage of comparison thread so as to carry out comparison based on the next parameter weight;
determining a data state track of the transformer substation operation data according to the parameter characteristics corresponding to the target operation parameter section of which the comparison result with the transformer substation operation data conforms to the transformer substation state stability condition;
testing the equipment loss data of the transformer substation based on the transformer substation operation data and the determined data state track of the transformer substation operation data to obtain a test result; and the test result is used for representing the probability of the fault of the transformer substation in a set time period.
Optionally, the extracting a data tag sequence of the substation operation data, and performing data segmentation processing on the substation operation data based on the data tag sequence to obtain multiple sets of operation parameter sections includes:
listing data labels in the transformer substation operation data, determining the label weight of each data label, and sequencing the data labels according to the label weight from large to small to obtain a data label sequence;
acquiring a sequence track of the data label sequence and a plurality of data sets of the transformer substation operation data; under the condition that the redundant data packet is determined to be contained in the substation operation data according to the sequence track, permission contrast between each data set of the substation operation data under the effective data packet and each data set of the substation operation data under the redundant data packet is determined according to the data sets of the substation operation data under the redundant data packet and permission information thereof; adjusting the data set with the minimum authority contrast of the substation operation data under the effective data packet and the data set under the redundant data packet to the redundant data packet;
under the condition that the effective data packet corresponding to the transformer substation operation data comprises a plurality of data sets, determining authority contrast among the data sets of the transformer substation operation data under the effective data packet according to the data sets of the transformer substation operation data under the redundant data packet and authority information of the transformer substation operation data, and splicing the data sets under the effective data packet based on the authority contrast among the data sets; setting an adjustment priority for a target data set obtained by splicing according to a data set of the transformer substation operation data under the redundant data packet and authority information thereof, and adjusting the target data set to a set position of the redundant data packet corresponding to the adjustment priority;
and carrying out segmentation processing on the data set under the effective data grouping based on the node attribute of the target node with the segment identifier corresponding to the sequence track in the data label sequence to obtain a plurality of groups of operation parameter sections.
Optionally, determining a data state trajectory of the substation operation data according to a parameter characteristic corresponding to a target operation parameter segment whose comparison result with the substation operation data conforms to a substation state stability condition includes:
extracting a state evaluation coefficient of the comparison result, and determining a target operation parameter section corresponding to the state evaluation coefficient when the state evaluation coefficient reaches a preset state coefficient of the transformer substation;
extracting the time sequence characteristics of the target operation parameter section according to the set time step;
generating a time sequence form corresponding to the time sequence characteristics and a parameter form corresponding to a target operation parameter section, wherein the time sequence form and the parameter form respectively comprise a plurality of form objects with different form weights;
extracting object attribute information of the time sequence feature in one table object of the time sequence form and determining the table object with the minimum form weight in the parameter form as a reference table object;
mapping the object attribute information to the reference table object to obtain mapping attribute information in the reference table object, and then generating a state switching list between the time sequence characteristic and the target operation parameter section based on the object attribute information and the mapping attribute information;
acquiring object track information in the reference table object by taking the mapping attribute information as an information template, mapping the object track information to the table object where the object attribute information is located according to the logic information corresponding to the state switching list, and obtaining the mapping track information corresponding to the object track information in the table object where the object attribute information is located;
and listing the track nodes and the connecting line information in the mapping track information and generating the data state track of the transformer substation operation data according to the track nodes and the connecting line information.
Optionally, the step of testing the equipment loss data of the substation based on the substation operation data and the determined data state trajectory of the substation operation data to obtain a test result includes:
determining a loss coefficient corresponding to the equipment loss data determined based on the substation operation data and the data state track, and weighting the equipment loss data by adopting the loss coefficient to obtain target loss data;
for current loss data in the target loss data, determining an update weight value of the current loss data in a preset time interval based on a first update frequency of the current loss data in the preset time interval and a second update frequency of each target loss data in the preset time interval;
and determining an update risk coefficient of the current loss data between two adjacent set time periods according to the update weight values of the current loss data in two adjacent preset time period intervals, and performing normalization processing on the update risk coefficient to obtain the test result.
A data testing device for use with a computer terminal in communication with a substation, the device comprising:
the data segmentation module is used for extracting a data label sequence of the transformer substation operation data after the transformer substation operation data stored in the transformer substation in real time is acquired, and performing data segmentation processing on the transformer substation operation data based on the data label sequence to obtain a plurality of groups of operation parameter sections; the data tag sequence is a sequence formed by device tags related to target electric equipment in the substation operation data;
the parameter comparison module is used for comparing each group of operation parameter sections of the transformer substation operation data with each reference parameter section in a preset parameter set; a plurality of groups of reference parameter sections and parameter weights corresponding to each group of reference parameter sections are stored in the preset parameter set, and the plurality of groups of reference parameter sections are state parameter sets of a power grid area where the target electric equipment is located; if each group of extracted operation parameter sections of the substation operation data comprises a plurality of parameter weights, comparing the extracted operation parameter sections in the following mode: performing multi-stage comparison according to the priorities preset for the parameter weights; in each stage of comparison, comparison is carried out only based on one parameter weight in each group of operation parameter sections, and the operation parameter sections meeting preset conditions are input into a next stage of comparison thread so as to carry out comparison based on the next parameter weight;
the trajectory determination module is used for determining a data state trajectory of the transformer substation operation data according to the parameter characteristics corresponding to the target operation parameter section of which the comparison result of the transformer substation operation data conforms to the transformer substation state stability condition;
the data testing module is used for testing the equipment loss data of the transformer substation based on the transformer substation operation data and the determined data state track of the transformer substation operation data to obtain a testing result; and the test result is used for representing the probability of the fault of the transformer substation in a set time period.
Optionally, the data segmentation module is configured to:
listing data labels in the transformer substation operation data, determining the label weight of each data label, and sequencing the data labels according to the label weight from large to small to obtain a data label sequence;
acquiring a sequence track of the data label sequence and a plurality of data sets of the transformer substation operation data; under the condition that the redundant data packet is determined to be contained in the substation operation data according to the sequence track, permission contrast between each data set of the substation operation data under the effective data packet and each data set of the substation operation data under the redundant data packet is determined according to the data sets of the substation operation data under the redundant data packet and permission information thereof; adjusting the data set with the minimum authority contrast of the substation operation data under the effective data packet and the data set under the redundant data packet to the redundant data packet;
under the condition that the effective data packet corresponding to the transformer substation operation data comprises a plurality of data sets, determining authority contrast among the data sets of the transformer substation operation data under the effective data packet according to the data sets of the transformer substation operation data under the redundant data packet and authority information of the transformer substation operation data, and splicing the data sets under the effective data packet based on the authority contrast among the data sets; setting an adjustment priority for a target data set obtained by splicing according to a data set of the transformer substation operation data under the redundant data packet and authority information thereof, and adjusting the target data set to a set position of the redundant data packet corresponding to the adjustment priority;
and carrying out segmentation processing on the data set under the effective data grouping based on the node attribute of the target node with the segment identifier corresponding to the sequence track in the data label sequence to obtain a plurality of groups of operation parameter sections.
Optionally, the trajectory determination module is configured to:
extracting a state evaluation coefficient of the comparison result, and determining a target operation parameter section corresponding to the state evaluation coefficient when the state evaluation coefficient reaches a preset state coefficient of the transformer substation;
extracting the time sequence characteristics of the target operation parameter section according to the set time step;
generating a time sequence form corresponding to the time sequence characteristics and a parameter form corresponding to a target operation parameter section, wherein the time sequence form and the parameter form respectively comprise a plurality of form objects with different form weights;
extracting object attribute information of the time sequence feature in one table object of the time sequence form and determining the table object with the minimum form weight in the parameter form as a reference table object;
mapping the object attribute information to the reference table object to obtain mapping attribute information in the reference table object, and then generating a state switching list between the time sequence characteristic and the target operation parameter section based on the object attribute information and the mapping attribute information;
acquiring object track information in the reference table object by taking the mapping attribute information as an information template, mapping the object track information to the table object where the object attribute information is located according to the logic information corresponding to the state switching list, and obtaining the mapping track information corresponding to the object track information in the table object where the object attribute information is located;
and listing the track nodes and the connecting line information in the mapping track information and generating the data state track of the transformer substation operation data according to the track nodes and the connecting line information.
Optionally, the data testing module is configured to:
determining a loss coefficient corresponding to the equipment loss data determined based on the substation operation data and the data state track, and weighting the equipment loss data by adopting the loss coefficient to obtain target loss data;
for current loss data in the target loss data, determining an update weight value of the current loss data in a preset time interval based on a first update frequency of the current loss data in the preset time interval and a second update frequency of each target loss data in the preset time interval;
and determining an update risk coefficient of the current loss data between two adjacent set time periods according to the update weight values of the current loss data in two adjacent preset time period intervals, and performing normalization processing on the update risk coefficient to obtain the test result.
A computer terminal comprising a processor and a memory in communication with each other, the processor being adapted to retrieve a computer program from the memory, the computer program being executable to perform the method as described above.
A computer-readable storage medium, on which a computer program is stored which, when executed, implements the above-described method.
According to the technical scheme provided by the embodiment of the disclosure, firstly, after the operation data of the transformer substation is collected, a data label sequence of the operation data of the transformer substation is extracted, a plurality of groups of operation parameter sections are determined, secondly, each group of operation parameter sections of the operation data of the transformer substation is compared with each reference parameter section in a preset parameter set to obtain a comparison result, then, a data state track of the operation data of the transformer substation is determined according to parameter characteristics corresponding to a target operation parameter section of which the comparison result accords with a stable condition of the state of the transformer substation, and finally, the equipment loss data of the transformer substation is tested based on the operation data of the transformer substation and the determined data state track of the operation data of. Therefore, the accuracy and the reliability of the transformer substation operation data test can be improved, and whether the transformer substation breaks down or not can be accurately and reliably detected.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the invention and together with the description, serve to explain the principles of the invention.
FIG. 1 is a schematic diagram of a data testing system according to the present disclosure.
FIG. 2 is a flow chart illustrating a method of data testing according to an exemplary embodiment.
FIG. 3 is a block diagram illustrating a data testing device according to an exemplary embodiment.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present application. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the present application, as detailed in the appended claims.
In order to solve the technical problems of poor accuracy and reliability of a method for testing data of a transformer substation in the prior art, the embodiment of the invention provides a data testing method, a data testing device and a computer terminal.
Referring to fig. 1, a block diagram of a data testing system 100 according to an embodiment of the present invention is shown, where the data testing system 100 may include a computer terminal 200 and a substation 300, the computer terminal is in communication with the substation 300, the substation 300 is connected to a power grid power line in a target area, and the substation 300 is configured to perform power utilization interaction with a power device in the target area through the power grid power line.
Referring to fig. 2, a flowchart of a data testing method according to an embodiment of the present invention is shown, where the data testing method can be applied to the computer terminal 200 in fig. 1, and specifically includes the following steps to describe an apparatus tag.
Step 220, comparing each group of operation parameter sections of the transformer substation operation data with each reference parameter section in a preset parameter set; a plurality of groups of reference parameter sections and parameter weights corresponding to each group of reference parameter sections are stored in the preset parameter set, and the plurality of groups of reference parameter sections are state parameter sets of a power grid area where the target electric equipment is located; if each group of extracted operation parameter sections of the substation operation data comprises a plurality of parameter weights, comparing the extracted operation parameter sections in the following mode: performing multi-stage comparison according to the priorities preset for the parameter weights; in each stage of comparison, comparison is carried out only based on one parameter weight in each group of operation parameter sections, and the operation parameter sections meeting preset conditions are input into a next stage of comparison thread so as to carry out comparison based on the next parameter weight.
And 230, determining the data state track of the transformer substation operation data according to the parameter characteristics corresponding to the target operation parameter section of which the comparison result of the transformer substation operation data conforms to the transformer substation state stability condition.
Step 240, testing the equipment loss data of the transformer substation based on the transformer substation operation data and the determined data state track of the transformer substation operation data to obtain a test result; and the test result is used for representing the probability of the fault of the transformer substation in a set time period.
When the method described in the steps S210 to S240 is applied, firstly, after the transformer substation operation data is acquired, the data tag sequence of the transformer substation operation data is extracted and a plurality of sets of operation parameter sections are determined, secondly, each set of operation parameter section of the transformer substation operation data is compared with each reference parameter section in a preset parameter set to obtain a comparison result, secondly, the data state trajectory of the transformer substation operation data is determined according to the parameter characteristics corresponding to the target operation parameter section of which the comparison result meets the transformer substation state stability condition, and finally, the equipment loss data of the transformer substation is tested based on the transformer substation operation data and the determined data state trajectory of the transformer substation operation data to obtain a test result. Therefore, the accuracy and the reliability of the transformer substation operation data test can be improved, and whether the transformer substation breaks down or not can be accurately and reliably detected.
In an alternative embodiment, in order to accurately perform data segmentation on the substation operation data, in step S210, a data tag sequence of the substation operation data is extracted, and data segmentation processing is performed on the substation operation data based on the data tag sequence to obtain multiple sets of operation parameter segments, which may specifically include the contents described in the following steps.
Step S211, listing the data tags in the substation operation data, determining the tag weight of each data tag, and sequencing the data tags according to the tag weight from large to small to obtain the data tag sequence.
Step S212, acquiring a sequence track of the data label sequence and a plurality of data sets of the transformer substation operation data; under the condition that the redundant data packet is determined to be contained in the substation operation data according to the sequence track, permission contrast between each data set of the substation operation data under the effective data packet and each data set of the substation operation data under the redundant data packet is determined according to the data sets of the substation operation data under the redundant data packet and permission information thereof; and adjusting the data set with the minimum authority contrast of the substation operation data under the effective data packet and the data set under the redundant data packet to the redundant data packet.
Step S213, determining authority contrast between the data sets of the transformer substation operation data under the effective data grouping according to the data sets of the transformer substation operation data under the redundant data grouping and authority information thereof under the condition that the effective data grouping corresponding to the transformer substation operation data comprises a plurality of data sets, and splicing the data sets under the effective data grouping based on the authority contrast between the data sets; setting an adjustment priority for a target data set obtained by splicing according to the data set of the transformer substation operation data under the redundant data packet and the authority information thereof, and adjusting the target data set to a set position of the redundant data packet corresponding to the adjustment priority.
Step S214, based on the node attributes of the target nodes having segment identifications corresponding to the sequence tracks in the data label sequence, performing segment processing on the data set under the effective data grouping to obtain multiple groups of operation parameter segments.
It can be understood that, through the above steps S211 to S214, the data sets under the valid data packets and the redundant data packets of the substation operation data can be adjusted and updated, so that the data sets under the valid data packets can be segmented and processed to obtain multiple sets of operation parameter segments based on the node attributes of the target nodes having segment identifiers corresponding to the sequence tracks in the data label sequence, thereby accurately performing data segmentation on the substation operation data.
In an alternative embodiment, in order to ensure continuity of the data state trajectory and avoid fault occurrence of the data state trajectory, in step S230, the data state trajectory of the substation operation data is determined according to the parameter characteristics corresponding to the target operation parameter section in which the comparison result of the substation operation data meets the substation state stability condition, which may specifically include the content described in the following steps.
And S231, extracting the state evaluation coefficient of the comparison result, and determining a target operation parameter section corresponding to the state evaluation coefficient when the state evaluation coefficient reaches a preset state coefficient of the transformer substation.
And step S232, extracting the time sequence characteristics of the target operation parameter section according to the set time step.
Step S233, a time sequence form corresponding to the time sequence feature and a parameter form corresponding to the target operation parameter section are generated, where the time sequence form and the parameter form respectively include a plurality of form objects with different form weights.
Step S234, extracting object attribute information of one table object of the time sequence feature in the time sequence form, and determining the table object with the minimum form weight in the parameter form as a reference table object.
Step S235, mapping the object attribute information to the reference table object to obtain mapping attribute information in the reference table object, and then generating a state switching list between the time sequence feature and the target operation parameter section based on the object attribute information and the mapping attribute information.
Step S236, obtaining object track information in the reference table object by using the mapping attribute information as an information template, mapping the object track information to the table object in which the object attribute information is located according to the logic information corresponding to the state switching list, and obtaining the mapping track information corresponding to the object track information in the table object in which the object attribute information is located.
Step S237, listing the track nodes and the connection information in the mapping track information, and generating the data state track of the substation operation data according to the track nodes and the connection information.
It can be understood that, through the contents described in the above steps S231 to S237, the continuity of the data state trajectory can be ensured, and the data state trajectory can be prevented from being broken.
In specific implementation, in order to ensure the accuracy and reliability of the test result, in step S240, the device loss data of the substation is tested based on the substation operation data and the determined data state trajectory of the substation operation data to obtain the test result, which may specifically include the contents described in the following steps.
Step S241, determining a loss coefficient corresponding to the equipment loss data determined based on the substation operation data and the data state track, and weighting the equipment loss data by adopting the loss coefficient to obtain target loss data.
Step S242, for current loss data in the target loss data, determining an update weight value of the current loss data in a preset time interval based on a first update frequency of the current loss data in the preset time interval and a second update frequency of each target loss data in the preset time interval.
Step S243, determining an update risk coefficient of the current loss data between two adjacent set time periods according to the update weight values of the current loss data in two adjacent preset time period intervals, and performing normalization processing on the update risk coefficient to obtain the test result.
Through the contents described in the above steps S241 to S243, the accuracy and reliability of the test result can be ensured.
Referring to fig. 3, a data testing apparatus 210 is provided, which is applied to a computer terminal communicating with a substation, the apparatus 210 includes:
the data segmentation module 211 is configured to extract a data tag sequence of the substation operation data after the substation operation data stored in the substation in real time is acquired, and perform data segmentation processing on the substation operation data based on the data tag sequence to obtain multiple sets of operation parameter sections; the data tag sequence is a sequence formed by device tags related to target electric equipment in the substation operation data;
the parameter comparison module 212 is configured to compare each group of operation parameter sections of the substation operation data with each reference parameter section in a preset parameter set; a plurality of groups of reference parameter sections and parameter weights corresponding to each group of reference parameter sections are stored in the preset parameter set, and the plurality of groups of reference parameter sections are state parameter sets of a power grid area where the target electric equipment is located; if each group of extracted operation parameter sections of the substation operation data comprises a plurality of parameter weights, comparing the extracted operation parameter sections in the following mode: performing multi-stage comparison according to the priorities preset for the parameter weights; in each stage of comparison, comparison is carried out only based on one parameter weight in each group of operation parameter sections, and the operation parameter sections meeting preset conditions are input into a next stage of comparison thread so as to carry out comparison based on the next parameter weight;
the trajectory determination module 213 is configured to determine a data state trajectory of the substation operation data according to a parameter feature corresponding to a target operation parameter segment in which a comparison result of the substation operation data meets a substation state stability condition;
the data testing module 214 is configured to test the equipment loss data of the substation based on the substation operation data and the determined data state trajectory of the substation operation data to obtain a test result; and the test result is used for representing the probability of the fault of the transformer substation in a set time period.
Optionally, the data segmenting module 211 is configured to:
listing data labels in the transformer substation operation data, determining the label weight of each data label, and sequencing the data labels according to the label weight from large to small to obtain a data label sequence;
acquiring a sequence track of the data label sequence and a plurality of data sets of the transformer substation operation data; under the condition that the redundant data packet is determined to be contained in the substation operation data according to the sequence track, permission contrast between each data set of the substation operation data under the effective data packet and each data set of the substation operation data under the redundant data packet is determined according to the data sets of the substation operation data under the redundant data packet and permission information thereof; adjusting the data set with the minimum authority contrast of the substation operation data under the effective data packet and the data set under the redundant data packet to the redundant data packet;
under the condition that the effective data packet corresponding to the transformer substation operation data comprises a plurality of data sets, determining authority contrast among the data sets of the transformer substation operation data under the effective data packet according to the data sets of the transformer substation operation data under the redundant data packet and authority information of the transformer substation operation data, and splicing the data sets under the effective data packet based on the authority contrast among the data sets; setting an adjustment priority for a target data set obtained by splicing according to a data set of the transformer substation operation data under the redundant data packet and authority information thereof, and adjusting the target data set to a set position of the redundant data packet corresponding to the adjustment priority;
and carrying out segmentation processing on the data set under the effective data grouping based on the node attribute of the target node with the segment identifier corresponding to the sequence track in the data label sequence to obtain a plurality of groups of operation parameter sections.
Optionally, the trajectory determination module 213 is configured to:
extracting a state evaluation coefficient of the comparison result, and determining a target operation parameter section corresponding to the state evaluation coefficient when the state evaluation coefficient reaches a preset state coefficient of the transformer substation;
extracting the time sequence characteristics of the target operation parameter section according to the set time step;
generating a time sequence form corresponding to the time sequence characteristics and a parameter form corresponding to a target operation parameter section, wherein the time sequence form and the parameter form respectively comprise a plurality of form objects with different form weights;
extracting object attribute information of the time sequence feature in one table object of the time sequence form and determining the table object with the minimum form weight in the parameter form as a reference table object;
mapping the object attribute information to the reference table object to obtain mapping attribute information in the reference table object, and then generating a state switching list between the time sequence characteristic and the target operation parameter section based on the object attribute information and the mapping attribute information;
acquiring object track information in the reference table object by taking the mapping attribute information as an information template, mapping the object track information to the table object where the object attribute information is located according to the logic information corresponding to the state switching list, and obtaining the mapping track information corresponding to the object track information in the table object where the object attribute information is located;
and listing the track nodes and the connecting line information in the mapping track information and generating the data state track of the transformer substation operation data according to the track nodes and the connecting line information.
Optionally, the data testing module 214 is configured to:
determining a loss coefficient corresponding to the equipment loss data determined based on the substation operation data and the data state track, and weighting the equipment loss data by adopting the loss coefficient to obtain target loss data;
for current loss data in the target loss data, determining an update weight value of the current loss data in a preset time interval based on a first update frequency of the current loss data in the preset time interval and a second update frequency of each target loss data in the preset time interval;
and determining an update risk coefficient of the current loss data between two adjacent set time periods according to the update weight values of the current loss data in two adjacent preset time period intervals, and performing normalization processing on the update risk coefficient to obtain the test result.
On the basis of the above, there is also provided a computer terminal comprising a processor and a memory, which are in communication with each other, the processor being configured to retrieve a computer program from the memory, and to execute the computer program to implement the above-mentioned method.
Further, a computer-readable storage medium is provided, on which a computer program is stored, which computer program realizes the above-mentioned method when executed.
It will be understood that the invention is not limited to the precise arrangements described above and shown in the drawings and that various modifications and changes may be made without departing from the scope thereof. The scope of the invention is limited only by the appended claims.
Claims (10)
1. A data testing method is characterized by being applied to a computer terminal communicated with a transformer substation, and the method comprises the following steps:
after transformer substation operation data stored in the transformer substation in real time are collected, extracting a data tag sequence of the transformer substation operation data, and performing data segmentation processing on the transformer substation operation data based on the data tag sequence to obtain a plurality of groups of operation parameter sections; the data tag sequence is a sequence formed by device tags related to target electric equipment in the substation operation data;
comparing each group of operation parameter sections of the transformer substation operation data with each reference parameter section in a preset parameter set; a plurality of groups of reference parameter sections and parameter weights corresponding to each group of reference parameter sections are stored in the preset parameter set, and the plurality of groups of reference parameter sections are state parameter sets of a power grid area where the target electric equipment is located; if each group of extracted operation parameter sections of the substation operation data comprises a plurality of parameter weights, comparing the extracted operation parameter sections in the following mode: performing multi-stage comparison according to the priorities preset for the parameter weights; in each stage of comparison, comparison is carried out only based on one parameter weight in each group of operation parameter sections, and the operation parameter sections meeting preset conditions are input into a next stage of comparison thread so as to carry out comparison based on the next parameter weight;
determining a data state track of the transformer substation operation data according to the parameter characteristics corresponding to the target operation parameter section of which the comparison result with the transformer substation operation data conforms to the transformer substation state stability condition;
testing the equipment loss data of the transformer substation based on the transformer substation operation data and the determined data state track of the transformer substation operation data to obtain a test result; and the test result is used for representing the probability of the fault of the transformer substation in a set time period.
2. The method of claim 1, wherein extracting a data tag sequence of the substation operational data and performing data segmentation processing on the substation operational data based on the data tag sequence to obtain a plurality of sets of operational parameter segments comprises:
listing data labels in the transformer substation operation data, determining the label weight of each data label, and sequencing the data labels according to the label weight from large to small to obtain a data label sequence;
acquiring a sequence track of the data label sequence and a plurality of data sets of the transformer substation operation data; under the condition that the redundant data packet is determined to be contained in the substation operation data according to the sequence track, permission contrast between each data set of the substation operation data under the effective data packet and each data set of the substation operation data under the redundant data packet is determined according to the data sets of the substation operation data under the redundant data packet and permission information thereof; adjusting the data set with the minimum authority contrast of the substation operation data under the effective data packet and the data set under the redundant data packet to the redundant data packet;
under the condition that the effective data packet corresponding to the transformer substation operation data comprises a plurality of data sets, determining authority contrast among the data sets of the transformer substation operation data under the effective data packet according to the data sets of the transformer substation operation data under the redundant data packet and authority information of the transformer substation operation data, and splicing the data sets under the effective data packet based on the authority contrast among the data sets; setting an adjustment priority for a target data set obtained by splicing according to a data set of the transformer substation operation data under the redundant data packet and authority information thereof, and adjusting the target data set to a set position of the redundant data packet corresponding to the adjustment priority;
and carrying out segmentation processing on the data set under the effective data grouping based on the node attribute of the target node with the segment identifier corresponding to the sequence track in the data label sequence to obtain a plurality of groups of operation parameter sections.
3. The method of claim 1, wherein determining the data state trajectory of the substation operation data according to the parameter characteristics corresponding to the target operation parameter segment whose comparison result with the substation operation data meets the substation state stability condition comprises:
extracting a state evaluation coefficient of the comparison result, and determining a target operation parameter section corresponding to the state evaluation coefficient when the state evaluation coefficient reaches a preset state coefficient of the transformer substation;
extracting the time sequence characteristics of the target operation parameter section according to the set time step;
generating a time sequence form corresponding to the time sequence characteristics and a parameter form corresponding to a target operation parameter section, wherein the time sequence form and the parameter form respectively comprise a plurality of form objects with different form weights;
extracting object attribute information of the time sequence feature in one table object of the time sequence form and determining the table object with the minimum form weight in the parameter form as a reference table object;
mapping the object attribute information to the reference table object to obtain mapping attribute information in the reference table object, and then generating a state switching list between the time sequence characteristic and the target operation parameter section based on the object attribute information and the mapping attribute information;
acquiring object track information in the reference table object by taking the mapping attribute information as an information template, mapping the object track information to the table object where the object attribute information is located according to the logic information corresponding to the state switching list, and obtaining the mapping track information corresponding to the object track information in the table object where the object attribute information is located;
and listing the track nodes and the connecting line information in the mapping track information and generating the data state track of the transformer substation operation data according to the track nodes and the connecting line information.
4. The method of claim 1, wherein testing the equipment loss data of the substation based on the substation operational data and the determined data state trajectory of the substation operational data to obtain a test result comprises:
determining a loss coefficient corresponding to the equipment loss data determined based on the substation operation data and the data state track, and weighting the equipment loss data by adopting the loss coefficient to obtain target loss data;
for current loss data in the target loss data, determining an update weight value of the current loss data in a preset time interval based on a first update frequency of the current loss data in the preset time interval and a second update frequency of each target loss data in the preset time interval;
and determining an update risk coefficient of the current loss data between two adjacent set time periods according to the update weight values of the current loss data in two adjacent preset time period intervals, and performing normalization processing on the update risk coefficient to obtain the test result.
5. A data testing device for use with a computer terminal in communication with a substation, the device comprising:
the data segmentation module is used for extracting a data label sequence of the transformer substation operation data after the transformer substation operation data stored in the transformer substation in real time is acquired, and performing data segmentation processing on the transformer substation operation data based on the data label sequence to obtain a plurality of groups of operation parameter sections; the data tag sequence is a sequence formed by device tags related to target electric equipment in the substation operation data;
the parameter comparison module is used for comparing each group of operation parameter sections of the transformer substation operation data with each reference parameter section in a preset parameter set; a plurality of groups of reference parameter sections and parameter weights corresponding to each group of reference parameter sections are stored in the preset parameter set, and the plurality of groups of reference parameter sections are state parameter sets of a power grid area where the target electric equipment is located; if each group of extracted operation parameter sections of the substation operation data comprises a plurality of parameter weights, comparing the extracted operation parameter sections in the following mode: performing multi-stage comparison according to the priorities preset for the parameter weights; in each stage of comparison, comparison is carried out only based on one parameter weight in each group of operation parameter sections, and the operation parameter sections meeting preset conditions are input into a next stage of comparison thread so as to carry out comparison based on the next parameter weight;
the trajectory determination module is used for determining a data state trajectory of the transformer substation operation data according to the parameter characteristics corresponding to the target operation parameter section of which the comparison result of the transformer substation operation data conforms to the transformer substation state stability condition;
the data testing module is used for testing the equipment loss data of the transformer substation based on the transformer substation operation data and the determined data state track of the transformer substation operation data to obtain a testing result; and the test result is used for representing the probability of the fault of the transformer substation in a set time period.
6. The apparatus of claim 5, wherein the data segmentation module is configured to:
listing data labels in the transformer substation operation data, determining the label weight of each data label, and sequencing the data labels according to the label weight from large to small to obtain a data label sequence;
acquiring a sequence track of the data label sequence and a plurality of data sets of the transformer substation operation data; under the condition that the redundant data packet is determined to be contained in the substation operation data according to the sequence track, permission contrast between each data set of the substation operation data under the effective data packet and each data set of the substation operation data under the redundant data packet is determined according to the data sets of the substation operation data under the redundant data packet and permission information thereof; adjusting the data set with the minimum authority contrast of the substation operation data under the effective data packet and the data set under the redundant data packet to the redundant data packet;
under the condition that the effective data packet corresponding to the transformer substation operation data comprises a plurality of data sets, determining authority contrast among the data sets of the transformer substation operation data under the effective data packet according to the data sets of the transformer substation operation data under the redundant data packet and authority information of the transformer substation operation data, and splicing the data sets under the effective data packet based on the authority contrast among the data sets; setting an adjustment priority for a target data set obtained by splicing according to a data set of the transformer substation operation data under the redundant data packet and authority information thereof, and adjusting the target data set to a set position of the redundant data packet corresponding to the adjustment priority;
and carrying out segmentation processing on the data set under the effective data grouping based on the node attribute of the target node with the segment identifier corresponding to the sequence track in the data label sequence to obtain a plurality of groups of operation parameter sections.
7. The apparatus of claim 5, wherein the trajectory determination module is configured to:
extracting a state evaluation coefficient of the comparison result, and determining a target operation parameter section corresponding to the state evaluation coefficient when the state evaluation coefficient reaches a preset state coefficient of the transformer substation;
extracting the time sequence characteristics of the target operation parameter section according to the set time step;
generating a time sequence form corresponding to the time sequence characteristics and a parameter form corresponding to a target operation parameter section, wherein the time sequence form and the parameter form respectively comprise a plurality of form objects with different form weights;
extracting object attribute information of the time sequence feature in one table object of the time sequence form and determining the table object with the minimum form weight in the parameter form as a reference table object;
mapping the object attribute information to the reference table object to obtain mapping attribute information in the reference table object, and then generating a state switching list between the time sequence characteristic and the target operation parameter section based on the object attribute information and the mapping attribute information;
acquiring object track information in the reference table object by taking the mapping attribute information as an information template, mapping the object track information to the table object where the object attribute information is located according to the logic information corresponding to the state switching list, and obtaining the mapping track information corresponding to the object track information in the table object where the object attribute information is located;
and listing the track nodes and the connecting line information in the mapping track information and generating the data state track of the transformer substation operation data according to the track nodes and the connecting line information.
8. The apparatus of claim 5, wherein the data testing module is configured to:
determining a loss coefficient corresponding to the equipment loss data determined based on the substation operation data and the data state track, and weighting the equipment loss data by adopting the loss coefficient to obtain target loss data;
for current loss data in the target loss data, determining an update weight value of the current loss data in a preset time interval based on a first update frequency of the current loss data in the preset time interval and a second update frequency of each target loss data in the preset time interval;
and determining an update risk coefficient of the current loss data between two adjacent set time periods according to the update weight values of the current loss data in two adjacent preset time period intervals, and performing normalization processing on the update risk coefficient to obtain the test result.
9. A computer terminal, characterized in that it comprises a processor and a memory communicating with each other, said processor being adapted to retrieve a computer program from said memory, and to execute said computer program to implement the method of any of the preceding claims 1-4.
10. A computer-readable storage medium, on which a computer program is stored which, when executed, implements the method of any of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010455352.1A CN111639141B (en) | 2020-05-26 | 2020-05-26 | Data testing method and device and computer terminal |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010455352.1A CN111639141B (en) | 2020-05-26 | 2020-05-26 | Data testing method and device and computer terminal |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111639141A true CN111639141A (en) | 2020-09-08 |
| CN111639141B CN111639141B (en) | 2023-08-15 |
Family
ID=72329948
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010455352.1A Active CN111639141B (en) | 2020-05-26 | 2020-05-26 | Data testing method and device and computer terminal |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111639141B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115827453A (en) * | 2022-12-01 | 2023-03-21 | 中国兵器工业信息中心 | Reliability test profile construction and test case generation method for networked software system |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070067438A1 (en) * | 2005-09-21 | 2007-03-22 | Battelle Memorial Institute | Methods and systems for detecting abnormal digital traffic |
| US20130091258A1 (en) * | 2011-10-07 | 2013-04-11 | Cisco Technology, Inc. | Communication network topology management based on an associated electric grid topology |
| CN104361531A (en) * | 2014-11-14 | 2015-02-18 | 广东电网有限责任公司电力调度控制中心 | Identification method and system for high-risk failure equipment of substation automation system |
| US20150377945A1 (en) * | 2013-02-12 | 2015-12-31 | Headsight, Inc. | Diagnostic system for a controller |
| CN105652113A (en) * | 2015-12-29 | 2016-06-08 | 安徽海兴泰瑞智能科技有限公司 | Power grid equipment performance perception and evaluation method |
| CN106528968A (en) * | 2016-10-31 | 2017-03-22 | 国网福建省电力有限公司 | Intelligent substation automatic dynamic simulation test method based on SSD file |
| CN107292490A (en) * | 2017-05-18 | 2017-10-24 | 国网浙江省电力公司杭州供电公司 | Trial operation substation operation risk evaluation system and appraisal procedure |
| CN108596459A (en) * | 2018-04-13 | 2018-09-28 | 广州供电局有限公司 | Substation's risk alarm method and system |
| CN109784777A (en) * | 2019-02-28 | 2019-05-21 | 西安交通大学 | Grid equipment state evaluating method based on timing information segment cloud measuring similarity |
| CN110110933A (en) * | 2019-05-10 | 2019-08-09 | 西南交通大学 | A kind of maintenance circle optimization method of intelligent substation protection system |
-
2020
- 2020-05-26 CN CN202010455352.1A patent/CN111639141B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070067438A1 (en) * | 2005-09-21 | 2007-03-22 | Battelle Memorial Institute | Methods and systems for detecting abnormal digital traffic |
| US20130091258A1 (en) * | 2011-10-07 | 2013-04-11 | Cisco Technology, Inc. | Communication network topology management based on an associated electric grid topology |
| US20150377945A1 (en) * | 2013-02-12 | 2015-12-31 | Headsight, Inc. | Diagnostic system for a controller |
| CN104361531A (en) * | 2014-11-14 | 2015-02-18 | 广东电网有限责任公司电力调度控制中心 | Identification method and system for high-risk failure equipment of substation automation system |
| CN105652113A (en) * | 2015-12-29 | 2016-06-08 | 安徽海兴泰瑞智能科技有限公司 | Power grid equipment performance perception and evaluation method |
| CN106528968A (en) * | 2016-10-31 | 2017-03-22 | 国网福建省电力有限公司 | Intelligent substation automatic dynamic simulation test method based on SSD file |
| CN107292490A (en) * | 2017-05-18 | 2017-10-24 | 国网浙江省电力公司杭州供电公司 | Trial operation substation operation risk evaluation system and appraisal procedure |
| CN108596459A (en) * | 2018-04-13 | 2018-09-28 | 广州供电局有限公司 | Substation's risk alarm method and system |
| CN109784777A (en) * | 2019-02-28 | 2019-05-21 | 西安交通大学 | Grid equipment state evaluating method based on timing information segment cloud measuring similarity |
| CN110110933A (en) * | 2019-05-10 | 2019-08-09 | 西南交通大学 | A kind of maintenance circle optimization method of intelligent substation protection system |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115827453A (en) * | 2022-12-01 | 2023-03-21 | 中国兵器工业信息中心 | Reliability test profile construction and test case generation method for networked software system |
| CN115827453B (en) * | 2022-12-01 | 2023-09-08 | 中国兵器工业信息中心 | Reliability test section structure and test case generation method of networked software system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111639141B (en) | 2023-08-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112731051B (en) | Single-ended fault positioning method and system for high-voltage direct-current transmission line of hybrid network | |
| CN113723810B (en) | Power grid modeling method based on graph database | |
| CN110601173B (en) | Distribution network topology identification method and device based on edge calculation | |
| CN114285725B (en) | Network fault determining method and device, storage medium and electronic equipment | |
| CN117767250B (en) | Direct-current micro-grid coordinated control method and system based on fault monitoring | |
| CN112115957A (en) | Data stream identification method and device and computer storage medium | |
| CN112686494A (en) | Data fitting method and device based on line loss abnormal distribution room and intelligent equipment | |
| CN117110794A (en) | Intelligent diagnosis system and method for cable faults | |
| CN111639141A (en) | Data testing method and device and computer terminal | |
| CN117112630A (en) | Topological structure generation method, device and equipment of power grid data and storage medium | |
| CN114512982A (en) | Power distribution network topology identification method and device and terminal equipment | |
| CN113791306A (en) | Power distribution network fault processing system and method based on data acquisition | |
| CN117729576A (en) | Alarm monitoring method, device, equipment and storage medium | |
| CN117031201A (en) | Multi-scene topology anomaly identification method and system for power distribution network | |
| CN112327804A (en) | Fault diagnosis method, device and system of traction control unit and train | |
| CN112182579A (en) | Process list generation method and device and abnormal process detection method and device | |
| CN115618286A (en) | Transformer partial discharge type identification method, system, equipment, terminal and application | |
| CN114722971A (en) | Low-voltage transformer area phase identification method | |
| CN112380340B (en) | Error data diagnosis method and system between main station, power plant and transformer substation | |
| CN111950448B (en) | High-voltage isolating switch fault state detection method and device based on machine vision | |
| CN110716101B (en) | Power line fault positioning method and device, computer and storage medium | |
| CN112559804A (en) | Graph database-based power grid CIM/E model data processing method and device | |
| CN110322076A (en) | A kind of medium-voltage line fault treatment lectotype selection standard base construction method | |
| CN116542812B (en) | GIS-based service channel switching method and system for power line transformation | |
| CN113569904B (en) | Bus wiring type identification method, system, storage medium and computing device |
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 | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 650100 phase 4b, shenggaodacheng, Xishan District, Kunming City, Yunnan Province Applicant after: Li Yunxiang Address before: No. 206, Machang village, Machang village committee, Kuishan Town, Shizong County, Qujing City, Yunnan Province Applicant before: Li Yunxiang |
|
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20230725 Address after: 430070 Hubei Province, Wuhan city Hongshan District Luoyu Road No. 546 Applicant after: HUBEI CENTRAL CHINA TECHNOLOGY DEVELOPMENT OF ELECTRIC POWER Co.,Ltd. Address before: 650100 phase 4b, shenggaodacheng, Xishan District, Kunming City, Yunnan Province Applicant before: Li Yunxiang |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |