CN101197875A - Partial data checking method and device - Google Patents
Partial data checking method and device Download PDFInfo
- Publication number
- CN101197875A CN101197875A CNA2007103056456A CN200710305645A CN101197875A CN 101197875 A CN101197875 A CN 101197875A CN A2007103056456 A CNA2007103056456 A CN A2007103056456A CN 200710305645 A CN200710305645 A CN 200710305645A CN 101197875 A CN101197875 A CN 101197875A
- Authority
- CN
- China
- Prior art keywords
- data
- office data
- verify
- office
- verification
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Data Exchanges In Wide-Area Networks (AREA)
Abstract
The embodiment of the invention provides an office data verification method which comprises that: the office data is collected to generate the office data to be verified; a verification rule which is preset and used to verify the office data to be verified is read; the office data to be verified is verified according to the verification rule, then the verification result is obtained. The invention embodiment also provides an office verification device. In the embodiment of the invention, verification to the office data based on the preset verification rule can boost the expansibility of the verification scheme, effectively reduce the working burden of programming personnel and assure the accuracy of the verification result.
Description
Technical field
The present invention relates to communication technical field, relate in particular to a kind of office data checking method and device.
Background technology
Office data is the data relevant with traffic route, signalling route, object code, user and roaming or the like communications transaction.Communication equipment in the office, as switch, gateway or the like, need be behind the configuration office data, can be used to realize with his office's switch or gateway or the like communication equipment between communicate by letter.In view of office data to realizing the importance of communication, therefore, the office data that is disposed in the requirement office is correct and complete, for this reason, need verify processing to the office data that is disposed, with the correctness and the integrality of the office data guaranteeing to be configured.
Traditional verification office data checking way is artificial verification, owing to need the office data quantity of verification very big usually, the office data type is various, and therefore, efficient is lower on the one hand in artificial verification, and inspector's work is heavy; On the other hand, the artificial effect of verifying is unsatisfactory, and it is inaccurate to cause verifying the result easily.
Prior art is improved traditional artificial verification way, promptly at every kind of office data, write the verification procedures that are used to verify this kind office data, and provide graphic user interface (GUI, Graphical UserInterface), make things convenient for the inspector to verify office data, alleviate inspector's work load, also can improve the accuracy of verifying the result.But, in the prior art, verification procedures are usually at certain or some office datas, dissimilar office datas just need be write different verification procedures, because the type of office data is various usually, and along with development of Communication Technique, the type of office data is still constantly increasing, and the verification procedures personnel of writing need write verification procedures at increasing various office datas, and task is heavy.Links such as beginning of communication system, upgrading and cutover, often being faced with needs to verify a large amount of office datas, as number analysis table, service provider (SP, Service Provider) business datum, WAP (wireless application protocol) (WAP, Wireless Application Protocol) gateway data etc., the inspector can only carry out the step that repeats to each table on the interface, and process is loaded down with trivial details, workload is big, and efficient is low.
Therefore, existing office data checking technology extensibility is relatively poor, and it is not high to verify efficient.
Summary of the invention
The embodiment of the invention provides a kind of office data checking method, comprising:
Gather office data, generate office data to be verified;
Read set in advance be used to verify the verification rule of waiting to verify office data;
According to described verification rule, verify office data described to be verified, draw the verification result.
The embodiment of the invention provides a kind of office data checking device, comprising: data acquisition unit, data generating unit, the rale store unit, verify unit and output unit as a result; Wherein,
Described data acquisition unit is gathered office data to be verified;
Described data generating unit, the described office data that utilizes described data acquisition unit to collect generates office data to be verified;
Described rale store unit, the verification rule that storage sets in advance;
Described verification unit reads the described described verification rule of waiting to verify office data and the storage of described rale store unit that described data acquisition unit collects, and according to described verification rule, verifies office data described to be verified;
Output unit as a result, the verification result output that described verification unit is obtained.
Office data checking method that the embodiment of the invention is given and device, by the verification of computer program realization to office data, be to comprise soft unit in the office data checking device, promptly verify the unit, this verification unit can comprise two inputs, be the reading of data collecting unit collect wait to verify the office data end, and read and verify the rule end, verify the unit based on the information that reads from two inputs, utilize the verification rule to verify office data to be verified, and the result is verified in output, therefore, from the programming angle, the function of verifying the unit can realize by one-off programming, and wait to verify office data and corresponding verification rule all is variable, in scope verification rule, the span of verifying field can corresponding according to actual needs adjustment, the text formatting of the verification field of content verification rule Chinese version class also can be according to the corresponding adjustment of actual conditions, can increase more a plurality of verification rules, can delete certain and verify rule, can increase the verification field, can delete some and verify field or the like, thereby promote the extensibility of verification scheme greatly, and effectively reduce programming personnel's work load, guarantee to verify result's accuracy simultaneously.
Description of drawings
Fig. 1 is an office data checking method flow chart in the embodiment of the invention
Fig. 2 is the structural representation of office data checking device in the embodiment of the invention;
Fig. 3 is the flow chart of verifying office data in the embodiment of the invention;
Fig. 4 is the example schematic that the template base attribute is verified in definition in the embodiment of the invention;
Fig. 5 is the example schematic that field is verified in definition in the embodiment of the invention;
Fig. 6 is the example schematic that the field attribute of field is verified in definition in the embodiment of the invention;
Fig. 7 is the example schematic that rule is verified in definition in the embodiment of the invention;
Fig. 8 is a flow chart of gathering office data in the embodiment of the invention from existing network;
Fig. 9 is the example schematic of gathering office data in the embodiment of the invention from existing network;
Figure 10 generates the flow chart of waiting to verify office data in the embodiment of the invention;
Figure 11 utilizes the flow chart of waiting to verify office data with reference to office data checking in the embodiment of the invention;
Figure 12 be embodiment of the invention center come to an end the fruit example schematic.
Embodiment
Below in conjunction with accompanying drawing the technical scheme that the embodiment of the invention provides is described in further detail.
The embodiment of the invention provides the verification scheme of office data.In the embodiment of the invention, adopt to set in advance to be used to verify the verification rule of waiting to verify office data,, verify office data to be verified based on verifying rule.
Referring to Fig. 1, Fig. 1 is an office data checking method flow chart in the embodiment of the invention, and this flow process can may further comprise the steps:
In the embodiment of the invention, verify rule and provided the verification request that need satisfy as correct office data, then treat the verification of verifying office data, can be to verify or judge describedly to wait to verify office data and whether be consistent with described verification request, if meet, it is correct for waiting to verify office data then to draw described verification result, otherwise drawing described verification result is the described office data mistake of waiting to verify.
In the embodiment of the invention, verify rule and can be divided into condition class verification rule, and data class is verified rule.The regular verification request that is meant that the verification rule provides of so-called condition class verification is presented as to verify waits to verify the constraints of office data, waits to verify office data by verification during verification and whether satisfies this constraints, judges whether correctly.So-called data class is verified rule and is meant that what verify that rule provides is concrete reference office data, and whether wait to verify office data by verification during verification identical with the reference office data, judges whether wait to verify office data correct.In the practical application, can the condition class only be set verify rule, data class also can only be set verify rule, the condition class perhaps both can be set verify rule, data class is set again verifies rule according to actual conditions.
In the embodiment of the invention, the way of gathering office data can be manually to import office data, the storage office data; Perhaps, from existing network, obtain office data, send the request of obtaining office data as network communication equipment, the office data that reception and storage networking communication equipment return to the office data place.
Because it is normally various that waiting of collecting verified the form of expression of data, therefore,, need generate office data to be verified based on the office data that collects for ease of verifying office data.In the embodiment of the invention, a kind of standardization describing mode of office data be can set in advance, in this standardization describing mode, data format that office data to be verified need adopt, data type or the like defined.
Corresponding with the office data checking method that the embodiment of the invention is provided, the embodiment of the invention provides a kind of office data checking device.Referring to Fig. 2, Fig. 2 is the structural representation of this device, and this device can comprise:
Data acquisition unit, data generating unit, are verified unit and output unit as a result at the rale store unit; Wherein,
Described data acquisition unit is gathered office data to be verified;
Described data generating unit, the described office data that utilizes described data acquisition unit to collect generates office data to be verified;
Described rale store unit, the verification rule that storage sets in advance;
Described verification unit reads the described described verification rule of waiting to verify office data and the storage of described rale store unit that described data acquisition unit collects, and according to described verification rule, verifies office data described to be verified;
Output unit as a result, the verification result output that described verification unit is obtained.
Described verification unit comprises: read subelement and verify subelement; Described verification rule provides the verification request that need satisfy as correct office data;
The described subelement that reads reads the described regular described verification request that provides of described verification of waiting to verify office data and the storage of described rale store unit that described data acquisition unit collects;
Described verification subelement, verify described read that subelement reads wait whether verify office data is consistent with the described verification request that reads, if meet, it is correct for waiting to verify office data then to draw described verification result, otherwise drawing described verification result is the described office data mistake of waiting to verify.
Described data generating unit comprises following any unit or combination in any: Data Format Transform unit, delete cells, data type conversion unit;
Described Data Format Transform unit is the defined data format corresponding to this office data of described standardization describing mode with the Data Format Transform of described office data;
Described delete cells, if a plurality of office datas that collected are corresponding to multiple field, and multiple field comprises and more than the multiple field that defines in the described standardization describing mode, then the office data of the field correspondence that do not comprise in the described standardization describing mode is deleted from described a plurality of office datas;
Described data type conversion unit is the defined data type corresponding to this office data of described standardization describing mode with the data type conversion of described office data.
Described data acquisition unit is preserved the office data described to be verified that is transfused to;
Or described data acquisition unit comprises request transmitting unit and receiving element;
The described request transmitting element is to waiting that verifying the office data place network equipment sends the described request of waiting to verify office data of obtaining;
Described reception processing unit receives and stores the office data described to be verified that the described network equipment returns.
Describe the specific implementation of the office data checking technical scheme that the embodiment of the invention provides below in detail.
In the embodiment of the invention, the visual verification template based on setting in advance makes things convenient for inspector's verification work.
Referring to Fig. 3, Fig. 3 is the flow chart of verifying office data in the embodiment of the invention, and this flow process can may further comprise the steps:
In the embodiment of the invention, the verification template is set comprises: rule is verified in definition standardization describing mode, definition.In the embodiment of the invention, be preferably based on the Excel form, write the verification template, make the verification template visual, that is, verify template and describe by the Excel form document.
Referring to table one, table one has been enumerated a verification template that adopts the Excel form document to describe.
| Verify field name | |
| Verify field identification | |
| Whether be keyword | |
| Whether need to verify | |
| Scope verification rule | |
| Content verification rule | |
| Other logic rules | |
| Other control laws | |
| Data area first row | |
| Data area second row | |
| … | |
| N is capable in the data area |
Table one
Table one comprises multinomial verification rule and is used to describe a plurality of description entrys of waiting to verify office data from content disposition, from in form, table one can be divided into two zones, whether whether the first area has been enumerated a plurality of condition classes and has been verified rule as scope verification rule, content verification rule, and need the verification field name of verifying, sign (ID), the office data that is used for a verification of unique identification field to be keyword, to verify or the like in a plurality of description entrys of office data such as the office data; In the practical application, other logic rules, control law or the like condition class can be set as required verify rule; Second area is the data area, is used for configuration with reference to office data.As previously mentioned, for verifying rule, in the practical application, can a configuration condition class verify rule, also only configuration is with reference to office data, or not only the configuration condition class had been verified rule but also disposed with reference to office data.
Correspondingly, in the standardization describing mode of office data, data format is preferably Excel list data form.
In the practical application, also can adopt txt, xml or the like describing mode to describe and verify template.
Template is verified in step 302, definition.
Referring to table two, table two has been enumerated the example of verifying template, supposes that this verification template is used to verify registered user's dependent office data.The pairing field of different office datas can comprise termination number, logon mode, number of the account, password, black and white lists selection or the like, with reference to the corresponding field of office data possibility, five kinds of verification fields in the template are verified in definition, be respectively that termination number, logon mode, number of the account, password and black and white lists are selected, corresponding to these five kinds verification fields, definition is verified and is used in the template verifying Field ID in a kind of field of verification process unique identification; Whether at every kind of verification field, defining this verification field is critical field; At various verification fields, whether in this verify need verify, can be used for not needing to verify owning administration's data conditions if defining this verification field, reduce unnecessary verification process, improves and verify efficient; Definition is used to verify the condition class of respectively verifying field and verifies rule, as the span of termination number, format specification of number of the account or the like; If can provide with reference to office data, one of definable or multinomial with reference to office data, and with every with reference to each field in the office data corresponding to verifying the field name discharging.
| Verify field name | Termination number | Logon mode | Number of the account | Password | Black and white lists is selected |
| Verify Field ID | phone-number | register- type | account | password | screen- chioce |
| Whether be keyword | yes | no | no | no | no |
| Whether verify | yes | yes | yes | yes | no |
| Scope verification rule | [0，4] | 0|1 | |||
| Content verification rule | 8613[0-9]{10} | [a-z]{1}\w{31} | [a-z]{1}\w{15} | ||
| Other logic rules | |||||
| Data area first row | 8611381563657 7 | 1 | shimei | MDA30Tg5 | 0 |
| Data area second row | 8611381563657 8 | 3 | ylj50755 | NTkxMzEw | 0 |
| Data area the third line | 8611381563657 9 | 3 | zyxcse | MTcONTMw | 0 |
Table two
Below to how definite condition class verification rule is described further.For scope verification rule, usually, be numeric type as verifying field, then definable verifies how many maximums that field is allowed to is, how many minimum values is.As to verify field be the text type, and definable is verified the text size of field, is to be no more than how many characters as the text size maximum, and text formatting of field or the like is verified in definition.Scope verification rule is set as the case may be, logon mode as the registered user has five kinds, represent a logon mode respectively with 0 to 4 five numeral, the span of this verification field of then correct logon mode should be not less than 0, and is not more than 4, and is integer, particularly, this scope verification rule can be expressed as [0,4], also can adopt other expression modes; It can be 0 or 1 that correct black and white lists is selected the value of this verification field.In the practical application, if include a plurality of verification requests in the scope verification rule, then express this scope verification rule with logic, relational operator such as or or and etc., as value between 0 to 255 and be not equal to 100, just can be expressed as " [0,255] and!=100 ".
Content verification rule embodies the verification request of the data content of playing a game, and can be used for verifying the situation that field structure is complicated or require to verify particular content in the office data and be difficult to embody with scope verification rule.Can be used for retraining the text formatting of verifying field as content verification rule, as must be with beginning of letter, the position, end must be a numeral etc.In the table two, require the terminal verification number whether to satisfy the verification condition, this verification condition is that number section of termination number need be certain number section in 10 numbers sections of 130 to 139, therefore, need be by content verification rule be set, embodiment is to the verification request of termination number, particularly, this content verification rule list is shown " 8613[0-9] 10} ". in the practical application; Adopt regular expression; Can represent to comprise the verification rule of numerous verification requests; The IP address such as office data to be verified; Verification condition to the IP address is to comprise 4 bytes; And each byte is between 0 to 255; ，Java （regular expression）： （ （ （2[0-4] \ \ d）| （25[0-5]））| （1 \ \ d{2}）| （[1-9] \ \ d）| （ \ \ d））[.] （ （ （2[0-4] \ \ d）| （25[0-5]））| （1 \ \ d{2}）| （[1-9] \ \ d）| （ \ \ d））[.] （ （ （2[0-4] \ \ d）| （25[0-5]））| （1 \ \ d{2}）| （[1-9] \ \ d）| （ \ \ d））[.] （ （ （2[0-4] \ \ d）| （25[0-5]））| （1 \ \ d{2}）| （[1-9] \ \ d）| （ \ \ d））。
In the practical application,, then can in verifying template, add corresponding verification rule if also be provided with other verification rules at verifying field more conveniently.In the table two, further provided each and verified the reference office data of field, in the practical application,, can further be appended to the corresponding position of table two if also have other with reference to office data.
Above-mentioned steps 301 to step 302 is in the embodiment of the invention, be provided with and define the explanation of verifying template, whole process can be used to describe the Excel file of verifying template and carries out based on visual, in the practical application, also can use other visual interface editing instrument definitions to verify template, relevant information with defined verification template imports to by in the file in the verification template of Excel file description then, and illustrative example is as follows:
1, the base attribute of template is verified in definition, and referring to Fig. 4, Fig. 4 is the example schematic that the template base attribute is verified in definition in the embodiment of the invention.Among Fig. 4, based on the visualization interface edit tool, prompting user input template title comprises the base attribute of the title of verifying template, affiliated Business Name, affiliated NE type, producer, Production Time or the like verification template.After the user finishes the base attribute of verifying template and is provided with, click " preservations ", by the set information of system's preservation
2, the verification field in the template is verified in definition, abbreviates the definition template field as, comprises title, the verification Field ID of definition verification field, the define field attribute.
Referring to Fig. 5, Fig. 5 is the example schematic that field is verified in definition in the embodiment of the invention.Among Fig. 5, visualization interface edit tool prompting user imports and verifies field (being called for short field among Fig. 5) title, Field ID.After the user sets up relevant information, click " preservation ", preserve set information by system.
Referring to Fig. 6, Fig. 6 is the example schematic that the field attribute of field is verified in definition in the embodiment of the invention.Whether so-called field attribute can comprise verifies whether field is critical field, need to verify or the like.Based on visualization interface edit tool shown in Figure 6, it is critical field that the user can be provided with termination number, and all verification fields are set to be needed to verify.After the user sets up relevant information, click " preservation ", preserve set information by system.
3, the verification rule in the template is verified in definition.Referring to Fig. 7, Fig. 7 is the example schematic that rule is verified in definition in the embodiment of the invention.The user can be provided with scope verification rule based on visualization interface edit tool shown in Figure 7, is example with the scope verification rule that the termination number field is set, and selects the termination number field to should be integer, and the setting of other scope verification rules repeats no more.Further, system can be automatically converted to the arithmetic expression-form or the regular expression of standard according to the information of inspector's input, verifies rule to make things convenient for the inspector to be provided with.After the user sets up relevant information, click " preservation ", preserve set information by system.
4, definition is with reference to office data, and the form that can provide file to import on editing interface imports to be verified in the template.
In addition, the verification template relevant information that gives the definition of visualization interface edit tool is imported in the template description document of Excel form, can adopt attainable prior art, not within the application's discussion scope.
In the present embodiment, can generate the verification data description file in advance, and adopt with the verification template in the identical standardization describing mode of data of description, office data to be verified is described.In the present embodiment, in the standardization describing mode, preferred office data form is the Excel list data.Verify field or verify Field ID according to verifying to define in the template, generate and describe the Excel file of waiting to verify office data, in the Excel of correspondence form, embody each and verify Field ID,, fill in each and verify Field ID as in the lattice of respectively tabulating of first row.Follow-up, the office data to be verified that collects can be shown described verification field according to this Excel, office data respectively to be verified is imported to relevant position in the Excel table.Referring to table three, enumerate in the table three and describe the Excel table of waiting to verify office data.Import the data to be verified of this Excel table,, be arranged in relevant position in the table three according to verifying Field ID.
Table three:
| phone-number | register-type | Account | password | screen-chioce |
| 86113815636569 | 4 | shuichaoetr5 | MTUyNDAw | 0 |
| 86113815636570 | 3 | lys13902725325 | MTYxMzIx | 0 |
| 86113815636571 | 3 | kingcheng | ODYwNDI5 | 0 |
| 86113815636572 | 0 | yaz1518 | MTk3NzEyMjU＝ | 0 |
| 86113815636573 | 1 | lili13988738813 | MTM5ODg3Mzg4MTM＝ | 0 |
| 86113815636574 | 1 | wwb11 | NzcxMTE1 | 0 |
In this step 304, as previously mentioned, the way of gathering office data can comprise two kinds, in the present embodiment, stresses the process of how to gather office data from existing network.Referring to Fig. 8, Fig. 8 is a flow chart of gathering office data in the embodiment of the invention from existing network, and this flow process can may further comprise the steps:
In this step 801, pass through Simple Network Management Protocol (SNMP), Secure File Transfer Protocol (SFTP), simple object Access Protocol (SOAP) or the agreement communications such as (Telnet) of telnet agreement between data acquisition unit and the network element, data acquisition unit initiatively sends SNMP or telnet command to network element, to obtain office data.
Need to prove, because NE quantity is many in the communication network, and also to carry out normal business the network element return data time, therefore as calling out etc., the office data of gathering on the network element may need than the time of growing, and the time of gathering the office data needs on all network elements is longer.So the collecting work of office data can be placed on the business handled on the network element to carry out in the less relatively period, as 4:00 AM.In addition, referring to Fig. 9, Fig. 9 is the example schematic of gathering office data in the embodiment of the invention from existing network, wherein, adopts the multithreading collection mechanism, and each thread is gathered a network element, thereby can gather a plurality of network elements simultaneously so that improve collecting efficiency.
Owning administration's data that step 804, data acquisition unit assembling receive are with owning administration's data output.
The flow process of gathering office data finishes.
Referring to Figure 10, Figure 10 generates the flow chart of waiting to verify office data in the embodiment of the invention, and this flow process can may further comprise the steps:
The data format of the office data that collects from existing network can't adopt the data format that defines in the standardization describing mode usually, therefore, need be with the Data Format Transform of the office data that collects for verifying the data format of defined office data in the template, preferably, this data format is an Excel list data form.
Whether step 1004, a plurality of fields of judging a plurality of office data correspondences collect comprise and more than verifying the verification field that defines in the template, if, execution in step 1005; Otherwise, execution in step 1006.
In the practical application, the execution order of above-mentioned three judgment processing can be different with the execution order in the present embodiment.
In the practical application, can select to carry out one or more in four judgment processing, also can increase correlated judgment as required and handle, so that the office data standardization obtains office data to be verified, the convenient verification.
In office data, certain field value is " 123 ", the data type of this field is a numeric type, and in the verification template, the data type of corresponding verification field is the text type, then needs in this office data, and the data type of corresponding field is converted to the text type by numeric type, verify rule with convenient the utilization, verify this field.
In the present embodiment, the flow process that conversion waits to verify the describing mode of office data finishes.
Rule is verified in step 306, utilization, verifies office data to be verified.
Referring to Figure 11, Figure 11 utilizes the flow chart of waiting to verify office data with reference to office data checking in the embodiment of the invention, and this flow process can may further comprise the steps:
Whether step 1104, comparison equate with the critical field of waiting to verify in the office data with reference to the critical field in the office data, if equate that then execution in step 1107; Otherwise, execution in step 1106.
This critical field of disappearance in the office data, execution in step 1107 waited to verify in step 1105, record.
In this step, utilize the specific practice of verifying rule verification office data to repeat no more referring to above-mentioned associated description for meeting.
Flow process shown in Figure 11 finishes.In this flow process, having enumerated the verification process of utilizing with reference to the office data checking office data, wherein, is the critical field of verifying in the template with reference to office data.In the practical application, concrete verification flow process can be set as required, generally speaking, verify for improving efficient, can be provided with and need the critical field verified, or which field is set needs to verify by verifying template, filter the office data that collects, to avoid verifying some unessential fields.Wherein, concrete verification can be verified based on reference office data or other verification rules.
Verify the result and can comprise total data bar number, redundant data, missing data, misdata, accuracy of verification or the like, verifying the result can directly be presented on the interface, also can generate verification and report that the file with forms such as Html, Excel, Txt sends to client.Referring to Figure 12, Figure 12 be embodiment of the invention center come to an end the fruit example schematic.Based on visual verification result, the inspector can grasp office data in relatively verify unnecessary, disappearance and wrong data in the template, and accuracy of office data, error rate or the like, further in the practical application, also the non-correct office data that the process of verification center can be found is derived.
In sum, office data checking method that the embodiment of the invention is given and device, by the verification of computer program realization to office data, be to comprise soft unit in the office data checking device, promptly verify the unit, this verification unit can comprise two inputs, be the reading of data collecting unit collect wait to verify the office data end, and read and verify the rule end, verify the unit based on the information that reads from two inputs, utilize the verification rule to verify office data to be verified, and the result is verified in output, therefore, from the programming angle, the function of verifying the unit can realize by one-off programming, and wait to verify office data and corresponding verification rule all is variable, in scope verification rule, the span of verifying field can corresponding according to actual needs adjustment, and the text formatting of the verification field of content verification rule Chinese version class also can be according to the corresponding adjustment of actual conditions, and it is regular to increase more a plurality of verification, can delete certain and verify rule, can increase the verification field, can delete some and verify field or the like, thereby promote the extensibility of verification scheme greatly, and effectively reduce programming personnel's work load, guarantee to verify result's accuracy simultaneously.During specific implementation, verify the unit and from verify template, read verification rule or the like information, and from data file, read office data to be verified.In addition, based on visual verification template, the inspector can safeguard the verification relevant information more easily.
Claims (15)
1. an office data checking method is characterized in that, comprising:
Gather office data, generate office data to be verified;
Read set in advance be used to verify the verification rule of waiting to verify office data;
According to described verification rule, verify office data described to be verified, draw the verification result.
2. method according to claim 1 is characterized in that, described verification rule provides the verification request that need satisfy as correct office data, according to described verification rule, verifies office data described to be verified, and draws the verification result and comprises:
Whether verify and describedly wait to verify office data and be consistent with described verification request, if meet, it is correct for waiting to verify office data then to draw described verification result, otherwise drawing described verification result is the described office data mistake of waiting to verify.
3. method according to claim 1 is characterized in that, generates office data to be verified and comprises:
The describing mode of described office data is converted to the standardization describing mode that sets in advance by the nonstandardized technique describing mode, draws office data to be verified.
4. method according to claim 3 is characterized in that, with the describing mode of described office data by the nonstandardized technique describing mode be converted to the standardization describing mode that sets in advance comprise following one of arbitrarily or combination in any:
If the data format of described office data, different with the defined data format corresponding to this office data of described standardization describing mode, then the Data Format Transform with described office data is the defined data format corresponding to this office data of described standardization describing mode.
If a plurality of office datas that collected are corresponding to multiple field, and multiple field comprises and more than the multiple field that defines in the described standardization describing mode, then the office data of the field correspondence that do not comprise in the described standardization describing mode is deleted from described a plurality of office datas; Or, if do not exist in the field that the field of the office data correspondence that collects defines, then provide warning information in described standardization describing mode;
If the data type of described office data, different with the defined data type corresponding to this office data of described standardization describing mode, then the data type conversion with described office data is the defined data type corresponding to this office data of described standardization describing mode.
5. method according to claim 1 is characterized in that, gathers office data and comprises:
The described office data that preservation is transfused to;
Perhaps, from communication network, obtain described office data.
6. method according to claim 5 is characterized in that, obtains described office data and comprise from communication network:
Send the request of obtaining described office data to the office data place network equipment;
Receive and store the described office data that the described network equipment returns.
7. method according to claim 1 is characterized in that, according to described verification rule, verifies and describedly waits to verify before the office data, and this method further comprises:
Determine whether described to wait to verify office data be critical data, if then preferentially verify this office data to be verified.
8. method according to claim 2 is characterized in that, described verification rule comprises: scope verification rule, the described verification request that provides are the correct affiliated span of office data;
Whether verify and describedly wait to verify office data and be consistent with described verification request, if meet, it is correct for waiting to verify office data then to draw described verification result, otherwise, draw described verification result and be and describedly wait to verify the office data mistake and comprise:
Verify and describedly wait to verify data and whether belong to described span, if, determine that then described to wait to verify data correct, otherwise, determine that data described to be verified make mistakes.
9. method according to claim 2 is characterized in that, described verification rule comprises: content verification rule, the described verification request that provides are as correct office data, the condition that its content need satisfy;
Whether verify and describedly wait to verify office data and be consistent with described verification request, if meet, it is correct for waiting to verify office data then to draw described verification result, otherwise, draw described verification result and be and describedly wait to verify the office data mistake and comprise:
Verify the described data content of verifying office data of waiting and whether satisfy described verification request,, determine that then described to wait to verify data correct if satisfy, otherwise, determine that data described to be verified make mistakes.
10. method according to claim 2 is characterized in that, described verification rule comprises: with reference to office data, the described verification request that provides is that correct office data need be with described identical with reference to office data;
Whether verify and describedly wait to verify office data and be consistent with described verification request, if meet, it is correct for waiting to verify office data then to draw described verification result, otherwise, draw described verification result and be and describedly wait to verify the office data mistake and comprise:
Verify and describedly wait to verify office data with described whether identical with reference to office data, if identical, then described to wait to verify office data correct, otherwise office data described to be verified is made mistakes.
11. method according to claim 1 is characterized in that, draw verify the result after, this method further comprises:
Described verification result is exported with visual means.
12. an office data checking device is characterized in that, comprising: data acquisition unit, data generating unit, the rale store unit, verify unit and output unit as a result; Wherein,
Described data acquisition unit is gathered office data to be verified;
Described data generating unit, the described office data that utilizes described data acquisition unit to collect generates office data to be verified;
Described rale store unit, the verification rule that storage sets in advance;
Described verification unit reads the described described verification rule of waiting to verify office data and the storage of described rale store unit that described data acquisition unit collects, and according to described verification rule, verifies office data described to be verified;
Output unit as a result, the verification result output that described verification unit is obtained.
13. device according to claim 12 is characterized in that, described verification unit comprises: read subelement and verify subelement; Described verification rule provides the verification request that need satisfy as correct office data;
The described subelement that reads reads the described regular described verification request that provides of described verification of waiting to verify office data and the storage of described rale store unit that described data acquisition unit collects;
Described verification subelement, verify described read that subelement reads wait whether verify office data is consistent with the described verification request that reads, if meet, it is correct for waiting to verify office data then to draw described verification result, otherwise drawing described verification result is the described office data mistake of waiting to verify.
14. device according to claim 12 is characterized in that, described data generating unit comprises following any unit or combination in any: Data Format Transform unit, delete cells, data type conversion unit;
Described Data Format Transform unit is the defined data format corresponding to this office data of described standardization describing mode with the Data Format Transform of described office data;
Described delete cells, if a plurality of office datas that collected are corresponding to multiple field, and multiple field comprises and more than the multiple field that defines in the described standardization describing mode, then the office data of the field correspondence that do not comprise in the described standardization describing mode is deleted from described a plurality of office datas;
Described data type conversion unit is the defined data type corresponding to this office data of described standardization describing mode with the data type conversion of described office data.
15. device according to claim 12 is characterized in that,
Described data acquisition unit comprises request transmitting unit and receiving element;
The described request transmitting element is to waiting that verifying the office data place network equipment sends the described request of waiting to verify office data of obtaining;
Described reception processing unit receives and stores the office data described to be verified that the described network equipment returns.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007103056456A CN101197875A (en) | 2007-12-26 | 2007-12-26 | Partial data checking method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007103056456A CN101197875A (en) | 2007-12-26 | 2007-12-26 | Partial data checking method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101197875A true CN101197875A (en) | 2008-06-11 |
Family
ID=39548012
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2007103056456A Pending CN101197875A (en) | 2007-12-26 | 2007-12-26 | Partial data checking method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101197875A (en) |
Cited By (25)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102076116A (en) * | 2009-11-25 | 2011-05-25 | 中国移动通信集团辽宁有限公司 | Data comparing method and device |
| CN102246550A (en) * | 2011-05-27 | 2011-11-16 | 华为技术有限公司 | Method for verifying business rule of NE configuration and verifying system |
| CN101604336B (en) * | 2009-07-22 | 2012-05-23 | 河北省烟草公司承德市公司 | Method and system for data inspection and modification from the source |
| WO2012100681A1 (en) * | 2011-01-26 | 2012-08-02 | 北京京东世纪贸易有限公司 | Data verification method and device |
| CN101772043B (en) * | 2008-12-31 | 2012-09-26 | 亿阳信通股份有限公司 | Office data checking method and device |
| CN103020269A (en) * | 2012-12-26 | 2013-04-03 | 广州市西美信息科技有限公司 | Method and device for verifying data |
| CN103188094A (en) * | 2011-12-28 | 2013-07-03 | 中国移动通信集团贵州有限公司 | Resource data verification system and resource data verification method |
| CN103399748A (en) * | 2013-08-02 | 2013-11-20 | 王力强 | Equipment configuration standardization detecting device and method |
| CN103810634A (en) * | 2014-03-05 | 2014-05-21 | 南京聪诺信息科技有限公司 | Method and device for realizing checking of loan business information |
| CN104732344A (en) * | 2015-03-18 | 2015-06-24 | 浪潮通信信息系统有限公司 | Resource data checking system and method |
| CN105094852A (en) * | 2015-09-07 | 2015-11-25 | 浪潮软件集团有限公司 | Tool for importing and exporting data EXCEL |
| CN105808510A (en) * | 2014-12-31 | 2016-07-27 | 北京航天测控技术有限公司 | Debugging data verification method and device |
| CN105976302A (en) * | 2016-05-05 | 2016-09-28 | 北京思特奇信息技术股份有限公司 | Configurable data comparing method and system |
| CN108021468A (en) * | 2017-12-08 | 2018-05-11 | 泰康保险集团股份有限公司 | The method of calibration and device of business datum in medical treatment endowment cooperative system |
| CN108228618A (en) * | 2016-12-14 | 2018-06-29 | 平安科技（深圳）有限公司 | The method and apparatus of document verification of data |
| CN109495350A (en) * | 2018-12-18 | 2019-03-19 | 中国联合网络通信集团有限公司 | The check method and equipment of office data |
| CN109597763A (en) * | 2018-12-04 | 2019-04-09 | 北京广利核系统工程有限公司 | A kind of consistency verification method and device that multinomial data are normalized |
| CN110413639A (en) * | 2019-06-18 | 2019-11-05 | 深圳市华傲数据技术有限公司 | Data check method and device, electronic equipment and computer readable storage medium |
| CN110647509A (en) * | 2018-06-26 | 2020-01-03 | 北京亿阳信通科技有限公司 | Rapid checking and sharing method and device for passenger collecting data |
| CN111209027A (en) * | 2019-12-30 | 2020-05-29 | 航天信息股份有限公司广州航天软件分公司 | Method and system for service verification based on dynamic verification algorithm |
| CN112016276A (en) * | 2020-10-29 | 2020-12-01 | 广州欧赛斯信息科技有限公司 | Graphical user-defined form data acquisition system |
| CN112102910A (en) * | 2020-09-22 | 2020-12-18 | 零氪科技（北京）有限公司 | Method and device for automatically checking proprietary data docking data |
| CN112214983A (en) * | 2020-09-21 | 2021-01-12 | 远光软件股份有限公司 | Data record duplicate checking method and system |
| CN112448828A (en) * | 2019-08-28 | 2021-03-05 | 中国移动通信集团浙江有限公司 | High-availability realization method and device for CE router in IP bearing network |
| CN114268916A (en) * | 2021-12-10 | 2022-04-01 | 中国联合网络通信集团有限公司 | Processing method, device and equipment based on content charging data and storage medium |
-
2007
- 2007-12-26 CN CNA2007103056456A patent/CN101197875A/en active Pending
Cited By (36)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101772043B (en) * | 2008-12-31 | 2012-09-26 | 亿阳信通股份有限公司 | Office data checking method and device |
| CN101604336B (en) * | 2009-07-22 | 2012-05-23 | 河北省烟草公司承德市公司 | Method and system for data inspection and modification from the source |
| CN102076116B (en) * | 2009-11-25 | 2013-09-18 | 中国移动通信集团辽宁有限公司 | Data comparing method and device |
| CN102076116A (en) * | 2009-11-25 | 2011-05-25 | 中国移动通信集团辽宁有限公司 | Data comparing method and device |
| WO2012100681A1 (en) * | 2011-01-26 | 2012-08-02 | 北京京东世纪贸易有限公司 | Data verification method and device |
| CN102246550A (en) * | 2011-05-27 | 2011-11-16 | 华为技术有限公司 | Method for verifying business rule of NE configuration and verifying system |
| CN102246550B (en) * | 2011-05-27 | 2013-06-05 | 华为技术有限公司 | Method for verifying business rule of NE configuration and verifying system |
| CN103188094A (en) * | 2011-12-28 | 2013-07-03 | 中国移动通信集团贵州有限公司 | Resource data verification system and resource data verification method |
| CN103020269B (en) * | 2012-12-26 | 2016-09-07 | 广州市西美信息科技有限公司 | A kind of method of data verification and device |
| CN103020269A (en) * | 2012-12-26 | 2013-04-03 | 广州市西美信息科技有限公司 | Method and device for verifying data |
| CN103399748A (en) * | 2013-08-02 | 2013-11-20 | 王力强 | Equipment configuration standardization detecting device and method |
| CN103810634A (en) * | 2014-03-05 | 2014-05-21 | 南京聪诺信息科技有限公司 | Method and device for realizing checking of loan business information |
| CN105808510A (en) * | 2014-12-31 | 2016-07-27 | 北京航天测控技术有限公司 | Debugging data verification method and device |
| CN104732344A (en) * | 2015-03-18 | 2015-06-24 | 浪潮通信信息系统有限公司 | Resource data checking system and method |
| CN105094852A (en) * | 2015-09-07 | 2015-11-25 | 浪潮软件集团有限公司 | Tool for importing and exporting data EXCEL |
| CN105976302A (en) * | 2016-05-05 | 2016-09-28 | 北京思特奇信息技术股份有限公司 | Configurable data comparing method and system |
| CN108228618A (en) * | 2016-12-14 | 2018-06-29 | 平安科技（深圳）有限公司 | The method and apparatus of document verification of data |
| CN108228618B (en) * | 2016-12-14 | 2020-07-31 | 平安科技（深圳）有限公司 | Document data checking method and device |
| CN108021468A (en) * | 2017-12-08 | 2018-05-11 | 泰康保险集团股份有限公司 | The method of calibration and device of business datum in medical treatment endowment cooperative system |
| CN110647509B (en) * | 2018-06-26 | 2024-05-14 | 北京亿阳信通科技有限公司 | Quick checking and sharing method and device for collecting customer data |
| CN110647509A (en) * | 2018-06-26 | 2020-01-03 | 北京亿阳信通科技有限公司 | Rapid checking and sharing method and device for passenger collecting data |
| CN109597763A (en) * | 2018-12-04 | 2019-04-09 | 北京广利核系统工程有限公司 | A kind of consistency verification method and device that multinomial data are normalized |
| CN109597763B (en) * | 2018-12-04 | 2022-02-25 | 北京广利核系统工程有限公司 | Consistency verification method and device for normalizing multiple items of data |
| CN109495350A (en) * | 2018-12-18 | 2019-03-19 | 中国联合网络通信集团有限公司 | The check method and equipment of office data |
| CN109495350B (en) * | 2018-12-18 | 2020-08-11 | 中国联合网络通信集团有限公司 | Office data checking method, office data checking device and storage medium |
| CN110413639A (en) * | 2019-06-18 | 2019-11-05 | 深圳市华傲数据技术有限公司 | Data check method and device, electronic equipment and computer readable storage medium |
| CN112448828A (en) * | 2019-08-28 | 2021-03-05 | 中国移动通信集团浙江有限公司 | High-availability realization method and device for CE router in IP bearing network |
| CN112448828B (en) * | 2019-08-28 | 2023-07-04 | 中国移动通信集团浙江有限公司 | High availability implementation method and device for CE router in IP bearing network |
| CN111209027A (en) * | 2019-12-30 | 2020-05-29 | 航天信息股份有限公司广州航天软件分公司 | Method and system for service verification based on dynamic verification algorithm |
| CN111209027B (en) * | 2019-12-30 | 2024-04-19 | 航天信息股份有限公司广州航天软件分公司 | Method and system for business verification based on dynamic verification algorithm |
| CN112214983A (en) * | 2020-09-21 | 2021-01-12 | 远光软件股份有限公司 | Data record duplicate checking method and system |
| CN112214983B (en) * | 2020-09-21 | 2023-08-11 | 远光软件股份有限公司 | Data record duplicate checking method and system |
| CN112102910A (en) * | 2020-09-22 | 2020-12-18 | 零氪科技（北京）有限公司 | Method and device for automatically checking proprietary data docking data |
| CN112016276A (en) * | 2020-10-29 | 2020-12-01 | 广州欧赛斯信息科技有限公司 | Graphical user-defined form data acquisition system |
| CN114268916A (en) * | 2021-12-10 | 2022-04-01 | 中国联合网络通信集团有限公司 | Processing method, device and equipment based on content charging data and storage medium |
| CN114268916B (en) * | 2021-12-10 | 2023-08-15 | 中国联合网络通信集团有限公司 | Processing method, device, equipment and storage medium based on content charging data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101197875A (en) | Partial data checking method and device | |
| CN109033471B (en) | Information asset identification method and device | |
| CN100492319C (en) | System and method for installing storage area network | |
| CN102364894B (en) | Issuing method for configuration data file and network management equipment | |
| CN108459939A (en) | A kind of log collecting method, device, terminal device and storage medium | |
| CN102932195B (en) | A kind of business diagnosis method for supervising of protocal analysis Network Based and system | |
| CN113691651B (en) | Top-level planning visualization management method, system and storage medium based on IPv6 network | |
| CN103283191A (en) | Information system, control device, communication method and program | |
| CN109800259A (en) | Collecting method, device and terminal device | |
| CN1980144A (en) | Method for quickly configurating large data-quantity network management data | |
| CN101494551A (en) | Method, apparatus and system for business cutover | |
| CN102271052A (en) | Network system, network management device and gateway device | |
| CN102457390A (en) | Fault location method and system based on quality of experience (QoE) | |
| CN104317601B (en) | A kind of file interface development approach and system | |
| CN104199625A (en) | Method, device and system for converting and outputting print data | |
| CN101998687A (en) | Method and device for collecting network parameters of WLAN (Wireless Local Area Network) | |
| CN109150854A (en) | Dynamic and configurable communication protocol converting system based on XML file | |
| CN109615276A (en) | A kind of housekeeping practitioner information management system | |
| CN106713024A (en) | Batch cluster node management method and system and computer cluster management node | |
| CN103957119A (en) | Method for managing network equipment by using MIB file and browser | |
| CN106936625B (en) | Substation network management service automatic discovery method based on SCD | |
| CN106600206A (en) | Method for realization of nuclear power plant dose data one-way transmission from management network to industry network | |
| CN106817260A (en) | A kind of Cabinet administration system and method | |
| CN108234447A (en) | A kind of safety regulation for heterogeneous networks security function manages system and method | |
| CN114268916A (en) | Processing method, device and equipment based on content charging data and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20080611 |