Content of the invention
In view of this, the invention provides a kind of information check method and device, solve in prior art and manually check
Information and be the potential safety hazard brought of safe and reliable operation of transformer station, and improve information check efficiency.
For achieving the above object, the present invention provides following technical scheme:
A kind of information check method, methods described includes:
According to preset path, obtain the wave-record chart table of target substation automated system;
According to preset rules, determine the information content that in described wave-record chart table, all working table records respectively, wherein, institute
Stating the information content is the first distant metrical information, the first remote signalling amount information or the first remote control amount information, and described first remote measurement amount letter
Breath, described first remote signalling amount information and described first remote control amount information all include:One-to-one sequence number, first information description and
Remarks;
According to the type of described information content, by all one-to-one sequence number of described work table record, the first information
Description and remarks store in corresponding first preset group one by one, and wherein, described first preset group includes:First remote measurement number
Group, the first remote signalling array and the first remote control array;
The second distant metrical information in reading target database, the second remote signalling amount information and the second remote control amount information, extract
Go out corresponding period and the description of the second information, and be respectively stored into corresponding second preset group, wherein, described second present count
Group includes:Second remote measurement array, the second remote signalling array and the second remote control array;
According to preset matching rule, retouched with the first information in the first preset group corresponding with described preset matching rule
State as standard, one by one the second information description in the second preset group corresponding with described first preset group checked,
Output check result.
Preferably, according to preset rules, determine in the information that in described wave-record chart table, all working table records respectively
After appearance, and in the type according to described information content, by all one-to-one sequence number of described work table record, the first letter
Before breath description stores in corresponding first preset group one by one with remarks, methods described also includes:
According to the sequence number of each described worksheet, determine start-stop row and the termination of the information content of described work table record
OK;
The then described type according to described information content, by all one-to-one sequence number of described work table record,
One information description and remarks store one by one in corresponding first preset group and are specially:
According to the type of described information content, from the start-stop row of each described worksheet to termination row, line by line by described work
One-to-one sequence number, first information description and the remarks of making table record store in corresponding first preset group.
Preferably, described preset matching rule includes:
The remote measurement synonym matched rule, the remote signalling that correspond to distant metrical information, remote signalling amount information and remote control amount information respectively are same
Adopted word matched rule and remote control synonym matched rule.
Preferably, described remote measurement synonym matched rule, remote signalling synonym matched rule and remote control synonym matched rule
All include:It is applied to the synonymous phrase deposited matched position and do not limit, the synonymous phrase being only applicable to prefix matching and be only applicable to
The synonymous phrase of suffix match.
Preferably, described regular according to preset matching, with the first preset group corresponding with described preset matching rule
The first information be described as standard, one by one the second information in the second preset group corresponding with described first preset group is retouched
State and carry out check and be specially:
Judge the second information description in first information description and corresponding second preset group in the first preset group
Whether identical;
If not congruent, judge one by one preset matching rule in described first preset group and described second present count
Organize the character string in corresponding synonymous phrase to whether there is in the description of the described first information and described second information description;
If it is, the character of described synonymous phrase will be belonged in the description of the described first information and described second information description
String is deleted, and judge one by one described in returning in preset matching rule with described first preset group and described second preset group
Character string in corresponding synonymous phrase whether there is step in the description of the described first information and described second information description and continues
Continuous execution;
If not, word corresponding with described character string in output described first information description and/or described second information description
Section.
Preferably, methods described also includes:
Described check result is shown.
A kind of information check device, described device includes:
Acquiring unit:For according to preset path, obtaining the wave-record chart table of target substation automated system;
First determining unit:All in the wave-record chart table that described acquiring unit obtains for according to preset rules, determining
The information content that worksheet records respectively, wherein, described information content is the first distant metrical information, the first remote signalling amount information or the
One remote control amount information, and described first distant metrical information, described first remote signalling amount information and described first remote control amount information all wraps
Include:One-to-one sequence number, first information description and remarks;
Memory cell:For the type according to described information content, described work table record is all one-to-one
Sequence number, first information description and remarks store in corresponding first preset group one by one, and wherein, the first preset group includes:
First remote measurement array, the first remote signalling array and the first remote control array;
Extraction unit:Distant for reading the second distant metrical information in target database, the second remote signalling amount information and second
Control amount information, extracts corresponding period and the description of the second information, and is respectively stored in corresponding second preset group, its
In, described second preset group includes:Second remote measurement array, the second remote signalling array and the second remote control array;
Check unit:For according to preset matching rule, with first preset group corresponding with described preset matching rule
In the first information be described as standard, one by one to the second information in the second preset group corresponding with described first preset group
Description is checked, and exports check result.
Preferably, described extraction unit includes:
Reading unit:Distant for reading the second distant metrical information in target database, the second remote signalling amount information and second
Control amount information;
Extract memory cell:For reading from described reading unit second distant metrical information, the second remote signalling amount information
In the second remote control amount information, extract corresponding period and the description of the second information respectively, and store corresponding second and preset
In array, wherein, described second preset group includes:Second remote measurement array, the second remote signalling array and the second remote control array.
Preferably, described device also includes:
Second determining unit:The sequence number of each described worksheet for being obtained according to described first determining unit, determines
The start-stop row of the information content of described work table record and termination row;
Then described memory cell is specifically for the type according to described information content, from the start-stop row of each described worksheet
To termination row, line by line the one-to-one sequence number of described work table record, first information description and remarks are stored corresponding
In first preset group.
Preferably, described check unit includes:
First judging unit:For judging the description of the first information in the first preset group and corresponding second preset group
Whether the second interior information description is identical;
Second judging unit:For when the judged result of described first judging unit is congruent, judging default one by one
In matched rule with the character string in described first preset group and the corresponding synonymous phrase of described second preset group whether
It is present in described first information description and described second information description;
Processing unit:For described second judging unit judged result be when, by the described first information description and
The character string belonging to described synonymous phrase in described second information description is deleted, and triggers the second judging unit;
Output unit:For when the judged result of described second judging unit is no, the described first information of output describes
And/or described second information description in described character string corresponding field.
Understand via above-mentioned technical scheme, compared with prior art, the present disclosure provides a kind of information check side
Method and device, after the wave-record chart table obtaining target substation automated system, according to preset rules, determine this wave-record chart
The information content that in table, multiple worksheets record respectively is the first distant metrical information, the first remote signalling amount information or the first remote control amount letter
Breath, further according to the type of the information content of wave-record chart table record, by all one-to-one sequence number of multiple work table records,
First information description and remarks store in corresponding first preset group one by one, meanwhile, by reading in target database
Second distant metrical information, the second remote signalling amount information and the second remote control amount information, and the second information description therein is stored respectively
To in corresponding second preset group, now, can be pre- with corresponding with this preset matching rule first according to preset matching rule
If the first information in array is described as standard, one by one school is carried out to the second information description in corresponding second preset group
Core, exports check result, it is achieved thereby that in the distant metrical information in target database, remote signalling amount information and remote control amount information
Information description automatic Check, improve check result the degree of accuracy and check efficiency it is ensured that transformer station safe and reliable
Run, and greatly save human cost.
Specific embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Site preparation description is it is clear that described embodiment is only a part of embodiment of the present invention, rather than whole embodiments.It is based on
Embodiment in the present invention, it is every other that those of ordinary skill in the art are obtained under the premise of not making creative work
Embodiment, broadly falls into the scope of protection of the invention.
The embodiment of the invention discloses a kind of information check method and device, obtaining target substation automated system
After wave-record chart table, according to preset rules, determine that the information content that in this wave-record chart table, multiple worksheets record respectively is
One distant metrical information, the first remote signalling amount information or the first remote control amount information, further according to the information content of wave-record chart table record
Type, all one-to-one sequence number of multiple work table records, first information description and remarks is stored one by one corresponding
In first preset group, meanwhile, by reading the second distant metrical information in target database, the second remote signalling amount information and second
Remote control amount information, and the second information description therein is respectively stored in corresponding second preset group, now, can be according to pre-
If matched rule, to be described as standard with the first information in this corresponding first preset group of preset matching rule, right one by one
The second information description in corresponding second preset group is checked, and exports check result, it is achieved thereby that to target data
The automatic Check of the information description in the distant metrical information in storehouse, remote signalling amount information and remote control amount information, improves check result
The degree of accuracy and check efficiency it is ensured that the safe and reliable operation of transformer station, and greatly save human cost.
As shown in figure 1, being a kind of flow chart of present invention information check method embodiment, the method can be used for power transformation
The check of the remote measurement amount of the regulator control system stood, remote signalling amount and the description of remote control amount corresponding information, to avoid occurring in straighforward operation
Malfunction, is that the operation of transformer station brings potential safety hazard, specifically, the method can include:
Step S11:According to preset path, obtain the wave-record chart table of target substation automated system.
In actual applications, the remote measurement amount of the electric substation automation system that generally all can just detect, remote signalling amount and distant
Control amount information record is in a wave-record chart table, and this wave-record chart table is stored under a preset path, so that basis from now on
This preset path obtains this wave-record chart table, and wherein, this wave-record chart table is typically the form of excel form.
Step S12:According to preset rules, determine in the information that in described wave-record chart table, all working table records respectively
Hold.
Wherein, this information content can be the first distant metrical information, the first remote signalling amount information or the first remote control amount information, and
This first distant metrical information, this first remote signalling amount information and this first remote control amount information may each comprise:One-to-one sequence number,
First information description and remarks.
In embodiments of the present invention, when the form that wave-record chart table is excel form it will usually by different work
Table(I.e. Sheet)To store the remote measurement amount detecting, remote signalling amount and remote control amount information respectively that is to say, that in each Sheet
Only record a type of information content, so, in embodiments of the present invention, the information content that multiple worksheets record respectively can
Think the first distant metrical information, the first remote signalling amount information or the first remote control amount information.
And, in actual applications, in each Sheet, generally sequence number hurdle, information description bar and remarks column can be set, because
And, when with this Sheet record information content, this sequence number hurdle can from 1,2 ... N(Wherein, N is positive integer)Sequentially generate multiple
Sequence number;And information description bar is then used for recording the flesh and blood of the remote measurement amount collecting every time, remote signalling amount or remote control amount information;Standby
Note hurdle, then be used for recording some special circumstances or information of paying particular attention to etc., so, either the first remote measurement amount letter
Breath, is the first remote signalling amount information, or the first remote control amount information all includes one-to-one sequence number, the first information describes and standby
Note.
Step S13:According to the type of the information content, by the one-to-one sequence number of all working table record, the first information
Description and remarks store corresponding first preset group one by one.
Wherein, this first preset group includes:First remote measurement array, the first remote signalling array and the first remote control array.
In the practical application of the embodiment of the present invention, after execution step S12, and before execution step S13 it will usually
According to the sequence number in each Sheet, to determine the start-stop row of the information content and the termination row of its record, afterwards, it will according to
The type of the information content of record in Sheet, from the start-stop row of every Sheet to termination row, recorded line by line one a pair
Sequence number, first information description and the remarks answered store in corresponding first preset group, so that in wave-record chart table
In all Sheet, the information content of record is all respectively present in the first remote measurement array, the first remote signalling array and the first remote control array,
Subsequently to process to these three arrays.
Wherein, the first remote measurement array, the first remote signalling array and the first remote control array can be stored in
In NbFesData.instance file, and the title of the first remote measurement array can be xlsYcPoints, the first remote signalling array
Title can be able to be xlsYkPoints for xlsYxPoints, the title of the first remote control array.
Step S14:Read the second distant metrical information in target database, the second remote signalling amount information and the second remote control amount to believe
Breath, extracts corresponding period and the description of the second information, and is respectively stored in corresponding second preset group.
Wherein, the second preset group includes:Second remote measurement array, the second remote signalling array and the second remote control array.
In actual applications, the remote measurement amount of the transformer station being collected due to communication manager, remote signalling amount and remote control amount etc. are believed
Breath, is generally all stored in SCADA(Supervisory Control And Data Acquisition, data acquisition and control
System)/EMS(Energy Manangement System, EMS)In database, so that control centre is according to this
These information of storage in SCADA/EMS database, export correct regulation and control instruction, thus ensureing the safe and reliable of this transformer station
Run.So, in embodiments of the present invention, row information verification can entered using SCADA/EMS database as target database
When, the second distant metrical information in this target database, the second remote signalling amount information and the second remote control amount information can be directly read, and
It is respectively stored in three different arrays.
Specifically, the embodiment of the present invention can read reflection remote measurement amount, remote signalling amount and remote control amount in target database line by line
Text document, extract corresponding period and the second information description, then, according to the type of the information extracting, will extract
The all corresponding period going out and the description of the second information are respectively stored into the second remote measurement array, the second remote signalling array and the second remote control
In array, subsequently to process further.
Wherein, the second remote measurement array, the second remote signalling array and the second remote control array can be stored in
In NbFesData.instance file, and the type of the second remote measurement array can be AnalogPoints [], and title can be
YcPoints;The type of the second remote signalling array can be DiscretePoints [], and title can be YxPoints;Second remote control
The type of array can be YkInfo [], and title can be YkPoints.
Step S15:According to preset matching rule, it is described as marking with the first information in the first corresponding preset group
Standard, checks to the second information description in the second preset group corresponding with the first preset group, knot is checked in output one by one
Really.
Wherein, this check result can be shown by a display, to facilitate staff to be entered according to its display content
The corresponding process of row.Preferably, stagger the time when the second information in target database is depicted, information warning can also be exported, such as
Voice messaging, to remind staff in time wrong information description to be processed.
In the practical application of the embodiment of the present invention, generally all can set up SynonymSets class and deposit TongYiCi CiLin
Form, for same electric pressure(As 110kV or 220kV)Three SynonymSets class forms can be set, for depositing respectively
Put the synonym matched rule of remote signalling, telemetry and telecommand, so that during information check, rule are mated according to corresponding synonym
Then, the information description in remote signalling amount information, distant metrical information or remote control amount information is checked.So, the embodiment of the present invention
Described preset matching rule can include:The remote measurement corresponding to distant metrical information, remote signalling amount information and remote control amount information respectively is same
Adopted word matched rule, remote signalling synonym matched rule and remote control synonym matched rule.
Preferably, in order to improve the degree of accuracy of information check, in the domain of each SynonymSets object, may each comprise three
Individual ArrayList<String[]>, before being respectively used to store and being applied to the synonymous phrase deposited matched position and do not limit, be only applicable to
The synonymous phrase sewing coupling and the synonymous phrase being only applicable to suffix match.As can be seen here, each ArrayList is to be by one
The String [] character string of row is constituted, and each character string in same character string dimension is synonymous, belongs to same
SynonymSets.
Based on this, when checking to the second information description in the second preset group, specifically can first judge first
Whether the first information description in preset group is identical with the second information description in corresponding second preset group, if
Not congruent, judge one by one in the synonymous phrase corresponding with the first preset group and the second preset group in preset matching rule
Character string whether there is in first information description and described second information description, if it is present directly retouching the first information
State the character string deletion belonging to this synonymous phrase in describing with the second information, and continue contrast, final output school as stated above
Core result;If it does not exist, then the second information description of the record in explanation target database occurs in that mistake, at this point it is possible to
Output the first information description and/or the second information description in field corresponding with this character string so that carried out according to this field right
The process answered, thus ensureing the correctness of the regulation and control instruction according to the output of this second description information, enables transformer station safely may be used
By running.
Wherein it is desired to explanation, above-mentioned each array is all generally to record corresponding information with character string forms, so,
In the embodiment of the present invention, the comparison of the first preset group and the second preset group is actually the comparison of two character strings, and root
Learn according to above-mentioned analysis, the synonymous phrase record of preset matching rule is also various character string, thus, carrying out above-mentioned check
During, it is in units of character, is contrasted one by one, substantially increase the degree of accuracy of check.
The embodiment of the present invention, according to preset rules, determines in the information that in this wave-record chart table, all working table records respectively
Appearance is the first distant metrical information, is the first remote signalling amount information, or after the first remote control amount information, according to wave-record chart table record
The information content type, by work table record all one-to-one sequence number, the first information description and remarks store one by one
To in corresponding first preset group, meanwhile, by reading the second distant metrical information in target database, the second remote signalling amount letter
Breath and the second remote control amount information, and the second information description therein is respectively stored in corresponding second preset group, now,
Can be according to preset matching rule, to be described as marking with the first information in this corresponding first preset group of preset matching rule
Standard, checks to the second information description in corresponding second preset group one by one, exports check result, it is achieved thereby that right
The automatic Check of the information description in the distant metrical information in target database, remote signalling amount information and remote control amount information, improves
The degree of accuracy of check result and check efficiency it is ensured that the safe and reliable operation of transformer station, and greatly save human cost.
As shown in Fig. 2 being a kind of structural representation of present invention information check device embodiment, this device can include:
Acquiring unit S21:For according to preset path, obtaining the wave-record chart table of target substation automated system.
Wherein, this preset path can be absolute for the wave-record chart table of known storage target substation automated system
Path or relative path, and this wave-record chart tableau format is usually excel form.
First determining unit S22:For according to preset rules, determining many in the wave-record chart table that acquiring unit S21 obtains
The information content that individual worksheet records respectively.
Wherein, the information content can be the first distant metrical information, the first remote signalling amount information or the first remote control amount information, and the
One distant metrical information, the first remote signalling amount information and the first remote control amount information may each comprise:One-to-one sequence number, the first information
Description and remarks.
Memory cell S23:For the type according to the information content, by all working table record in this wave-record chart table
All one-to-one sequence numbers, first information description and remarks store in corresponding first preset group one by one.
Wherein, the first preset group includes:First remote measurement array, the first remote signalling array and the first remote control array, anti-respectively
Answer distant metrical information in wave-record chart table, remote signalling amount information and remote control amount information.In actual applications, the first remote measurement array,
What the first remote signalling array and the first remote control array were usually noted is the character string of corresponding information description.
Extraction unit S24:For reading the second distant metrical information in target database, the second remote signalling amount information and second
Remote control amount information, extracts corresponding period and the description of the second information, and is respectively stored in corresponding second preset group.
Wherein, the second preset group includes:Second remote measurement array, the second remote signalling array and the second remote control array, in reality
In application, be commonly stored in the second remote measurement array, the second remote signalling array and the second remote control array is for reacting corresponding informance
The character string of description.
Check cell S 25:For according to preset matching rule, with the first information in the first corresponding preset group
It is described as standard, one by one the second information description in the second preset group corresponding with this first preset group is checked,
Output check result.
Wherein, extraction unit S24 can include:
Reading unit S241:For reading the second distant metrical information in target database, the second remote signalling amount information and
Two remote control amount information.
Extract memory cell S242:For reading from reading unit S241 second distant metrical information, the second remote signalling amount
In information and the second remote control amount information, extract corresponding period and the description of the second information respectively, and store corresponding second
In preset group.
Wherein, this second preset group includes:Second remote measurement array, the second remote signalling array and the second remote control array.
Preferably, as further embodiment of this invention, the base of the information check device described in the embodiments of the present invention
On plinth, this information check device can also include:
Second determining unit:The sequence number of each described worksheet for being obtained according to the first determining unit S22, determines institute
State start-stop row and the termination row of the information content of work table record.
Then memory cell S23, specifically for the type of the information content according to wave-record chart table record, works from each
The one-to-one sequence number of all working table record, first information description and remarks, to termination row, are deposited by the start-stop row of table line by line
Store up in corresponding first preset group.
Preferably, the check cell S 25 described in the embodiment of the present invention can also include:
First judging unit S251:Default with corresponding second for judging the description of the first information in the first preset group
Whether the second information description in array is identical.
Second judging unit S252:For when the judged result of the first judging unit S251 is congruent, judging one by one
The character string in synonymous phrase corresponding with the first preset group and the second preset group in preset matching rule whether there is
In the first information description of this first preset group and the second information description of the second preset group.
Processing unit S253:For the second judging unit S252 judged result be when, by the first information description and
The character string belonging to this synonymous phrase in second information description is deleted, and triggers the second judging unit S252.
Output unit S254:For when the judged result of the second judging unit S253 is no, the output first information describes
And/or second information description in this character string corresponding field.
Wherein, in actual applications, by display, check result can be shown, so that staff can be directly perceived
See check result, and correspondingly processed.
The embodiment of the present invention obtains the wave-record chart table of target substation automated system by acquiring unit, and is sent to
First determining unit, according to preset rules, to determine the information content that in this wave-record chart table, multiple worksheets record respectively
Be the first distant metrical information, be the first remote signalling amount information, or the first remote control amount information, afterwards, then by memory cell according to
The type of the information content of wave-record chart table record, by all one-to-one sequence number of all working table record, the first information
Description and remarks store in corresponding first preset group one by one, and meanwhile, the present invention will be from number of targets also by extraction unit
According to the second distant metrical information reading in storehouse, the second remote signalling amount information and the second remote control amount information, it is respectively stored into corresponding the
In two preset group, afterwards, you can by checking unit according to preset matching rule, one by one to the in this second preset group
Two information descriptions are checked, and obtain check result, and compared with the mode of existing artificial check, the present invention passes through information check
Device achieves automatic to the information description in the distant metrical information in target database, remote signalling amount information and remote control amount information
Check, improve the degree of accuracy of check result and check efficiency it is ensured that the safe and reliable operation of transformer station.
Wherein it is desired to explanation, the above embodiment of the present invention is a kind of exemplary example, should not be taken as limiting
System, given particular content should in no way limit the purpose of the application.For example, the division of described unit, only a kind of logic
Function divides, and actual can have other dividing mode when realizing, and for example multiple units combine.In addition, multiple units can
With or assembly can in conjunction with or be desirably integrated into another system, or some features can be ignored, or does not execute.And,
Herein, term " inclusion ", "comprising" or its any other variant are intended to comprising of nonexcludability, so that including
A series of process of key elements, method, article or equipment not only include those key elements, but also its including being not expressly set out
His key element, or also include for this process, method, article or the intrinsic key element of equipment, here will no longer be gone to live in the household of one's in-laws on getting married one by one
State, those skilled in the art are creative making great efforts determination so long as not paying, and belong to protection scope of the present invention.
In this specification, each embodiment is described by the way of going forward one by one, and what each embodiment stressed is and other
The difference of embodiment, between each embodiment identical similar portion mutually referring to.For device disclosed in embodiment
For, because it corresponds to the method disclosed in Example, so description is fairly simple, say referring to method part in place of correlation
Bright.
Described above to the disclosed embodiments, makes professional and technical personnel in the field be capable of or uses the present invention.
Multiple modifications to these embodiments will be apparent from for those skilled in the art, as defined herein
General Principle can be realized without departing from the spirit or scope of the present invention in other embodiments.Therefore, the present invention
It is not intended to be limited to the embodiments shown herein, and be to fit to and principles disclosed herein and features of novelty phase one
The scope the widest causing.