CN106846136A - A kind of data comparison method and equipment - Google Patents
A kind of data comparison method and equipment Download PDFInfo
- Publication number
- CN106846136A CN106846136A CN201611208662.3A CN201611208662A CN106846136A CN 106846136 A CN106846136 A CN 106846136A CN 201611208662 A CN201611208662 A CN 201611208662A CN 106846136 A CN106846136 A CN 106846136A
- Authority
- CN
- China
- Prior art keywords
- data
- tax
- tax data
- expected
- processing
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/10—Tax strategies
Abstract
The embodiment of the present invention provides a kind of data comparison method and equipment, and the method includes：Obtain tax data after expected tax data and processing, the initial data in the expected tax data same original tax data table corresponding with tax data after processing；Master data in the expected tax data, compares to tax data after the expected tax data and the processing, wherein, at least one master data of the storage with same attribute in master data.Embodiment of the present invention tax data comparison efficiency is higher, tax data compares the degree of accuracy also certain lifting.
Description
Technical field
The present invention relates to technical field of data processing, more particularly to a kind of data comparison method and equipment.
Background technology
Tax data is managed and can be related to substantial amounts of tax data table during analyzing, may between different tax data tables
Different incidence relations are had, each tax data table is used to store original tax data.At present, for the ease of the pipe of tax data
Reason and analysis, are extracted to original tax data using some data mart modeling instruments, are sorted out, are merged, are removed junk data etc.
Data mart modeling is operated, tax data after being processed, so as to be managed to original tax data according to tax data after processing
And analysis.
However, the processing logic in current data mart modeling instrument is complicated, not only including data mart modeling logic, also including tax
Incidence relation logic between business tables of data, and during data mart modeling is carried out to original tax data, due to being related to the tax
The implementation of the incidence relation logic between tables of data, tax data is unexpected tax data after may result in the processing for obtaining
The problem of (wrong data).Accordingly, it would be desirable to test of comparing to tax data after processing, can so entangle to wrong data
Just, with ensure processing after tax data correctness.Wherein, the tax after the different processing of different original tax data table correspondences
Tables of data, original tax data is stored in original tax data table, stores data after processing after processing in tax data table.
At present, the method for conventional test of comparing to tax data after processing is：
For each original tax data table, merely with data mart modeling logic to the original tax in the original tax data table
Business data carry out data mart modeling, obtain the corresponding expected tax data table of the original tax data table, it is contemplated that in tax data table
The data of storage are expected tax data (correct data)；Manually search the tax after the corresponding processing of the original tax data table
Tables of data, and whether manpower comparing is consistent with the data in expected tax data table to tax data table after processing.
However, this mode compared to tax data after processing, tax data table and expected tax number after processing
Manpower comparing pair is needed according to the comparison of data in table, this may result in, and data comparison efficiency is low, compare the low problem of the degree of accuracy.
The content of the invention
The embodiment of the present invention provides a kind of data comparison method and equipment, after solving to process in available data alignments
The comparison of data needs manpower comparing pair in tax data table and expected tax data table, and caused data comparison efficiency is low, ratio
The problem low to the degree of accuracy.
A kind of data comparison method provided in an embodiment of the present invention, including：
Obtain tax data after expected tax data and processing, tax data pair after the expected tax data and processing
Answer the initial data in same original tax data table；
Master data in the expected tax data, to tax number after the expected tax data and the processing
According to comparing, wherein, at least one master data of the storage with same attribute in master data.
Alternatively, in methods described, tax data after the expected tax data and the processing is compared, specifically
Including：
After being screened according to the expected tax data after the screening of default screening rule and according to the default screening rule
Tax data is compared after processing.
The embodiment of the present invention selective can be compared to tax data.
Alternatively, in methods described, the default screening rule includes following one or more：
The default tax authority, default industry, default taxpayer, default type, the default tax category, the tax data of registering are produced
The raw time period.
Alternatively, in methods described, the master data in the expected tax data, to the expected tax data
Compare with tax data after the processing, specifically include：
Whether judge after the processing in the data item of tax data comprising the master data in the expected tax data；
If so, determining that the master data is the master data of tax data after the processing；
For every expected tax data, search this in the master data of tax data after the processing and be expected the tax
Master data in data；
If finding, to tax data and this expection after the corresponding processing of master data of the expected tax data of this
Tax data is compared.
The embodiment of the present invention, is foundation with the master data in tax data after being expected tax data and processing, to expection
Every data after tax data and processing in tax data is compared so that the comparison of tax data is more careful, and
Relative to manpower comparing for, the speed and efficiency of tax data comparison are improve
Alternatively, in methods described, to tax data after the corresponding processing of master data of the expected tax data of this
Compare with the expected tax data of this, specifically include：
Tax data is expected for each in the expected tax data of this, tax after comparing the expection tax data and processing
Whether tax data is consistent after processing in business data in the affiliated data item of expection tax data.
Alternatively, methods described, also includes：
If not finding, determine that the expected tax data of this does not exist in tax data after the processing.
Alternatively, methods described, also includes：
By tax data, whole piece tax after the processing corresponding with every expected tax data of described every expected tax data
The comparison result of data of being engaged in and each expection tax data are arrived with the corresponding storage of comparison result of tax data after corresponding processing
In the result storage table for pre-building.
The embodiment of the present invention also provides a kind of comparing equipment, including：
Acquisition module, for obtain expected tax data and processing after tax data, the expected tax data and plus
Initial data after work in the same original tax data table of tax data correspondence；
Comparing module, for the master data in the expected tax data, to the expected tax data and institute
Tax data is compared after stating processing, wherein, at least one master data of the storage with same attribute in master data.
Alternatively, the comparing module, specifically for：
After being screened according to the expected tax data after the screening of default screening rule and according to the default screening rule
Tax data is compared after processing.
Alternatively, the default screening rule includes following one or more：
The default tax authority, default industry, default taxpayer, default type, the default tax category, the tax data of registering are produced
The raw time period.
Alternatively, the comparing module, including：
Judging unit, for whether judging after the processing in the data item of tax data comprising the expected tax data
In master data；
First determining unit, in the case of judging to be in the judging unit, determines that the master data is described
The master data of tax data after processing；
Searching unit, for for every expected tax data, looks into after the processing in the master data of tax data
The master data looked in the expected tax data of this；
Comparing unit, in the case of being found in the searching unit, to the master data of the expected tax data of this
Tax data is compared with the expected tax data of this after a corresponding processing.
Alternatively, the comparing unit, specifically for：
Tax data is expected for each in the expected tax data of this, tax after comparing the expection tax data and processing
Whether tax data is consistent after processing in business data in the affiliated data item of expection tax data.
Alternatively, the comparing module, also includes：
Second determining unit, in the case of not found in the searching unit, determines that this is expected tax data
Do not exist in tax data after the processing.
Alternatively, the comparing equipment, also includes：
Memory module, for by tax after the processing corresponding with every expected tax data of described every expected tax data
The comparison knot of tax data after business data, the comparison result of whole piece tax data and each expection tax data and corresponding processing
Fruit correspondence is stored in the result storage table for pre-building.
Using data comparison method provided in an embodiment of the present invention and equipment, have the advantages that：
Master data is set in tax data is expected, and automation is according in tax data after master data comparison processing
Whether data are consistent with expected tax data, and the comparison process of tax data is without people after specific expected tax data and processing
Work is participated in, and is realized automation tax data and is compared, relative to the mode of manpower comparing pair, the tax data ratio of the embodiment of the present invention
, tax data higher to efficiency compares the degree of accuracy and manually compare relatively also certain lifting.
Brief description of the drawings
Fig. 1 data comparison method flow chart schematic diagrames provided in an embodiment of the present invention；
The specific implementation process flow chart schematic diagram of Fig. 2 data comparison methods provided in an embodiment of the present invention；
Fig. 3 embodiment of the present invention provides comparing device structure schematic diagram.
Specific embodiment
The data comparison method and equipment for providing the present invention with reference to the accompanying drawings and examples are illustrated in greater detail.
The embodiment of the present invention provides a kind of data comparison method, can be applied to comparing equipment, as shown in figure 1, including：
Step 101, obtains tax data after expected tax data and processing, tax after the expected tax data and processing
Initial data in the business data same original tax data table of correspondence.
Specifically, the explanation on tax data after expected tax data and processing can be found in background section, here
Do not repeat.
Step 102, the master data in the expected tax data, to the expected tax data and the processing
Tax data is compared afterwards, wherein, at least one master data of the storage with same attribute in master data.
Specifically, including data item in tax data and expected tax data after processing, tool is stored in each data item
There are the data of same attribute, the name of each taxpayer is stored in taxpayer's data item.After processing in the data item of tax data
Data be tax data after processing, it is contemplated that data in the data item of tax data are expected tax data, by after processing
Tax data can uniquely determine tax data after a processing after any processing in the data item of tax data, similarly, by pre-
Any expected tax data can uniquely determine an expected tax data in the data item of phase tax data.It should be noted that
The attribute difference of each data after one processing in tax data or an expected tax data.
The embodiment of the present invention pre-sets master data in expected tax data, and storage has same category in master data
Property at least one master data, the master data is main anticipatory data, the master data can as with processing after tax data carry out
The association identification of association, after according to processing corresponding with the master data in tax data after the master data lookup processing
Tax data is compared with expected tax data after tax data, and the processing that will be found.
During specific implementation, whether can search after processing in tax data comprising in the master data in expected tax data
All master datas, if it is, determine that expected tax data is consistent with tax data after processing, otherwise, it determines the two is inconsistent,
Certain master data that also can be using other manner in expected tax data, to tax number after expected tax data and processing
According to comparing, do not limit here.
The embodiment of the present invention, sets master data in expected tax data, and automation compares processing according to master data
Whether the data in tax data are consistent with expected tax data afterwards, tax data after specific expected tax data and processing
Comparison process realizes automation tax data and compares without manually participating in, and relative to the mode of manpower comparing pair, the present invention is implemented
Example tax data comparison efficiency is higher, tax data compares the degree of accuracy and manually compares relatively also certain lifting.
During specific implementation, a part of data after may only needing to compare expected tax data and process in tax data,
Now, it is preferable that tax data after expected tax data and processing can be screened, to pressing according to default screening rule
Tax number after processing after being screened according to the expected tax data after the screening of default screening rule and according to the default screening rule
According to comparing.Specifically default screening rule can include following one or more：The default tax authority, default industry,
Default taxpayer, default registration type, the default tax category, tax data generation time section.Such as, can be default to what is filtered out
Tax data is compared after the processing of the expected tax data and the default tax authority of the tax authority, also can be pre- to what is filtered out
If tax data is compared after the processing of the expected tax data and default industry of industry, can also be to the default row to filtering out
Tax data is compared after the processing of the expected tax data of the default taxpayer of industry and the default taxpayer of default industry.
In actual applications, the embodiment that Fig. 1 is provided can be compiled an automatic test cases, user can be in the survey
Input needs the mark of tax data after the mark of the expected tax data for comparing, processing, and expected tax number in example on probation
Master data in, after user's selection proceeds by comparing, the test case can obtain corresponding automatically according to mark
Tax data is compared after expected tax data and processing, additionally, user can also pre-set screening in the test case
Condition edit item is input into screening conditions, so as to only compare to tax data after the expected tax data for filtering out and processing.
Preferably, the content that can be provided according to Fig. 2, the master data in the expected tax data, to described pre-
Tax data is compared after phase tax data and the processing：
Whether step 201, judge after the processing in the data item of tax data comprising in the expected tax data
Master data, if it is, performing step 202, otherwise, performs step 206.
Specifically, assume that the master data in expected tax data is taxpayer, then from after processing tax data data
Searched whether comprising this data item of taxpayer in.
Step 202, determines that the master data is the master data of tax data after the processing.
In this step, the master data after the master data item in expected tax data is also defined as processing in tax data
.
Whether step 203, for every expected tax data, judge the master data in the expected tax data of this in processing
Exist in the master data of tax data afterwards, if it is, performing step 204, otherwise, perform step 205.
Specifically, being directed to every expected tax data, this is searched in the master data item of tax data after the processing
Master data in expected tax data, if found, performs step 204, if do not found, performs step 205.
Illustrate, it is contemplated that tax data as shown in Table 1, wherein data item include taxpayer, taxable amount, when paying taxes
Between, data item one attribute of correspondence, wherein taxpayer is main data item.Wherein, " Zhang San ", " Li Si ", based on " king five "
Data, an expected tax data is can determine that by any master data, such as, " Zhang San " corresponding expected tax data is
" Zhang San, on March 4th, 1000,2010 ".
Table one
| Taxpayer | Taxable amount | Pay taxes the time |
| Zhang San | 1000 | 2010.3.4 |
| Li Si | 1100 | 2010.3.5 |
| King five | 1500 | 2010.3.6 |
As shown in Table 2, wherein data item includes taxpayer, taxable amount, pays taxes the time tax data, one after processing
Data item one attribute of correspondence, by judging to understand, it is contemplated that this data item of taxpayer tax number after processing in tax data
According to middle presence, accordingly, it is determined that taxpayer this data item is also the master data of data after processing.Wherein, " Li Si ", " king five "
It is master data, the tax data after any master data can determine that a processing, such as, and " Li Si " corresponding expected tax
Data are " Li Si, 1200,2010.3.5 ".
Table two
| Taxpayer | Taxable amount | Pay taxes the time |
| 1000 | 2010.3.4 | |
| Li Si | 1200 | 2010.3.5 |
| King five | 1500 | 2010.3.6 |
Then in step 203, for every expected tax data in table one, the main number in the expected tax data of this is judged
Exist in the master data of tax data according to whether after processing, it can be seen from table one and table two, the result of lookup is expected tax
Master data " Zhang San " in business data does not exist in tax data after processing, now, performs step 205.Expected tax data
In master data " Li Si " and " king five " exist in tax data after processing, now perform step 204.
It should be noted that preferably comparison result is that tax data is completely the same after being expected tax data and processing.
Step 204, to tax data and this expection after the corresponding processing of master data of the expected tax data of this
Tax data is compared.
Specifically, master data in the expected tax data of this after processing in the master data of tax data in the presence of,
Tax data is expected for each in the expected tax data of this, after comparing the expection tax data and processing in tax data
Whether tax data is consistent after processing in the affiliated data item of expection tax data, i.e., a processing corresponding to the master data
Expected tax data after being processed in tax data afterwards in a tax data expected tax data corresponding with the master data enters
Row is compared, so that it is determined that whether each data in this two tax datas are consistent.Preferably, one corresponding to the master data
Other after other processing after processing in tax data in a tax data expected tax data corresponding with the master data
Expected tax data is compared, wherein, tax data is tax number after this processing not including master data after other processing
According to it is that this including master data is not expected tax data that other are expected tax data.
Continue to use the example above, it is assumed that the expected tax data of this is the corresponding expected tax data of Li Si in table one
That is " Li Si, 1100,2010.3.5 ", the master data Li Si in the expected tax data of this can find Li Si from table two
Tax data " Li Si, 1200,2010.3.5 " after a corresponding processing, it is now, same to having in two tax datas successively
The tax data of one attribute is compared, i.e., after comparing the taxpayer in expected tax data respectively and processing in tax data
Whether taxpayer consistent, compare taxable amount after taxable amount in expected tax data and processing in tax data whether one
Cause, whether the time of paying taxes compared in expected tax data is consistent with the time of paying taxes in tax data after processing, compares and completes
Available comparison result is consistent taxpayer afterwards, and taxable amount is inconsistent, time consistency of paying taxes, the tax after now explanation processing
The taxable amount of the taxpayer " Li Si " in data this processing after tax data mistake.
Step 205, determines that the expected tax data of this does not exist in tax data after the processing.
Step 206, it is determined that tax data is completely inconsistent with the expected tax data after processing.
The embodiment of the present invention, is foundation with the master data in tax data after being expected tax data and processing, to expection
Every data after tax data and processing in tax data is compared so that the comparison of tax data is more careful, and
Relative to manpower comparing for, the speed and efficiency of tax data comparison are improve.
Preferably, by tax data after the processing corresponding with every expected tax data of described every expected tax data,
The comparison result of whole piece tax data and each expection tax data are corresponding with the comparison result of tax data after corresponding processing
In storing the result storage table for pre-building.
During specific implementation, result storage table is pre-build, for storing tax data after expected tax data and processing
Comparison result, specifically for every expected tax data and with the expected tax data of this with identical master data
Tax data after processing, correspondence stores in result storage table this two tax datas, and correspondingly by this two taxes
The overall comparison result of data, and result storage table is arrived in the comparison result storage of each tax data in this two tax datas
In, compare intuitively comparison result so as to provide the user one.Continue to continue to use table one and the corresponding example of table two, using this hair
The data comparison method that bright embodiment is provided to table one in expected tax data and table two in processing after tax data carry out
After comparison, corresponding result storage table can as shown in Table 3, and wherein the comparison result of whole piece data includes that X, Y, Z, X represent expected
Deposited in tax data in tax data after processing and do not existed, Y represents that tax data is not quite identical, and Z represents that tax data is complete
Complete consistent, Y is represented, master data comparison result includes that A, B, A represented and deposit in expected tax data in data after processing do not exist,
B exists in data after representing expected tax data and processing, and the comparison result of each data includes that 1,2,1 represent consistent, 2 tables
Show inconsistent, wherein, it is contemplated that tax data is located at after processing before tax data, such as, every first taxpayer of row in table three
It is expected tax data, tax data after second artificial processing of paying taxes, is the two taxpayers' after second taxpayer
Comparison result.
Table three
Certainly, table three is only a kind of citing for representing form of result storage table, the result storage in the embodiment of the present invention
The form that represents of table can also be other forms, not limit here.
Additionally, can also store of tax data after all expected tax datas are processed with all in result storage table
The ratio of cause such that it is able to intuitively obtain the comparison result of overall data.
Based on the inventive concept same with the data comparison method that above-described embodiment is provided, the embodiment of the present invention also provides one
Comparing equipment is planted, as shown in figure 3, including：
Acquisition module 301, for obtain expected tax data and processing after tax data, the expected tax data and
Initial data after processing in the same original tax data table of tax data correspondence；
Comparing module 302, for the master data in the expected tax data, to the expected tax data with
Tax data is compared after the processing, wherein, at least one master data of the storage with same attribute in master data.
Alternatively, the comparing module 302, specifically for：
After being screened according to the expected tax data after the screening of default screening rule and according to the default screening rule
Tax data is compared after processing.
Alternatively, the default screening rule includes following one or more：
The default tax authority, default industry, default taxpayer, default type, the default tax category, the tax data of registering are produced
The raw time period.
Alternatively, the comparing module 302, including：
Judging unit 3021, for whether judging after the processing in the data item of tax data comprising the expected tax
Master data in data；
First determining unit 3022, in the case of judging to be in the judging unit, determines that the master data is
The master data of tax data after the processing；
Searching unit 3023, for for every expected tax data, the master data of tax data after the processing
The middle master data searched in the expected tax data of this；
Comparing unit 3024, in the case of being found in the searching unit, to the master of the expected tax data of this
Tax data is compared with the expected tax data of this after the corresponding processing of data.
Alternatively, the comparing unit 3024, specifically for：
Tax data is expected for each in the expected tax data of this, tax after comparing the expection tax data and processing
Whether tax data is consistent after processing in business data in the affiliated data item of expection tax data.
Alternatively, the comparing module 302, also includes：
Second determining unit 3025, in the case of not found in the searching unit, determines that this is expected the tax
Data do not exist in tax data after the processing.
Alternatively, the comparing equipment, also includes：
Memory module 303, for by after the processing corresponding with every expected tax data of described every expected tax data
The comparison of tax data after tax data, the comparison result of whole piece tax data and each expection tax data and corresponding processing
Result correspondence is stored in the result storage table for pre-building.
Using data comparison method provided in an embodiment of the present invention and equipment, have the advantages that：
Master data is set in tax data is expected, and automation is according in tax data after master data comparison processing
Whether data are consistent with expected tax data, and the comparison process of tax data is without people after specific expected tax data and processing
Work is participated in, and is realized automation tax data and is compared, relative to the mode of manpower comparing pair, the tax data ratio of the embodiment of the present invention
, tax data higher to efficiency compares the degree of accuracy and manually compare relatively also certain lifting.
It should be understood by those skilled in the art that, embodiments of the invention can be provided as method, system or computer program
Product.Therefore, the present invention can use complete hardware embodiment, complete application software embodiment or connected applications software and hardware
The form of the embodiment of aspect.And, the present invention can be used and wherein include computer usable program code at one or more
Computer-usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) on implement calculating
The form of machine program product.
The present invention is the flow with reference to method according to embodiments of the present invention, equipment (system) and computer program product
Figure and/or block diagram are described.It should be understood that every first-class during flow chart and/or block diagram can be realized by computer program instructions
The combination of flow and/or square frame in journey and/or square frame and flow chart and/or block diagram.These computer programs can be provided
The processor of all-purpose computer, special-purpose computer, Embedded Processor or other programmable data processing devices is instructed to produce
A raw machine so that produced for reality by the instruction of computer or the computing device of other programmable data processing devices
The device of the function of being specified in present one flow of flow chart or multiple one square frame of flow and/or block diagram or multiple square frames.
These computer program instructions may be alternatively stored in can guide computer or other programmable data processing devices with spy
In determining the computer-readable memory that mode works so that instruction of the storage in the computer-readable memory is produced and include finger
Make the manufacture of device, the command device realize in one flow of flow chart or multiple one square frame of flow and/or block diagram or
The function of being specified in multiple square frames.
These computer program instructions can be also loaded into computer or other programmable data processing devices so that in meter
Series of operation steps is performed on calculation machine or other programmable devices to produce computer implemented treatment, so as in computer or
The instruction performed on other programmable devices is provided for realizing in one flow of flow chart or multiple flows and/or block diagram one
The step of function of being specified in individual square frame or multiple square frames.
, but those skilled in the art once know basic creation although preferred embodiments of the present invention have been described
Property concept, then can make other change and modification to these embodiments.So, appended claims are intended to be construed to include excellent
Select embodiment and fall into having altered and changing for the scope of the invention.
Obviously, those skilled in the art can carry out the essence of various changes and modification without deviating from the application to the application
God and scope.So, if these modifications of the application and modification belong to the scope of the application claim and its equivalent technologies
Within, then the application is also intended to comprising these changes and modification.
Claims (14)
1. a kind of data comparison method, it is characterised in that including：
Tax data after expected tax data and processing is obtained, the expected tax data is corresponding with tax data after processing same
Initial data in one original tax data table；
Master data in the expected tax data, enters to tax data after the expected tax data and the processing
Row is compared, wherein, at least one master data of the storage with same attribute in master data.
2. method according to claim 1, it is characterised in that to tax number after the expected tax data and the processing
According to comparing, specifically include：
Processing after to being screened according to the expected tax data after the screening of default screening rule and according to the default screening rule
Tax data is compared afterwards.
3. method according to claim 2, it is characterised in that the default screening rule includes following one or more：
When the default tax authority, default industry, default taxpayer, default registration type, the default tax category, tax data are produced
Between section.
4. method according to claim 1, it is characterised in that the master data in the expected tax data is right
Tax data is compared after the expected tax data and the processing, is specifically included：
Whether judge after the processing in the data item of tax data comprising the master data in the expected tax data；
If so, determining that the master data is the master data of tax data after the processing；
For every expected tax data, search this in the master data of tax data after the processing and be expected tax data
In master data；
If finding, the tax is expected with this to tax data after the corresponding processing of master data of the expected tax data of this
Data are compared.
5. method according to claim 4, it is characterised in that the master data to the expected tax data of this is corresponding
Tax data is compared with the expected tax data of this after processing, is specifically included：
Tax data is expected for each in the expected tax data of this, tax number after comparing the expection tax data and processing
Whether tax data is consistent after processing in the affiliated data item of expection tax data.
6. method according to claim 4, it is characterised in that also include：
If not finding, determine that the expected tax data of this does not exist in tax data after the processing.
7. method according to claim 5, it is characterised in that also include：
By tax data, whole piece tax number after the processing corresponding with every expected tax data of described every expected tax data
According to comparison result and each be expected tax data with it is corresponding processing after tax data comparison result it is corresponding store arrive in advance
In the result storage table of foundation.
8. a kind of comparing equipment, it is characterised in that including：
Acquisition module, for obtain expected tax data and processing after tax data, the expected tax data and processing after
Initial data in the same original tax data table of tax data correspondence；
Comparing module, for the master data in the expected tax data, adds to the expected tax data with described
Tax data is compared after work, wherein, at least one master data of the storage with same attribute in master data.
9. equipment according to claim 8, it is characterised in that the comparing module, specifically for：
Processing after to being screened according to the expected tax data after the screening of default screening rule and according to the default screening rule
Tax data is compared afterwards.
10. equipment according to claim 9, it is characterised in that the default screening rule includes following one or more：
When the default tax authority, default industry, default taxpayer, default registration type, the default tax category, tax data are produced
Between section.
11. equipment according to claim 8, it is characterised in that the comparing module, including：
Judging unit, for whether judging after the processing in the data item of tax data comprising in the expected tax data
Master data；
First determining unit, in the case of judging to be in the judging unit, determines that the master data is the processing
The master data of tax data afterwards；
Searching unit, for for every expected tax data, being searched in the master data of tax data after the processing should
Bar is expected the master data in tax data；
Comparing unit, in the case of being found in the searching unit, to the master data correspondence of the expected tax data of this
A processing after tax data and this expection tax data compare.
12. equipment according to claim 11, it is characterised in that the comparing unit, specifically for：
Tax data is expected for each in the expected tax data of this, tax number after comparing the expection tax data and processing
Whether tax data is consistent after processing in the affiliated data item of expection tax data.
13. equipment according to claim 11, it is characterised in that the comparing module, also include：
Second determining unit, in the case of not found in the searching unit, determines the expected tax data of this in institute
State after processing and do not exist in tax data.
14. equipment according to claim 12, it is characterised in that also include：
Memory module, for by tax number after the processing corresponding with every expected tax data of described every expected tax data
According to, the comparison result of whole piece tax data and each be expected the comparison result pair of tax data and tax data after corresponding processing
In should storing the result storage table for pre-building.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611208662.3A CN106846136A (en) | 2016-12-23 | 2016-12-23 | A kind of data comparison method and equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611208662.3A CN106846136A (en) | 2016-12-23 | 2016-12-23 | A kind of data comparison method and equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106846136A true CN106846136A (en) | 2017-06-13 |
Family
ID=59136594
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611208662.3A Pending CN106846136A (en) | 2016-12-23 | 2016-12-23 | A kind of data comparison method and equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106846136A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108334452A (en) * | 2018-02-08 | 2018-07-27 | 深圳壹账通智能科技有限公司 | Regular data transfers test method, device, computer equipment and storage medium |
| CN108681559A (en) * | 2018-04-11 | 2018-10-19 | 广东电网有限责任公司 | A kind of comparison method and system based on multisystem data application |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104268291A (en) * | 2014-10-23 | 2015-01-07 | 税友软件集团股份有限公司 | Data consistency processing method and system |
| CN105184642A (en) * | 2015-09-02 | 2015-12-23 | 浪潮软件集团有限公司 | Comprehensive tax administration platform |
-
2016
- 2016-12-23 CN CN201611208662.3A patent/CN106846136A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104268291A (en) * | 2014-10-23 | 2015-01-07 | 税友软件集团股份有限公司 | Data consistency processing method and system |
| CN105184642A (en) * | 2015-09-02 | 2015-12-23 | 浪潮软件集团有限公司 | Comprehensive tax administration platform |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108334452A (en) * | 2018-02-08 | 2018-07-27 | 深圳壹账通智能科技有限公司 | Regular data transfers test method, device, computer equipment and storage medium |
| CN108681559A (en) * | 2018-04-11 | 2018-10-19 | 广东电网有限责任公司 | A kind of comparison method and system based on multisystem data application |
| CN108681559B (en) * | 2018-04-11 | 2020-09-25 | 广东电网有限责任公司 | Comparison method and system based on multi-system data application |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111027294B (en) | Method, device and system for summarizing table | |
| CN108921166A (en) | Medical bill class text detection recognition method and system based on deep neural network | |
| US8170894B2 (en) | Method of identifying innovations possessing business disrupting properties | |
| CN107741903A (en) | Application compatibility method of testing, device, computer equipment and storage medium | |
| CN107766696A (en) | Eucaryote alternative splicing analysis method and system based on RNA seq data | |
| CN110442847B (en) | Code similarity detection method and device based on code warehouse process management | |
| CN106933863B (en) | Data clearing method and device | |
| CN109800277A (en) | A kind of machine learning platform and the data model optimization method based on the platform | |
| CN106251260A (en) | A kind of candidates' aspiration makes a report on analog systems and method | |
| CN107066534A (en) | Multi-source data polymerization and system | |
| CN111382181A (en) | Designated enterprise family affiliation analysis method and system based on stock right penetration | |
| CN111428095B (en) | Graph data quality verification method and graph data quality verification device | |
| CN112907026A (en) | Comprehensive evaluation method based on editable mesh index system | |
| CN107122386A (en) | The screening technique and device of data | |
| CN106846136A (en) | A kind of data comparison method and equipment | |
| CN106599291B (en) | Data grouping method and device | |
| CN111679808A (en) | RPA robot application requirement evaluation method and device | |
| US20080004855A1 (en) | Design support apparatus, design support method, and design support program | |
| CN103902798A (en) | Data preprocessing method | |
| US20130013244A1 (en) | Pattern based test prioritization using weight factors | |
| CN105138636A (en) | Graph construction method and device for entity relationship | |
| CN102136013A (en) | Manufacturing step information generating system and generating method thereof | |
| CN110457433A (en) | Enterprise query method, apparatus, computer equipment and storage medium | |
| CN103782245B (en) | The manipulation of technological system | |
| Feldkamp et al. | Combining data farming and data envelopment analysis for measuring productive efficiency in manufacturing simulations |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170613 |