CN109635300A - Data verification method and device - Google Patents
Data verification method and device Download PDFInfo
- Publication number
- CN109635300A CN109635300A CN201811532531.XA CN201811532531A CN109635300A CN 109635300 A CN109635300 A CN 109635300A CN 201811532531 A CN201811532531 A CN 201811532531A CN 109635300 A CN109635300 A CN 109635300A
- Authority
- CN
- China
- Prior art keywords
- verification
- data
- rule
- verified
- field
- 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 42
- 238000013524 data verification Methods 0.000 title claims abstract description 15
- 238000012795 verification Methods 0.000 claims abstract description 221
- 238000004590 computer program Methods 0.000 claims description 11
- 238000012360 testing method Methods 0.000 claims description 8
- 238000013481 data capture Methods 0.000 claims description 3
- 238000004891 communication Methods 0.000 description 9
- 230000006870 function Effects 0.000 description 9
- 230000008569 process Effects 0.000 description 6
- 238000012545 processing Methods 0.000 description 6
- 230000008859 change Effects 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 238000012790 confirmation Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000008439 repair process Effects 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
- G06F40/232—Orthographic correction, e.g. spell checking or vowelisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Debugging And Monitoring (AREA)
Abstract
Data verification method and device provided by the invention will be treated the verification of the first field in verification data, be arranged in after the verification to the second field.It is quoted since the first field has the second field, in the verification failure of the first field, then the verification of the second field is no longer executed, and display leads to the data information of the first field verification failure.The data information for leading to the verification failure of the first field, is exactly fatal error data, and user can directly modify to the fatal error data, and when avoiding the multiple wrong data of display, the caused non-intuitive problem of check results improves user experience.
Description
Technical field
The present invention relates to data processing fields, more specifically to data verification method and device.
Background technique
Currently, report class system in processing business data, realizes that data are handed over generally by way of Excel file
Mutually.For the Excel file got, needs first to verify wherein data, could store or carry out after verification passes through
Follow-up business process.Existing data check process is directly to carry out full table full dose verification；When a verification object data occurs
When mistake, all verifications relevant to the verification object data can all report an error, and cause the check results of output not intuitive, it is also necessary to
User analyze again it is specific where data there are mistakes.
Summary of the invention
In view of this, the present invention proposes data verification method and device, the automatic positioning of fatal error data to be realized
Purpose.
To achieve the goals above, it is proposed that scheme it is as follows:
A kind of data verification method, comprising:
Obtain data to be verified；
Obtain verification rule corresponding with the data to be verified, the verification rule include fatal error verify it is regular with
Related error checking rule, the first field, which has the second field, to be quoted, and second field is fatal error verification rule
Verification object data then, first field are the verification object of the related error checking rule；
It verifies rule using the fatal error to verify the data to be verified, if verification failure, display are led
The data information of verification failure is caused, and the related error checking rule is not recycled to verify the data to be verified.
Optionally, the verification rule further includes prompting-type verification rule, the method also includes:
It verifies rule using the prompting-type to verify the data to be verified, if verification failure, display reminding
Information.
Optionally, the verification rule further includes business serious error verification rule, the method also includes:
It verifies rule using the business serious error to verify the data to be verified, if verification failure, stops
Only to the verification of the data to be verified.
Optionally, acquisition verification corresponding with the data to be verified is regular, comprising:
According to the critical field in the data to be verified, matching obtains corresponding intelligent checking template；
The intelligent checking template is parsed to obtain the verification rule.
It is optionally, described that the intelligent checking template is parsed to obtain the verification rule, comprising:
Parsed to obtain all verifications rule that the intelligent checking template includes to the intelligent checking template；
Selection obtains institute corresponding with the precondition field in the data to be verified from all verification rules
State verification rule.
Optionally, the step of data information that the verification rule and/or the display cause verification to fail, rule is utilized
Engine carries out sentence parsing.
Optionally, the database that the method utilizes is the database stored based on distributed document.
A kind of data calibration device, comprising:
Data capture unit, for obtaining data to be verified；
Rule unit, regular for obtaining verification corresponding with the data to be verified, the verification rule includes
Fatal error verification rule and related error checking rule, the first field, which has the second field, to be quoted, and second field is
The verification object data of the fatal error verification rule, first field are the verification pair of the related error checking rule
As；
First verification unit verifies the data to be verified for verifying rule using the fatal error, if
Verification failure, then display cause verification fail data information, and do not recycle the related error checking rule to it is described to
Verification data are verified.
Optionally, the verification rule further includes prompting-type verification rule, described device further include:
Second verification unit verifies the data to be verified for verifying rule using the prompting-type, if school
Failure is tested, then display reminding information.
Optionally, the verification rule further includes business serious error verification rule, described device further include:
Third verification unit carries out school to the data to be verified for verifying rule using the business serious error
It tests, if verification failure, stops the verification to the data to be verified.
Optionally, the Rule unit, comprising:
Template obtains subelement, for according to the critical field in the data to be verified, matching to obtain corresponding intelligence
Verify template；
Rule parsing subelement obtains the verification rule for being parsed to the intelligent checking template.
Optionally, the rule parsing subelement, comprising:
First rule parsing subelement obtains the intelligent checking template for being parsed to the intelligent checking template
All verifications rule for including；
Second Rule parsing subunit, for from all verifications rule selection obtain in the data to be verified
The corresponding verification rule of precondition field.
A kind of data check equipment, comprising:
Memory；
Processor；And
Computer program；
Wherein, the computer program stores in the memory, and is configured as being executed by the processor with reality
Existing above-mentioned data verification method.
A kind of computer readable storage medium, which is characterized in that be stored thereon with computer program, the computer program
It is executed by processor to realize above-mentioned data verification method.
Compared with prior art, technical solution of the present invention has the advantage that
The data verification method and device that above-mentioned technical proposal provides will treat the verification of the first field in verification data,
It is arranged in after the verification to the second field.It is quoted since the first field has the second field, in the school of the first field
When testing unsuccessfully, then the verification of the second field is no longer executed, and display leads to the data information of the first field verification failure.Lead to
The data information of one field verification failure, is exactly fatal error data, user can directly repair the fatal error data
Change, when avoiding the multiple wrong data of display, the caused non-intuitive problem of check results improves user experience.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
The embodiment of invention for those of ordinary skill in the art without creative efforts, can also basis
The attached drawing of offer obtains other attached drawings.
Fig. 1 is the flow chart of data verification method provided by one embodiment of the present invention；
Fig. 2 is the flow chart provided by one embodiment of the present invention for obtaining verification rule corresponding with data to be verified；
Fig. 3 is the logical construction schematic diagram of data calibration device provided by one embodiment of the present invention；
Fig. 4 is the system structure diagram provided by one embodiment of the present invention for realizing data check；
Fig. 5 is the structural schematic diagram of data check equipment provided by one embodiment of the present invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall within the protection scope of the present invention.
Fig. 1 is data verification method provided by one embodiment of the present invention, and an independent micro services can be used as skill
Art carrier treats verification data and carries out unified individually processing.This method may include step:
S11: data to be verified are obtained.
Data to be verified can be imported application by headend equipment by user data check disclosed by the embodiments of the present invention
The calibration equipment of method.Data to be verified can be data in Excel file.
S12: verification rule corresponding with data to be verified is obtained.
Verification rule includes fatal error verification rule and related error checking rule.There is the second field in the first field
Reference, the second field are the verification object data of fatal error verification rule, and the first field is the school of related error checking rule
Test object.For example, the first field is the tax amount of payment amount of money, the second field is payment amount of money；Payment amount of money is fatal error
The verification object data of rule is verified, the tax amount of payment amount of money is the verification object of related error checking rule.Due to first
There is the reference to the second field in field, therefore, when the second field has mistake, then the first field also can mistake.In this hair
In bright, define in the second field and there are the data of mistake for fatal error data.
S13: treating verification data using fatal error verification rule and verified, if verification failure, display lead to school
The data information of failure is tested, and does not recycle related error checking rule to treat verification data and is verified.
The execution of related error checking rule in the present invention is after fatal error verification rule.Utilizing fatal error
Verification rule verification, and when verification failure, then corresponding related error checking rule is not executed.A large amount of nothings are effectively prevented in this way
With the display of error message, and real error reason accurately can be quickly positioned, improve user experience.
In a specific embodiment of the invention, verification rule can also include prompting-type verification rule, to be verified
When data are verified, verification data are treated using prompting-type verification rule and are verified, if verification failure, display reminding letter
Breath.The verification object data of prompting-type verification rule is that the user in data to be verified holds confusing field when filling in list.
Verification using indicative verification rule is unsuccessfully the failure verified on regular expression, and not representing data itself, there are mistakes.
Prompt when such as needing check field non-empty, verify write on regular expression the field must be it is empty, if this value be not it is empty,
Verification fails, then display reminding information.Such as: when filling in payment application list in supplementary pension fee payment service, need to fill out
It writes multiple amount fields and title is more similar easily obscures mistake and fill out, field is as follows, and enterprise has paid the fees non-taxable amount, enterprise's payment
Taxable amount, personal non-taxable amount of paying the fees, the personal payment assessment paid amount of money, can not be in current business node when executing verification
Directly assert its correctness filled in, need back flow nodes verify, need at this time one prompt come allow user's subjectivity again
Confirmed, when certain amount field non-empty is arrived in verification, just prompt user: the xxx amount of money numerical value that you fill in is that xxxxx.xx is asked
Confirmation.
In a specific embodiment of the invention, verification rule can also include business serious error verification rule, right
When data to be verified are verified, verification data are treated using business serious error verification rule and are verified, if verification failure,
The then data information that display causes verification to fail stops the verification for treating verification data.Such as: in supplementary pension fee payment service
When payment application, when verifying " the plan title " of payment application, plan the business rule of different back flow nodes of title just
Meeting difference and same member cannot participate in two and plan, and the subsequent most needs foundation of verification is under the premise of plan title is correct
Verification, subsequent verification can all report an error if plan title fills in mistake, so being considered as when verification is incorrect to plan title
Business serious error, directly stops the verification of entire data to be verified, and shows the data of mistake.
All kinds of business forms are relatively more in supplementary pension system, for example supplementary pension member produces, annuity payment application industry
The list of the business such as business, personal information change.In a specific embodiment of the invention, for different Excel files, need
According to table format specific in Excel file and verification rule, corresponding intelligent checking template, intelligent checking template packet are edited
Containing verification rule corresponding with corresponding Excel file.There is no Table Header information only to need as supplementary pension member produces business form
The parsing verification of allocation list body；It includes that multiple and different sheet parses verification that supplementary pension fee payment service, which initiates list,；Supplementary pension
It includes multiple identical sheet parsing verifications etc. that treatment, which pays list,.And the verification rule difference of each business is also very big, payment
Need to carry out the verification of the various amount of money, personal information change needs to verify whether change item is correct, these require to be respectively configured
Processing.
Intelligent checking template in the present invention can pass through SQL (StructuralQuery Language, structuralized query
Language) it is designed generation, when needing to modify verification rule or newly-increased verification rule, modification SQL allocation list can be passed through
Mode is modified or newly-increased verification rule, does not need to redeploy application.It can simple and quick completion school by intelligent checking template
Test work, and support column verification, row in verification, in the ranks verification, whole table verification, more sheet verification and multilist list verification etc..
The data in the Excel file of different business are verified using different intelligent verification template, can will be blended together
State decoupling safeguards exploitation more rapidly, more simply.Referring to fig. 2, by intelligent checking template treat verification data carry out school
When testing, verification rule corresponding with data to be verified is obtained, may include step:
S21: according to the critical field in data to be verified, matching obtains corresponding intelligent checking template.
In a specific embodiment of the invention, the critical field in data to be verified can be filename.It presets
The mapping relations of filename and intelligent checking template, using the critical field in data to be verified, obtain in practical checking procedure
Corresponding intelligent checking template is taken, to obtain corresponding verification rule.The parsing of Excel file is carried out using the library java POI,
Incoming critical field, matching are obtained corresponding intelligent checking template, the reading of data to be verified are completed using intelligent checking template
And verification.
S22: intelligent checking template is parsed to obtain verification rule.
Data to be verified and intelligent checking template are exemplified below.
The payment detail list of annuity system
Intelligent checking template corresponding with above-mentioned payment detail list is as follows:
<model-config desc=" payment detail list template-Tai Kang ">
< field type='String'code=" orgName " value=" $ B8 " sheet=" payment detail list "
Nullable='false'maxLength='40'desc=" enterprise name "/> (gauge outfit data)
< rule sheetCode=" rowDataList " expression='QLFuncUtils@isUniqueFields
([" realName "], " rowDataList ") ' msg=" member of same SHEET is only a people "/> (whole table verification)
< dataList sheetCode=" rowDataList " sheet=" payment detail list " startRow=" 12 "
EndFlag=" A, statement: " endColumn=" U " desc=" payment detail list " >
< rule expression='DateQLFunc@compareDate (startDate, endDate) ' msg=' "
Paying the fees the off period cannot be earlier than the payment starting phase " '/> (data check in row)
< field type='String'code='realName'value='$ C'nullable='false'
MaxLength='50'desc=' employee name ' > (table body column data)
< rule level='3'expression='QLFuncUtils@hasBlankSpace (realName) ' msg
=' " name ["+realName+ "] comprising space invite space " '/> (column data verification)
</field>
</dataList>
</model-config>
Excel file structure is extremely complex, the design for corresponding intelligent checking template, can be first Excel text
Sheet pages in part, gauge outfit (individual unit lattice), table body, line number accordingly and column data is divided into multi-layer data structure.Outer layer
Field represents gauge outfit or global field (" company A " in such as table), and dataList, which represents table body and needs to be arranged, starts line number
startRow；Internal layer field represents standard type column data (such as " Zhang San ")；Then the configuration verified takes out verification
A variety of verification modes such as verification and more sheet pages of verification in train value verification, in the ranks verification, table.4 are broadly divided into about verification
Part, level error level, the precondition of precheck verification, the regular expression of expression verification, msg verification
Error message.
Outer layer rule represents global verification in template, supports more sheet；Rule verification inside table body field is column word
The verification of section, external rule representative in the ranks verify, and provide various field rank verification function inside each field field simultaneously
Energy.Such as: type field type, maxLength maximum length, sheet affiliated sheet, nullable whether non-empty,
DecimalPlaces character precision etc., using flexible, all kinds of fields and function do not need such as not configuring.
Expression verification rule is abstract generally according to service logic, such as verification current payment Start Date is greater than
Whether on January 1st, 2014 and social average salary are greater than the 4% of personal payment tax amount, can be abstracted into following expression
Formula, using such expression formula with regard to achievable verification, (startDate > toDate (2014-01-01))
(societySalary≤tpSumTax*4%).
For identical Excel file, but when needing different check rule, the side that regular precondition is set can be passed through
Formula, heavy workload needed for avoiding the problem that multiple intelligent checking templates while safeguarding.For example, being used for multiple payment modes same
When one list, then some verifications can save special payment mode, at this moment by being verification rule setting rule precondition,
Realization is verified under different payment modes using different verification rules.Specifically, being parsed to intelligent checking template
Obtain all verifications rule that intelligent checking template includes；From selection in all verifications rule obtain in data to be verified before
Set the corresponding verification rule of condition field.For example, precheck represents precondition, precondition field contents are special pay
Take, if the value of precheck is true, verified using corresponding verification rule, contents of program is as follows:
< rule precheck=" the special payment of paymentType=="
Expression='DateQLFunc@checkPaymentIntervalDuplicated (startDate,
endDa te,realName,certiTypeId,certiCode,companyName,teSum,tpSum,feSum,fpSum)'
Ms g='realName+ " with "+vApplyId+ " there are Chong Die for payment time interval " '/>.
In a specific embodiment of the invention, precondition, rule itself and display cause to verify the data to fail
Information can apply regulation engine.By application QLExpress regulation engine progress sentence parsing, such as (startDate >
The verification of the flat wage of toDate (2014-01-01)) && (societySalary≤tpSumTax*4%) such a society,
Chinese and English represents multiple field names of reference, can directly be obtained from the context using regulation engine, and shielding obtains details；
Directly operation correctness can also be returned to, configuration is very flexibly and fast.
Verification for simple list can first be put into data inside the interim table of one relevant database and carry out school
It tests.For complicated list, if need to establish multiple tables using relevant database, and occur changing also need change number
According to library, develop more complicated difficult in maintenance.In a specific embodiment of the invention, utilize what is stored based on distributed document
Database MongoDB carries out data buffer storage.The data structure of MongoDB Hash, does not need creation table, and all lists only need
It is incoming with map form sequenceization, MongoDB aggregate function is widely applied, the processing speed of Excel file is also accelerated.After tested,
Checking treatment is parsed for the Excel list of 2000 rows, 30s-40s is needed according to relevant database, uses MongoDB
Being handled only needs 6s or so, and reduces memory consumption, improves system CPU utilization rate.
For the various method embodiments described above, for simple description, therefore, it is stated as a series of action combinations, but
Be those skilled in the art should understand that, the present invention is not limited by the sequence of acts described because according to the present invention, certain
A little steps can be performed in other orders or simultaneously.
Following is apparatus of the present invention embodiment, can be used for executing embodiment of the present invention method.For apparatus of the present invention reality
Undisclosed details in example is applied, embodiment of the present invention method is please referred to.
It is data calibration device provided by one embodiment of the present invention referring to Fig. 3.The apparatus may include: data acquisition
Unit 31, Rule unit 32 and the first verification unit 33.Wherein,
Data capture unit 31, for obtaining data to be verified.
Rule unit 32, for obtaining verification rule corresponding with the data to be verified, the verification is regular to be wrapped
Fatal error verification rule and related error checking rule are included, the first field, which has the second field, to be quoted, second field
For the verification object data of fatal error verification rule, first field is the verification of the related error checking rule
Object.
First verification unit 33 verifies the data to be verified for verifying rule using the fatal error,
If verification failure, the data information that display causes verification to fail, and do not recycle the related error checking rule to described
Data to be verified are verified.
Optionally, the verification rule further includes prompting-type verification rule, described device further include: the second verification unit,
The data to be verified are verified for verifying rule using the prompting-type, if verification failure, display reminding information.
Optionally, the verification rule further includes business serious error verification rule, described device further include: third verification
Unit verifies the data to be verified for verifying rule using the business serious error, if verification failure, stops
Only to the verification of the data to be verified.
Optionally, the Rule unit, comprising: template obtains subelement and rule parsing subelement.
Template obtains subelement, for according to the critical field in the data to be verified, matching to obtain corresponding intelligence
Verify template；
Rule parsing subelement obtains the verification rule for being parsed to the intelligent checking template.
Optionally, the rule parsing subelement, comprising: the first rule parsing subelement and Second Rule parsing are single
Member.
First rule parsing subelement obtains the intelligent checking template for being parsed to the intelligent checking template
All verifications rule for including；
Second Rule parsing subunit, for from all verifications rule selection obtain in the data to be verified
The corresponding verification rule of precondition field.
Referring to fig. 4, the system structure of data check is able to achieve for one.Business personnel is flat by supplementary pension VIP customer service
Platform imports Excel data file or directly enters form information and submit；Supplementary pension trusted systems service interface platform receives
This document simultaneously saves, and intelligent checking service interface service platform is called after simple process is handled；Intelligent checking interface service
Platform obtains corresponding intelligent checking template according to the critical field of data to be verified, and carries out data document analysis and will solve
Interim storage is done in data deposit MongoDB after analysis；Using the verification rule after parsing, treats verification data and arranged respectively
The verification of the multiple rules such as data, row data, whole table, multilist list.Wherein relevant database access time is reduced using data buffer storage
Number, MongoDB aggregate function operation data accelerate data check.Complete errors excepted output error message after verification, inerrancy
Structuring then is carried out to data, standardization carries out unified output.
Data calibration device provided in an embodiment of the present invention can be applied to data check equipment, such as PC terminal, cloud platform, clothes
Business device and server cluster etc..Server can be rack-mount server, blade server, tower server and cabinet-type
One or more of server.It is the schematic diagram of the preferred embodiment of data check equipment of the present invention referring to Fig. 5.Data school
The hardware configuration for testing equipment may include: at least one processor 51, at least one communication interface 52, at least one processor 53
With at least one communication bus 54；
In embodiments of the present invention, processor 51, communication interface 52, memory 53, communication bus 54 quantity be at least
One, and processor 51, communication interface 52, memory 53 complete mutual communication by communication bus 54；
Processor 51 can be CPU (CentralProcessing Unit, a central processing in some embodiments
Device) or ASIC (Application Specific Integrated Circuit, specific integrated circuit) or quilt
It is configured to implement one or more integrated circuits etc. of the embodiment of the present invention.
Communication interface 52 may include standard wireline interface and wireless interface (such as WI-FI interface).Commonly used in data
Communication connection is established between calibration equipment and other electronic equipments or system.
Memory 53 includes the readable storage medium storing program for executing of at least one type.Readable storage medium storing program for executing can for as flash memory, hard disk,
The NVM such as multimedia card, card-type memory (non-volatile memory, nonvolatile memory).Readable storage medium storing program for executing may be used also
To be high-speed RAM (random access memory, random access memory) memory.Readable storage medium storing program for executing is in some implementations
It can be the internal storage unit of data check equipment, such as the hard disk of the data check equipment in example.In other embodiments
In, readable storage medium storing program for executing, which can also be, to be equipped on the External memory equipment of data check equipment, such as the data check equipment
Plug-in type hard disk, SMC (Smart Media Card, intelligent memory card), SD (Secure Digital, secure digital) card, dodge
Deposit card (Flash Card) etc..
Wherein, memory 53 is stored with computer program, and processor 51 can call the computer program of the storage of memory 53,
The computer program is used for:
Obtain data to be verified；
Obtain verification rule corresponding with the data to be verified, the verification rule include fatal error verify it is regular with
Related error checking rule, the first field, which has the second field, to be quoted, and second field is fatal error verification rule
Verification object data then, first field are the verification object of the related error checking rule；
It verifies rule using the fatal error to verify the data to be verified, if verification failure, display are led
The data information of verification failure is caused, and the related error checking rule is not recycled to verify the data to be verified.
The refinement function and extension function of described program can refer to above description.
Fig. 5 illustrates only the data check equipment with component 51~54, it should be understood that being not required for implementing institute
There is the component shown, the implementation that can be substituted is more or less component.
Optionally, the data check equipment can also include user interface, user interface may include input unit (such as
Keyboard), the speech input device equipment with speech identifying function of microphone (for example include) and/or instantaneous speech power
(such as sound equipment, earphone etc.).Optionally, user interface can also include the wireline interface and/or wireless interface of standard.
Optionally, which can also include display, and display is referred to as display screen or display is single
Member.It can be light-emitting diode display, liquid crystal display, touch-control liquid crystal display and OLED (Organic in some embodiments
Light-Emitting Diode, Organic Light Emitting Diode) display etc..Display is for being shown in data check equipment
The information of reason and for showing visual user interface.
Optionally, which further includes touch sensor.It is touched provided by touch sensor for user
The region for touching operation is known as touch area.In addition, touch sensor can sense for resistive touch sensor, capacitance touch
Device etc..Moreover, touch sensor not only includes the touch sensor of contact, the touch sensor etc. of proximity may also comprise.
In addition, touch sensor can be single sensor, or such as multiple sensors of array arrangement.User can pass through
Touch touch area input identity identification information or log-on data checking routine.
In addition, the area of the display of the data check equipment can be identical as the area of touch sensor, it can also not
Together.Optionally, display and touch sensor stacking are arranged, to form touch display screen.The device is based on touch display screen
Detect the touch control operation of user's triggering.
The data check equipment can also include RF (Radio Frequency, radio frequency) circuit, sensor and voicefrequency circuit
Etc., it is no longer superfluous herein.
The embodiment of the present invention also provides a kind of readable storage medium storing program for executing, which can be stored with and hold suitable for processor
Capable program, described program are used for:
Obtain data to be verified；
Obtain verification rule corresponding with the data to be verified, the verification rule include fatal error verify it is regular with
Related error checking rule, the first field, which has the second field, to be quoted, and second field is fatal error verification rule
Verification object data then, first field are the verification object of the related error checking rule；
It verifies rule using the fatal error to verify the data to be verified, if verification failure, display are led
The data information of verification failure is caused, and the related error checking rule is not recycled to verify the data to be verified.
The refinement function and extension function of described program can refer to above description.
The apparatus embodiments described above are merely exemplary, wherein described, unit can as illustrated by the separation member
It is physically separated with being or may not be, component shown as a unit may or may not be physics list
Member, it can it is in one place, or may be distributed over multiple network units.It can be selected according to the actual needs
In some or all of the modules achieve the purpose of the solution of this embodiment.Those of ordinary skill in the art are not paying creativeness
In the case where labour, it can understand and implement.
Herein, relational terms such as first and second and the like be used merely to by an entity or operation with it is another
One entity or operation distinguish, and without necessarily requiring or implying between these entities or operation, there are any this reality
Relationship or sequence.Moreover, the terms "include", "comprise" or its any other variant are intended to the packet of nonexcludability
Contain, so that the process, method, article or equipment for including a series of elements not only includes those elements, but also including
Other elements that are not explicitly listed, or further include for elements inherent to such a process, method, article, or device.
In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including the element
Process, method, article or equipment in there is also other identical elements.
Each embodiment in this specification is described in a progressive manner, the highlights of each of the examples are with other
The difference of embodiment, the same or similar parts in each embodiment may refer to each other.
To the above description of disclosed embodiment of this invention, it can be realized professional and technical personnel in the field or use this
Invention.Various modifications to these embodiments will be readily apparent to those skilled in the art, institute herein
The General Principle of definition can be realized in other embodiments without departing from the spirit or scope of the present invention.Therefore,
The present invention will not be limited to the embodiments shown herein, and is to fit to special with principles disclosed herein and novelty
The consistent widest scope of point.
Claims (10)
1. a kind of data verification method characterized by comprising
Obtain data to be verified；
Obtain verification rule corresponding with the data to be verified, the verification rule include fatal error verify it is regular with it is related
Error checking rule, the first field, which has the second field, to be quoted, and second field is fatal error verification rule
Object data is verified, first field is the verification object of the related error checking rule；
It verifies rule using the fatal error to verify the data to be verified, if verification failure, display lead to school
The data information of failure is tested, and the related error checking rule is not recycled to verify the data to be verified.
2. the method according to claim 1, wherein the verification rule further includes prompting-type verification rule, institute
State method further include:
It verifies rule using the prompting-type to verify the data to be verified, if verification failure, display reminding information.
3. method according to claim 1 or 2, which is characterized in that the verification rule further includes business serious error school
Rule is tested, the method also includes:
It verifies rule using the business serious error to verify the data to be verified, if verification failure, display are led
The data information of verification failure is caused, and stops the verification to the data to be verified.
4. the method according to claim 1, wherein acquisition verification rule corresponding with the data to be verified
Then, comprising:
According to the critical field in the data to be verified, matching obtains corresponding intelligent checking template；
The intelligent checking template is parsed to obtain the verification rule.
5. according to the method described in claim 4, it is characterized in that, described parsed to obtain institute to the intelligent checking template
State verification rule, comprising:
Parsed to obtain all verifications rule that the intelligent checking template includes to the intelligent checking template；
Selection obtains the school corresponding with the precondition field in the data to be verified from all verification rules
Test rule.
6. the method according to claim 1, wherein verification rule and/or the display cause verification to be lost
The step of data information lost, carries out sentence parsing using regulation engine.
7. the method according to claim 1, wherein the database that the method utilizes is based on distributed document
The database of storage.
8. a kind of data calibration device characterized by comprising
Data capture unit, for obtaining data to be verified；
Rule unit, for obtaining verification rule corresponding with the data to be verified, the verification is regular including crucial
Error checking rule and related error checking rule, the first field, which has the second field, to be quoted, and second field is described
The verification object data of fatal error verification rule, first field are the verification object of the related error checking rule；
First verification unit verifies the data to be verified for verifying rule using the fatal error, if verification
Failure, then the data information that display causes verification to fail, and do not recycle the related error checking rule to described to be verified
Data are verified.
9. a kind of data check equipment characterized by comprising
Memory；
Processor；And
Computer program；
Wherein, the computer program stores in the memory, and is configured as being executed by the processor to realize such as
The described in any item data verification methods of claim 1-7.
10. a kind of computer readable storage medium, which is characterized in that be stored thereon with computer program, the computer program
It is executed by processor to realize such as the described in any item data verification methods of claim 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811532531.XA CN109635300B (en) | 2018-12-14 | 2018-12-14 | Data verification method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811532531.XA CN109635300B (en) | 2018-12-14 | 2018-12-14 | Data verification method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109635300A true CN109635300A (en) | 2019-04-16 |
| CN109635300B CN109635300B (en) | 2023-12-19 |
Family
ID=66074086
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811532531.XA Active CN109635300B (en) | 2018-12-14 | 2018-12-14 | Data verification method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109635300B (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110188334A (en) * | 2019-05-23 | 2019-08-30 | 福建威盾科技集团有限公司 | A kind of method that operation system imports EXCEL data |
| CN110399428A (en) * | 2019-07-26 | 2019-11-01 | 北京奇艺世纪科技有限公司 | A kind of data verification method, device and electronic equipment |
| CN110765090A (en) * | 2019-10-31 | 2020-02-07 | 泰康保险集团股份有限公司 | Log data management method and device, storage medium and electronic equipment |
| CN111414739A (en) * | 2020-02-27 | 2020-07-14 | 北京中亦安图科技股份有限公司 | Excel data entry component, entry method and device |
| CN113723767A (en) * | 2021-08-10 | 2021-11-30 | 上海浦东发展银行股份有限公司 | Business process quality inspection method and device based on voice interaction data |
| CN114547033A (en) * | 2022-02-22 | 2022-05-27 | 苏州浪潮智能科技有限公司 | Method, system, equipment and storage medium for managing key product data |
| WO2023051308A1 (en) * | 2021-09-29 | 2023-04-06 | 华为技术有限公司 | Data verification method and apparatus, device and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6049612A (en) * | 1997-03-10 | 2000-04-11 | The Pacid Group | File encryption method and system |
| CN103888254A (en) * | 2012-12-21 | 2014-06-25 | 阿里巴巴集团控股有限公司 | Network information verification method and apparatus |
| CN105868171A (en) * | 2015-01-21 | 2016-08-17 | ***（深圳）有限公司 | Checking method and device of Excel file |
| CN107679146A (en) * | 2017-09-25 | 2018-02-09 | 南方电网科学研究院有限责任公司 | The method of calibration and system of electric network data quality |
| CN108345512A (en) * | 2018-03-19 | 2018-07-31 | 重庆金融资产交易所有限责任公司 | Data verification method, server and storage medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104361119B (en) * | 2014-12-02 | 2018-03-06 | 中国农业银行股份有限公司 | A kind of method and system of data scrubbing |
-
2018
- 2018-12-14 CN CN201811532531.XA patent/CN109635300B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6049612A (en) * | 1997-03-10 | 2000-04-11 | The Pacid Group | File encryption method and system |
| CN103888254A (en) * | 2012-12-21 | 2014-06-25 | 阿里巴巴集团控股有限公司 | Network information verification method and apparatus |
| CN105868171A (en) * | 2015-01-21 | 2016-08-17 | ***（深圳）有限公司 | Checking method and device of Excel file |
| CN107679146A (en) * | 2017-09-25 | 2018-02-09 | 南方电网科学研究院有限责任公司 | The method of calibration and system of electric network data quality |
| CN108345512A (en) * | 2018-03-19 | 2018-07-31 | 重庆金融资产交易所有限责任公司 | Data verification method, server and storage medium |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110188334A (en) * | 2019-05-23 | 2019-08-30 | 福建威盾科技集团有限公司 | A kind of method that operation system imports EXCEL data |
| CN110399428A (en) * | 2019-07-26 | 2019-11-01 | 北京奇艺世纪科技有限公司 | A kind of data verification method, device and electronic equipment |
| CN110399428B (en) * | 2019-07-26 | 2022-02-11 | 北京奇艺世纪科技有限公司 | Data verification method and device and electronic equipment |
| CN110765090A (en) * | 2019-10-31 | 2020-02-07 | 泰康保险集团股份有限公司 | Log data management method and device, storage medium and electronic equipment |
| CN110765090B (en) * | 2019-10-31 | 2023-05-02 | 泰康保险集团股份有限公司 | Log data management method and device, storage medium and electronic equipment |
| CN111414739A (en) * | 2020-02-27 | 2020-07-14 | 北京中亦安图科技股份有限公司 | Excel data entry component, entry method and device |
| CN111414739B (en) * | 2020-02-27 | 2023-04-14 | 北京中亦安图科技股份有限公司 | Excel data entry component, entry method and device |
| CN113723767A (en) * | 2021-08-10 | 2021-11-30 | 上海浦东发展银行股份有限公司 | Business process quality inspection method and device based on voice interaction data |
| WO2023051308A1 (en) * | 2021-09-29 | 2023-04-06 | 华为技术有限公司 | Data verification method and apparatus, device and storage medium |
| CN114547033A (en) * | 2022-02-22 | 2022-05-27 | 苏州浪潮智能科技有限公司 | Method, system, equipment and storage medium for managing key product data |
| CN114547033B (en) * | 2022-02-22 | 2024-01-16 | 苏州浪潮智能科技有限公司 | Method, system, equipment and storage medium for managing key product data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109635300B (en) | 2023-12-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109635300A (en) | Data verification method and device | |
| CN103544074B (en) | The method of calibration of a kind of business and device | |
| CN100489879C (en) | Method, system and server for checking page data | |
| CN108345512A (en) | Data verification method, server and storage medium | |
| EP2799995A1 (en) | Information interaction test device and method based on automatic generation of associated test cases | |
| CN104361139A (en) | Data importing device and method | |
| CN109683953A (en) | A kind of method and device carrying out configuration file processing based on visualization interface | |
| CN108564339A (en) | A kind of account management method, device, terminal device and storage medium | |
| EP3218811B1 (en) | Testing insecure computing environments using random data sets generated from characterizations of real data sets | |
| CN109800598A (en) | Certificate administration method, apparatus, electronic equipment and storage medium based on block chain | |
| CN108984388A (en) | A kind of method and terminal device generating automatic test cases | |
| CN107357593A (en) | Source code file construction method, device, electric terminal and readable storage medium storing program for executing | |
| CN106406952B (en) | Electric terminal and application program management apparatus and method | |
| CN110287069A (en) | ESB automatic interface testing method, server and computer readable storage medium | |
| CN108491326A (en) | Behavioral test recombination method, device and storage medium | |
| CN107015957A (en) | User's list generation method and device | |
| CN108920140A (en) | Method of calibration is unified in a kind of front and back end | |
| CN111931471A (en) | Form collection method and device, electronic equipment and storage medium | |
| CN110147373A (en) | Data processing method, device and electronic equipment | |
| Bjesse | What is formal verification? | |
| CN113434542B (en) | Data relationship identification method and device, electronic equipment and storage medium | |
| CN105426183B (en) | A kind of form validation method | |
| CN109446096A (en) | A kind of intelligence contract adjustment method, device and its storage medium | |
| Pautz | Verification of transport codes by the method of manufactured solutions: the ATTILA experience | |
| CN110209572A (en) | Ui testing method, ui testing system and terminal |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |