CN103678655A - Method and device for verifying information - Google Patents
Method and device for verifying information Download PDFInfo
- Publication number
- CN103678655A CN103678655A CN201310718946.7A CN201310718946A CN103678655A CN 103678655 A CN103678655 A CN 103678655A CN 201310718946 A CN201310718946 A CN 201310718946A CN 103678655 A CN103678655 A CN 103678655A
- Authority
- CN
- China
- Prior art keywords
- information
- preset
- preset group
- remote
- remote control
- 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
- 238000000034 method Methods 0.000 title claims abstract description 36
- 230000011664 signaling Effects 0.000 claims abstract description 81
- 238000005259 measurement Methods 0.000 claims description 35
- 238000000605 extraction Methods 0.000 claims description 7
- 238000012545 processing Methods 0.000 claims description 6
- 238000003491 array Methods 0.000 abstract description 5
- 238000004891 communication Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 239000008280 blood Substances 0.000 description 1
- 210000004369 blood Anatomy 0.000 description 1
- 238000000151 deposition Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000007257 malfunction Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
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/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Water Supply & Treatment (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- General Health & Medical Sciences (AREA)
- Public Health (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Selective Calling Equipment (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a method and device for verifying information. After information content respectively recorded by multiple worksheets in an obtained wave-recording information sheet is determined, according to types of the information content recorded by the wave-recording information sheet, serial numbers, first information descriptions and remarks are stored into corresponding first preset arrays in an item-by-item mode, wherein the serial numbers, the first information descriptions and the remarks are recorded by all the worksheets in a one-to-one correspondence mode, meanwhile, second remote measuring quantity information, second remote signaling information and second remote control quantity information in a target database are read, second information descriptions in the database are stored into corresponding second preset arrays, then the method and device can verify the second information descriptions in the corresponding second preset arrays in an item-by-item mode according to a preset matching rule, verified results are output, and therefore the information descriptions in the remote measuring quantity information, the remote signaling quantity information and the remote control quantity information are automatically verified. Accuracy of the verified results and the verifying efficiency are improved, and safe and reliable running of a transformer substation is guaranteed.
Description
Technical field
The present invention relates to information check technical field, relate in particular a kind of information check method and device.
Background technology
In transformer station, conventionally be all provided with the information such as remote measurement that communication manager gathers this transformer station, Remote control, and these information are stored in to SCADA(Supervisory Control And Data Acquisition, data acquisition and control)/EMS(Energy Manangement System, energy management system) in database, so that dispatching center is according to these information of storing in this SCADA/EMS database, export correct regulation and control instruction, thereby guarantee the safe and reliable operation of this transformer station.
In actual applications, for the correctness that guarantees that in SCADA/EMS database (being target database), institute's canned data is described, conventionally need staff according to electric substation automation system record ripple information table, regularly canned data in this SCADA/EMS database is described and checked.But along with the development of electrical network, the exercise data quantity of information of transformer station is more and more huger, the check that the information in SCADA/EMS database of manually carrying out is described tends to exist certain mistake, for the safe and reliable operation of transformer station brings very large potential safety hazard.
Summary of the invention
In view of this, the invention provides a kind of information check method and device, solved the potential safety hazard that in prior art, manually the safe and reliable operation of check information Er Wei transformer station brings, and improved information check efficiency.
For achieving the above object, the invention provides following technical scheme:
An information check method, described method comprises:
According to preset path, obtain the record ripple information table of target electric substation automation system;
According to preset rules, determine the information content that in described record ripple information table, all working table records respectively, wherein, the described information content is the first distant metrical information, the first remote signalling amount information or the first remote control amount information, and described the first distant metrical information, described the first remote signalling amount information and described the first remote control amount information include: sequence number, the first information are described and remarks one to one;
According to the type of the described information content, all sequence numbers one to one of described worksheet record, first information description and remarks are stored in the first corresponding preset group one by one, wherein, described the first preset group comprises: the first remote measurement array, the first remote signalling array and the first remote control array;
Read the second distant metrical information, the second remote signalling amount information and the second remote control amount information in target database, extracting corresponding period and the second information describes, and store respectively the second corresponding preset group into, wherein, described the second preset group comprises: the second remote measurement array, the second remote signalling array and the second remote control array;
According to preset matching rule, with the first information in the first preset group corresponding with described preset matching rule, be described as standard, one by one the second information in the second preset group corresponding with described the first preset group is described and checked, output check result.
Preferably, according to preset rules, after determining the information content that in described record ripple information table, all working table records respectively, and according to the type of the described information content, before all sequence numbers one to one of described worksheet record, first information description and remarks are stored in the first corresponding preset group one by one, described method also comprises:
According to the sequence number of worksheet described in each, determine start-stop row and the termination row of the information content of described worksheet record;
Described according to the type of the described information content, all sequence numbers one to one of described worksheet record, first information description and remarks are stored into one by one in the first corresponding preset group and are specially:
According to the type of the described information content, from the start-stop row of worksheet described in each to termination row, line by line the sequence number one to one of described worksheet record, first information description and remarks are stored in the first corresponding preset group.
Preferably, described preset matching rule comprises:
Remote measurement synonym matched rule, remote signalling synonym matched rule and the remote control synonym matched rule of difference corresponding distant metrical information, remote signalling amount information and remote control amount information.
Preferably, described remote measurement synonym matched rule, remote signalling synonym matched rule and remote control synonym matched rule include: be applicable to deposit synonym phrase, the synonym phrase that is only applicable to prefix matching that matched position do not limit and the synonym phrase that is only applicable to suffix match.
Preferably, described according to preset matching rule, with the first information in the first preset group corresponding with described preset matching rule, be described as standard, one by one the second information in the second preset group corresponding with described the first preset group described to check being specially:
Judge the first information in the first preset group is described whether identical with the second information description in the second corresponding preset group;
If not congruent, judge one by one whether the character string in the synonym phrase corresponding with described the first preset group and described the second preset group in preset matching rule is present in described first information description and described the second information description;
If, the character string that belongs to described synonym phrase in described first information description and described the second information description is deleted, and described in returning, judge one by one whether the character string in the synonym phrase corresponding with described the first preset group and described the second preset group in preset matching rule is present in step continuation execution in described first information description and described the second information description;
If not, export that the described first information is described and/or described the second information describe in described character string corresponding field.
Preferably, described method also comprises:
Described check result is shown.
An information check device, described device comprises:
Acquiring unit: for according to preset path, obtain the record ripple information table of target electric substation automation system;
The first determining unit: for according to preset rules, determine the information content that in the record ripple information table that described acquiring unit obtains, all working table records respectively, wherein, the described information content is the first distant metrical information, the first remote signalling amount information or the first remote control amount information, and described the first distant metrical information, described the first remote signalling amount information and described the first remote control amount information include: sequence number, the first information are described and remarks one to one;
Storage unit: for according to the type of the described information content, all sequence numbers one to one of described worksheet record, first information description and remarks are stored in the first corresponding preset group one by one, wherein, the first preset group comprises: the first remote measurement array, the first remote signalling array and the first remote control array;
Extraction unit: for reading the second distant metrical information, the second remote signalling amount information and the second remote control amount information of target database, extracting corresponding period and the second information describes, and store into respectively in the second corresponding preset group, wherein, described the second preset group comprises: the second remote measurement array, the second remote signalling array and the second remote control array;
Check unit: for regular according to preset matching, with the first information in the first preset group corresponding with described preset matching rule, be described as standard, one by one the second information in the second preset group corresponding with described the first preset group is described and checked, output check result.
Preferably, described extraction unit comprises:
Reading unit: for reading the second distant metrical information, the second remote signalling amount information and the second remote control amount information of target database;
Extract storage unit: for the second distant metrical information, the second remote signalling amount information and the second remote control amount information reading from described reading unit, extracting respectively corresponding period and the second information describes, and store in the second corresponding preset group, wherein, described the second preset group comprises: the second remote measurement array, the second remote signalling array and the second remote control array.
Preferably, described device also comprises:
The second determining unit: for according to described the first determining unit, obtain each described in the sequence number of worksheet, determine start-stop row and the termination row of the information content of described worksheet record;
Described storage unit is specifically for according to the type of the described information content, from the start-stop row of worksheet described in each to termination row, line by line the sequence number one to one of described worksheet record, first information description and remarks are stored in the first corresponding preset group.
Preferably, described check unit comprises:
The first judging unit: for judging the first information in the first preset group is described whether identical with the second information description in the second corresponding preset group;
The second judging unit: for when judgment result is that of described the first judging unit is not congruent, judge one by one whether the character string in the synonym phrase corresponding with described the first preset group and described the second preset group in preset matching rule is present in described first information description and described the second information description;
Processing unit: for when judgment result is that of described the second judging unit is, the character string that belongs to described synonym phrase deleted, and trigger the second judging unit in described first information description and described the second information description;
Output unit: when at described the second judging unit, the determination result is NO, export that the described first information is described and/or described the second information describe in described character string corresponding field.
Known via above-mentioned technical scheme, compared with prior art, the present invention openly provides a kind of information check method and device, after obtaining the record ripple information table of target electric substation automation system, according to preset rules, determine that the information content that in this record ripple information table, a plurality of worksheets record is respectively the first distant metrical information, the first remote signalling amount information or the first remote control amount information, again according to the type of the information content of record ripple information table record, by all sequence numbers one to one of a plurality of worksheet records, the first information is described and remarks store in the first corresponding preset group one by one, simultaneously, by reading the second distant metrical information in target database, the second remote signalling amount information and the second remote control amount information, and the second information is wherein described and stored into respectively in the second corresponding preset group, now, can be according to preset matching rule, with the first information in the first preset group corresponding with this preset matching rule, be described as standard, one by one the second information in the second preset group of correspondence is described and checked, output check result, thereby realized the distant metrical information in target database, the automatic Check that information in remote signalling amount information and remote control amount information is described, improved the accuracy of check result and checked efficiency, guaranteed the safe and reliable operation of transformer station, and greatly saved human cost.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, to the accompanying drawing of required use in embodiment or description of the Prior Art be briefly described below, apparently, accompanying drawing in the following describes is only embodiments of the invention, for those of ordinary skills, do not paying under the prerequisite of creative work, other accompanying drawing can also be provided according to the accompanying drawing providing.
Fig. 1 is the process flow diagram of a kind of information check method embodiment of the present invention;
Fig. 2 is the structural representation of a kind of information check device of the present invention embodiment.
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 clearly and completely described, obviously, described embodiment is only the present invention's part embodiment, rather than whole embodiment.Embodiment based in the present invention, those of ordinary skills, not making the every other embodiment obtaining under creative work prerequisite, belong to the scope of protection of the invention.
The embodiment of the invention discloses a kind of information check method and device, after obtaining the record ripple information table of target electric substation automation system, according to preset rules, determine that the information content that in this record ripple information table, a plurality of worksheets record is respectively the first distant metrical information, the first remote signalling amount information or the first remote control amount information, again according to the type of the information content of record ripple information table record, by all sequence numbers one to one of a plurality of worksheet records, the first information is described and remarks store in the first corresponding preset group one by one, simultaneously, by reading the second distant metrical information in target database, the second remote signalling amount information and the second remote control amount information, and the second information is wherein described and stored into respectively in the second corresponding preset group, now, can be according to preset matching rule, with the first information in the first preset group corresponding with this preset matching rule, be described as standard, one by one the second information in the second preset group of correspondence is described and checked, output check result, thereby realized the distant metrical information in target database, the automatic Check that information in remote signalling amount information and remote control amount information is described, improved the accuracy of check result and checked efficiency, guaranteed the safe and reliable operation of transformer station, and greatly saved human cost.
As shown in Figure 1, process flow diagram for a kind of information check method embodiment of the present invention, the check that the method can be described for information corresponding to the remote measurement amount to the regulator control system of transformer station, remote signalling amount and remote control amount, to avoid occurring malfunction in straighforward operation, for the operation of transformer station brings potential safety hazard, concrete, the method can comprise:
Step S11: according to preset path, obtain the record ripple information table of target electric substation automation system.
In actual applications, remote measurement amount, remote signalling amount and the remote control amount information recording of the electric substation automation system that conventionally all can just detect are in a record ripple information table, and this record ripple information table is stored under a preset path, to obtain this record ripple information table according to this preset path from now on, wherein, this records the normally form of excel form of ripple information table.
Step S12: according to preset rules, determine the information content that in described record ripple information table, all working table records respectively.
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 all can comprise: sequence number, the first information are described and remarks one to one.
In embodiments of the present invention; when record ripple information table is the form of excel form; conventionally can store respectively remote measurement amount, remote signalling amount and the remote control amount information detecting by different worksheets (being Sheet); that is to say; in each Sheet, only record the information content of a type; so in embodiments of the present invention, the information content that a plurality of worksheets record respectively can be 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, conventionally sequence number hurdle, information description bar and remarks column can be set, thereby when by this Sheet recorded information content, this sequence number hurdle can be from 1,2 ... wherein, N is positive integer to N() generate successively a plurality of sequence numbers; Information description bar is for record the flesh and blood of the remote measurement amount, remote signalling amount or the remote control amount information that collect at every turn; Remarks column, is used for recording some special circumstances or the information that pays particular attention to etc., so, no matter be the first distant metrical information, be the first remote signalling amount information, or the first remote control amount information include sequence number, the first information one to one and describe and remarks.
Step S13: according to the type of the information content, the first preset group corresponding to the sequence number one to one of all working table record, first information description and remarks store one by one into.
Wherein, this first preset group comprises: the 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, conventionally can be according to the sequence number in each Sheet, determine start-stop row and the termination row of the information content of its record, afterwards, will be according to the type of the information content recording in Sheet, from the start-stop row of each Sheet to termination row, line by line by the sequence number one to one of its record, the first information is described and remarks store in the first corresponding preset group, thereby make to record the information content recording in all Sheet in ripple information table and all have respectively the first remote measurement array, in the first remote signalling array and the first remote control array, so that follow-up, these three arrays are processed.
Wherein, the first remote measurement array, the first remote signalling array and the first remote control array can be stored in NbFesData.instance file, and the title of the first remote measurement array can can be xlsYkPoints for the title of xlsYxPoints, the first remote control array for the title of xlsYcPoints, the first remote signalling array.
Step S14: read the second distant metrical information, the second remote signalling amount information and the second remote control amount information in target database, extract corresponding period and the second information and describe, and store into respectively in the second corresponding preset group.
Wherein, the second preset group comprises: the second remote measurement array, the second remote signalling array and the second remote control array.
In actual applications, the information such as remote measurement amount, remote signalling amount and remote control amount of the transformer station collecting due to communication manager, conventionally be to be all stored in SCADA(Supervisory Control And Data Acquisition, data acquisition and control)/EMS(Energy Manangement System, energy management system) in database, so that dispatching center is according to these information of storing in this SCADA/EMS database, export correct regulation and control instruction, thereby guarantee the safe and reliable operation of this transformer station.So, in embodiments of the present invention, can be using SCADA/EMS database as target database, when the information of carrying out is checked, can directly read the second distant metrical information, the second remote signalling amount information and the second remote control amount information in this target database, and store into respectively in three different arrays.
Concrete, the embodiment of the present invention can read the text document that reflects remote measurement amount, remote signalling amount and remote control amount in target database line by line, extracting corresponding period and the second information describes, then, according to the type of the information extracting, the period of all correspondences that extract and the description of the second information are stored into respectively in the second remote measurement array, the second remote signalling array and the second remote control array, so that follow-up further processing.
Wherein, the second remote measurement array, the second remote signalling array and the second remote control array can be stored in NbFesData.instance file, and the type of the second remote measurement array can be AnalogPoints[], title can be YcPoints; The type of the second remote signalling array can be DiscretePoints[], title can be YxPoints; The type of the second remote control array can be YkInfo[], title can be YkPoints.
Step S15: according to preset matching rule, be described as standard with the first information in the first preset group corresponding with it, one by one the second information in the second preset group corresponding with the first preset group described and checked, output check result.
Wherein, this check result can show by a display, to facilitate staff to carry out corresponding processing according to its displaying contents.Preferably, the second information in target database is described while makeing mistakes, and can also export information warning, as voice messaging, to remind staff in time wrong information to be described and processed.
In the practical application of the embodiment of the present invention, conventionally all can set up the form that SynonymSets class is deposited synonym set, for same electric pressure (as 110kV or 220kV), three SynonymSets class forms can be set, for depositing respectively the synonym matched rule of remote signalling, telemetry and telecommand, so that in information check process, according to corresponding synonym matched rule, the information in remote signalling amount information, distant metrical information or remote control amount information is described and checked.So the preset matching rule described in the embodiment of the present invention can comprise: remote measurement synonym matched rule, remote signalling synonym matched rule and the remote control synonym matched rule of corresponding distant metrical information, remote signalling amount information and remote control amount information respectively.
Preferably, in order to improve the accuracy of information check, in the territory of each SynonymSets object, all can comprise three ArrayList<String[] >, be respectively used to storage and be applicable to deposit synonym phrase, the synonym phrase that is only applicable to prefix matching that matched position do not limit and the synonym phrase that is only applicable to suffix match.As can be seen here, each ArrayList is by a series of String[] character string formation, each character string in same character string array is synonym, all belongs to same SynonymSets.
Based on this, when the second information description in the second preset group is checked, specifically can first judge the first information in the first preset group is described whether identical with the second information description in the second corresponding preset group, if it is not congruent, judge one by one whether the character string in the synonym phrase corresponding with the first preset group and the second preset group in preset matching rule is present in first information description and described the second information description, if existed, directly the character string that belongs to this synonym phrase in first information description and the description of the second information is deleted, and continue as stated above to contrast, final output check result, if there is no, there is mistake in the second information description that the record in target database is described, now, can export the field corresponding with this character string in first information description and/or the description of the second information, to carry out corresponding processing according to this field, thereby guarantee the correctness according to the regulation and control instruction of this second descriptor output, make the transformer station can safe and reliable operation.
Wherein, it should be noted that, above-mentioned each array is all to record corresponding information with character string forms conventionally, so, in the embodiment of the present invention, the comparison that is relatively actually two character strings of the first preset group and the second preset group, and learn according to above-mentioned analysis, what the synonym phrase of preset matching rule recorded is also various character strings, thereby, in carrying out above-mentioned check process, be to take character as unit, contrast one by one, greatly improved the accuracy of checking.
The embodiment of the present invention is according to preset rules, determine that the information content that in this record ripple information table, all working table records is respectively the first distant metrical information, the first remote signalling amount information, or after the first remote control amount information, according to the type of the information content of record ripple information table record, by all sequence numbers one to one of worksheet record, the first information is described and remarks store in the first corresponding preset group one by one, simultaneously, by reading the second distant metrical information in target database, the second remote signalling amount information and the second remote control amount information, and the second information is wherein described and stored into respectively in the second corresponding preset group, now, can be according to preset matching rule, with the first information in the first preset group corresponding with this preset matching rule, be described as standard, one by one the second information in the second preset group of correspondence is described and checked, output check result, thereby realized the distant metrical information in target database, the automatic Check that information in remote signalling amount information and remote control amount information is described, improved the accuracy of check result and checked efficiency, guaranteed the safe and reliable operation of transformer station, and greatly saved human cost.
As shown in Figure 2, be the structural representation of a kind of information check device of the present invention embodiment, this device can comprise:
Acquiring unit S21: for according to preset path, obtain the record ripple information table of target electric substation automation system.
Wherein, this preset path can be absolute path or the relative path of the record ripple information table of known storage target electric substation automation system, and this record ripple information tableau format is generally excel form.
The first determining unit S22: for according to preset rules, determine the information content that in the record ripple information table that acquiring unit S21 obtains, a plurality of worksheets record 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 first distant metrical information, the first remote signalling amount information and the first remote control amount information all can comprise: sequence number, the first information are described and remarks one to one.
Storage unit S23: for according to the type of the information content, all sequence numbers one to one of all working table record in this record ripple information table, first information description and remarks are stored in the first corresponding preset group one by one.
Wherein, the first preset group comprises: the first remote measurement array, the first remote signalling array and the first remote control array, respectively distant metrical information, remote signalling amount information and the remote control amount information in reaction record ripple information table.What in actual applications, the first remote measurement array, the first remote signalling array and the first remote control array recorded conventionally is the character string that corresponding information is described.
Extraction unit S24: for reading the second distant metrical information, the second remote signalling amount information and the second remote control amount information of target database, extract corresponding period and the second information and describe, and store into respectively in the second corresponding preset group.
Wherein, the second preset group comprises: the second remote measurement array, the second remote signalling array and the second remote control array, what in the second remote measurement array, the second remote signalling array and the second remote control array, conventionally store in actual applications, is the character string of describing for reacting corresponding informance.
Check cell S 25: for regular according to preset matching, with the first information in the first preset group corresponding with it, be described as standard, one by one the second information in the second preset group corresponding with this first preset group is described and checked, output check result.
Wherein, extraction unit S24 can comprise:
Reading unit S241: for reading the second distant metrical information, the second remote signalling amount information and the second remote control amount information of target database.
Extract storage unit S242: for the second distant metrical information, the second remote signalling amount information and the second remote control amount information reading from reading unit S241, extract respectively corresponding period and the second information and describe, and store in the second corresponding preset group.
Wherein, this second preset group comprises: the second remote measurement array, the second remote signalling array and the second remote control array.
Preferably, as further embodiment of this invention, on the basis of the information check device described in the invention described above embodiment, this information check device can also comprise:
The second determining unit: for according to the first determining unit S22, obtain each described in the sequence number of worksheet, determine start-stop row and the termination row of the information content of described worksheet record.
Storage unit S23 is specifically for according to the type of the information content of record ripple information table record, from the start-stop row of each worksheet to termination row, line by line the sequence number one to one of all working table record, first information description and remarks are stored in the first corresponding preset group.
Preferably, the check cell S 25 described in the embodiment of the present invention can also comprise:
The first judging unit S251: for judging the first information in the first preset group is described whether identical with the second information description in the second corresponding preset group.
The second judging unit S252: for when judgment result is that of the first judging unit S251 is not congruent, judge one by one whether the character string in the synonym phrase corresponding with the first preset group and the second preset group in preset matching rule is present in the first information description of this first preset group and the second information description of the second preset group.
Processing unit S253: for when judgment result is that of the second judging unit S252 is, the character string that belongs to this synonym phrase deleted, and trigger the second judging unit S252 in first information description and the description of the second information.
Output unit S254: when at the second judging unit S253, the determination result is NO, the output first information is described and/or the second information describe in this character string corresponding field.
Wherein, in actual applications, can to check result, show by display, so that staff can see check result intuitively, and correspondingly process.
The embodiment of the present invention is obtained the record ripple information table of target electric substation automation system by acquiring unit, and send to the first determining unit, so that according to preset rules, determine that the information content that in this record ripple information table, a plurality of worksheets record is respectively the first distant metrical information, the first remote signalling amount information, or the first remote control amount information, afterwards, the type of the information content recording according to record ripple information table by storage unit again, by all sequence numbers one to one of all working table record, the first information is described and remarks store in the first corresponding preset group one by one, simultaneously, the present invention also by extraction unit by the second distant metrical information reading from target database, the second remote signalling amount information and the second remote control amount information, store into respectively in the second corresponding preset group, afterwards, can be by checking unit according to preset matching rule, one by one the second information in this second preset group is described and checked, obtain check result, compare with the mode of existing artificial check, the present invention has realized the distant metrical information in target database by information check device, the automatic Check that information in remote signalling amount information and remote control amount information is described, improved the accuracy of check result and checked efficiency, guaranteed the safe and reliable operation of transformer station.
Wherein, it should be noted that, the above embodiment of the present invention is a kind of exemplary example, should be as restriction, and given particular content should in no way limit the application's object.For example, the division of described unit, is only that a kind of logic function is divided, and during actual realization, can have other dividing mode, and for example a plurality of unit combine.In addition, a plurality of unit can or assembly can in conjunction with or can be integrated into another system, or some features can ignore, or do not carry out.And; in this article; term " comprises ", " comprising " or its any other variant are intended to contain comprising of nonexcludability; thereby the process, method, article or the equipment that make to comprise a series of key elements not only comprise those key elements; but also comprise other key elements of clearly not listing; or be also included as the intrinsic key element of this process, method, article or equipment; at this, will repeat no longer one by one; those skilled in the art creative make great efforts to determine so long as not paying, and all belong to protection scope of the present invention.
In this instructions, each embodiment adopts the mode of going forward one by one to describe, and each embodiment stresses is the difference with other embodiment, between each embodiment identical similar part mutually referring to.For the disclosed device of embodiment, because it corresponds to the method disclosed in Example, so description is fairly simple, relevant part partly illustrates referring to method.
Above-mentioned explanation to the disclosed embodiments, makes professional and technical personnel in the field can realize or use the present invention.To the multiple modification of these embodiment, will be apparent for those skilled in the art, General Principle as defined herein can, in the situation that not departing from the spirit or scope of the present invention, realize in other embodiments.Therefore, the present invention will can not be restricted to these embodiment shown in this article, but will meet the widest scope consistent with principle disclosed herein and features of novelty.
Claims (10)
1. an information check method, is characterized in that, described method comprises:
According to preset path, obtain the record ripple information table of target electric substation automation system;
According to preset rules, determine the information content that in described record ripple information table, all working table records respectively, wherein, the described information content is the first distant metrical information, the first remote signalling amount information or the first remote control amount information, and described the first distant metrical information, described the first remote signalling amount information and described the first remote control amount information include: sequence number, the first information are described and remarks one to one;
According to the type of the described information content, all sequence numbers one to one of described worksheet record, first information description and remarks are stored in the first corresponding preset group one by one, wherein, described the first preset group comprises: the first remote measurement array, the first remote signalling array and the first remote control array;
Read the second distant metrical information, the second remote signalling amount information and the second remote control amount information in target database, extracting corresponding period and the second information describes, and store respectively the second corresponding preset group into, wherein, described the second preset group comprises: the second remote measurement array, the second remote signalling array and the second remote control array;
According to preset matching rule, with the first information in the first preset group corresponding with described preset matching rule, be described as standard, one by one the second information in the second preset group corresponding with described the first preset group is described and checked, output check result.
2. method according to claim 1, it is characterized in that, according to preset rules, after determining the information content that in described record ripple information table, all working table records respectively, and according to the type of the described information content, before all sequence numbers one to one of described worksheet record, first information description and remarks are stored in the first corresponding preset group one by one, described method also comprises:
According to the sequence number of worksheet described in each, determine start-stop row and the termination row of the information content of described worksheet record;
Described according to the type of the described information content, all sequence numbers one to one of described worksheet record, first information description and remarks are stored into one by one in the first corresponding preset group and are specially:
According to the type of the described information content, from the start-stop row of worksheet described in each to termination row, line by line the sequence number one to one of described worksheet record, first information description and remarks are stored in the first corresponding preset group.
3. method according to claim 2, is characterized in that, described preset matching rule comprises:
Remote measurement synonym matched rule, remote signalling synonym matched rule and the remote control synonym matched rule of difference corresponding distant metrical information, remote signalling amount information and remote control amount information.
4. method according to claim 3, it is characterized in that, described remote measurement synonym matched rule, remote signalling synonym matched rule and remote control synonym matched rule include: be applicable to deposit synonym phrase, the synonym phrase that is only applicable to prefix matching that matched position do not limit and the synonym phrase that is only applicable to suffix match.
5. method according to claim 4, it is characterized in that, described according to preset matching rule, with the first information in the first preset group corresponding with described preset matching rule, be described as standard, one by one the second information in the second preset group corresponding with described the first preset group described to check being specially:
Judge the first information in the first preset group is described whether identical with the second information description in the second corresponding preset group;
If not congruent, judge one by one whether the character string in the synonym phrase corresponding with described the first preset group and described the second preset group in preset matching rule is present in described first information description and described the second information description;
If, the character string that belongs to described synonym phrase in described first information description and described the second information description is deleted, and described in returning, judge one by one whether the character string in the synonym phrase corresponding with described the first preset group and described the second preset group in preset matching rule is present in step continuation execution in described first information description and described the second information description;
If not, export that the described first information is described and/or described the second information describe in described character string corresponding field.
6. according to the method described in claim 1-5 any one, it is characterized in that, described method also comprises:
Described check result is shown.
7. an information check device, is characterized in that, described device comprises:
Acquiring unit: for according to preset path, obtain the record ripple information table of target electric substation automation system;
The first determining unit: for according to preset rules, determine the information content that in the record ripple information table that described acquiring unit obtains, all working table records respectively, wherein, the described information content is the first distant metrical information, the first remote signalling amount information or the first remote control amount information, and described the first distant metrical information, described the first remote signalling amount information and described the first remote control amount information include: sequence number, the first information are described and remarks one to one;
Storage unit: for according to the type of the described information content, all sequence numbers one to one of described worksheet record, first information description and remarks are stored in the first corresponding preset group one by one, wherein, the first preset group comprises: the first remote measurement array, the first remote signalling array and the first remote control array;
Extraction unit: for reading the second distant metrical information, the second remote signalling amount information and the second remote control amount information of target database, extracting corresponding period and the second information describes, and store into respectively in the second corresponding preset group, wherein, described the second preset group comprises: the second remote measurement array, the second remote signalling array and the second remote control array;
Check unit: for regular according to preset matching, with the first information in the first preset group corresponding with described preset matching rule, be described as standard, one by one the second information in the second preset group corresponding with described the first preset group is described and checked, output check result.
8. device according to claim 7, is characterized in that, described extraction unit comprises:
Reading unit: for reading the second distant metrical information, the second remote signalling amount information and the second remote control amount information of target database;
Extract storage unit: for the second distant metrical information, the second remote signalling amount information and the second remote control amount information reading from described reading unit, extracting respectively corresponding period and the second information describes, and store in the second corresponding preset group, wherein, described the second preset group comprises: the second remote measurement array, the second remote signalling array and the second remote control array.
9. device according to claim 7, is characterized in that, described device also comprises:
The second determining unit: for according to described the first determining unit, obtain each described in the sequence number of worksheet, determine start-stop row and the termination row of the information content of described worksheet record;
Described storage unit is specifically for according to the type of the described information content, from the start-stop row of worksheet described in each to termination row, line by line the sequence number one to one of described worksheet record, first information description and remarks are stored in the first corresponding preset group.
10. device according to claim 9, is characterized in that, described check unit comprises:
The first judging unit: for judging the first information in the first preset group is described whether identical with the second information description in the second corresponding preset group;
The second judging unit: for when judgment result is that of described the first judging unit is not congruent, judge one by one whether the character string in the synonym phrase corresponding with described the first preset group and described the second preset group in preset matching rule is present in described first information description and described the second information description;
Processing unit: for when judgment result is that of described the second judging unit is, the character string that belongs to described synonym phrase deleted, and trigger the second judging unit in described first information description and described the second information description;
Output unit: when at described the second judging unit, the determination result is NO, export that the described first information is described and/or described the second information describe in described character string corresponding field.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310718946.7A CN103678655B (en) | 2013-12-23 | 2013-12-23 | Method and device for verifying information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310718946.7A CN103678655B (en) | 2013-12-23 | 2013-12-23 | Method and device for verifying information |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103678655A true CN103678655A (en) | 2014-03-26 |
| CN103678655B CN103678655B (en) | 2017-02-08 |
Family
ID=50316199
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310718946.7A Active CN103678655B (en) | 2013-12-23 | 2013-12-23 | Method and device for verifying information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103678655B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105117827A (en) * | 2015-08-05 | 2015-12-02 | 国网浙江省电力公司 | System and method for checking monitoring information tables of transformer station |
| CN106296457A (en) * | 2016-08-12 | 2017-01-04 | 新疆信息产业有限责任公司 | Save and adjust automated information checking method |
| CN106682033A (en) * | 2015-11-10 | 2017-05-17 | 北京国双科技有限公司 | Knowledge base check method and device |
| CN112579376A (en) * | 2020-12-16 | 2021-03-30 | 中国建设银行股份有限公司 | Double-run-stage data verification method, system, equipment and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2002297660A (en) * | 2001-01-24 | 2002-10-11 | Sumitomo Electric Ind Ltd | Method, device, program, and recording medium for character similarity calculation |
| CN1920793A (en) * | 2005-08-25 | 2007-02-28 | 国际商业机器公司 | Device and method for implementing test scenarios replay in different voice environment |
| CN101930435A (en) * | 2009-10-27 | 2010-12-29 | 深圳市北科瑞声科技有限公司 | Method and system for retrieving organization names |
| CN101963962A (en) * | 2009-07-23 | 2011-02-02 | 高德软件有限公司 | Interest point data association method and device |
| CN102122298A (en) * | 2011-03-07 | 2011-07-13 | 清华大学 | Method for matching Chinese similarity |
| CN102184169A (en) * | 2011-04-20 | 2011-09-14 | 北京百度网讯科技有限公司 | Method, device and equipment used for determining similarity information among character string information |
-
2013
- 2013-12-23 CN CN201310718946.7A patent/CN103678655B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2002297660A (en) * | 2001-01-24 | 2002-10-11 | Sumitomo Electric Ind Ltd | Method, device, program, and recording medium for character similarity calculation |
| CN1920793A (en) * | 2005-08-25 | 2007-02-28 | 国际商业机器公司 | Device and method for implementing test scenarios replay in different voice environment |
| CN101963962A (en) * | 2009-07-23 | 2011-02-02 | 高德软件有限公司 | Interest point data association method and device |
| CN101930435A (en) * | 2009-10-27 | 2010-12-29 | 深圳市北科瑞声科技有限公司 | Method and system for retrieving organization names |
| CN102122298A (en) * | 2011-03-07 | 2011-07-13 | 清华大学 | Method for matching Chinese similarity |
| CN102184169A (en) * | 2011-04-20 | 2011-09-14 | 北京百度网讯科技有限公司 | Method, device and equipment used for determining similarity information among character string information |
Non-Patent Citations (1)
| Title |
|---|
| 齐丹丹等: ""调度集控自动化异构系统数据一致性校验软件设计"", 《广东电力》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105117827A (en) * | 2015-08-05 | 2015-12-02 | 国网浙江省电力公司 | System and method for checking monitoring information tables of transformer station |
| CN106682033A (en) * | 2015-11-10 | 2017-05-17 | 北京国双科技有限公司 | Knowledge base check method and device |
| CN106296457A (en) * | 2016-08-12 | 2017-01-04 | 新疆信息产业有限责任公司 | Save and adjust automated information checking method |
| CN112579376A (en) * | 2020-12-16 | 2021-03-30 | 中国建设银行股份有限公司 | Double-run-stage data verification method, system, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103678655B (en) | 2017-02-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102654544B (en) | Automatic identification model and method for switchhouse user change relationship | |
| CN102545213B (en) | System and method for managing line loss of power grid in real time | |
| CN102608962B (en) | A kind of power information collecting device automatic maintenance method from bottom to top | |
| CN102043719B (en) | Method for testing IEC61850 configuration description file | |
| CN103729805A (en) | 500kV intelligent substation security arrangement ticket expert system | |
| CN103678655A (en) | Method and device for verifying information | |
| CN103760874A (en) | Method for locating meter reading fault source of low-voltage area | |
| CN202615415U (en) | Full lifecycle management system of electric automobile power cell and based on Internet of Things | |
| CN103985068A (en) | Online risk evaluation method for power distribution network | |
| CN101944128A (en) | Data export and import method and device | |
| CN106501760A (en) | A kind of electrical energy meter fault management-control method and system | |
| CN108037343A (en) | A kind of voltage monitoring Management System Data deepens analysis method | |
| CN103914758B (en) | Carrier wave collector asset fine management method | |
| CN111667143A (en) | Method for realizing fusion of real-time monitoring data and service management data in power grid dispatching | |
| CN107944659B (en) | Method and device for automatically generating plant station monitoring system report | |
| CN112560214A (en) | Transformer substation bus balance fault diagnosis method, system, equipment and storage medium | |
| CN104392603B (en) | A kind of live power information collecting device intelligent diagnosis system | |
| CN103020721A (en) | Method for evaluating real-time data processing efficiency of power grid dispatching automation system | |
| CN102902801B (en) | Voltmeter address retrieval method, related equipment and system | |
| CN103700024A (en) | Automatic importing method of provincial and prefectural integrated telecontrol information based on D5000 system | |
| CN204649936U (en) | A kind of plurality of groups of storage batteries fast inspection device | |
| CN106202814B (en) | The mapping method of automatic safety device acquisition data and EMS system primary equipment model | |
| CN103928986A (en) | Error correcting and checking system for power grid dispatching wiring diagram and checking method thereof | |
| CN107016066A (en) | Measuring point matching process and device in a kind of electric network model modeling process | |
| CN103840555B (en) | Based on the low-voltage method for early warning of threshold value setting |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C41 | Transfer of patent application or patent right or utility model | ||
| CB03 | Change of inventor or designer information |
Inventor after: Li Jihong Inventor after: Zhou Xing Inventor after: Jiang Hao Inventor after: Sheng Haijing Inventor after: Jiao Xuming Inventor after: Yang Xiang Inventor after: Yang Jinjing Inventor after: Dong Shufeng Inventor after: Hong Jianguang Inventor after: Kong Xiaoyun Inventor after: Qi Jun Inventor after: Mao Nanping Inventor after: Li Fengwei Inventor after: Chen Donghai Inventor after: Zhang Duxi Inventor after: Zhou Yang Inventor before: Qi Jun Inventor before: Jiao Xuming Inventor before: Yang Xiang Inventor before: Yang Jinjing Inventor before: Dong Shufeng Inventor before: Mao Nanping Inventor before: Li Fengwei Inventor before: Chen Donghai Inventor before: Zhang Duxi Inventor before: Zhou Yang Inventor before: Zhou Xing Inventor before: Jiang Hao Inventor before: Sheng Haijing |
|
| COR | Change of bibliographic data | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20161230 Address after: 310007 Huanglong Road, Zhejiang, Hangzhou, No. 8 Applicant after: State Grid Zhejiang Electric Power Company Applicant after: State Power Networks Co Applicant after: Ningbo Power Supply Company of State Grid Zhejiang Electric Power Company Address before: 100031 Xicheng District West Chang'an Avenue, No. 86, Beijing Applicant before: State Power Networks Co Applicant before: Ningbo Power Supply Company of State Grid Zhejiang Electric Power Company |
|
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |