CN107943958A - A kind of Individual Income Tax master data sharing method and system - Google Patents
A kind of Individual Income Tax master data sharing method and system Download PDFInfo
- Publication number
- CN107943958A CN107943958A CN201711202107.4A CN201711202107A CN107943958A CN 107943958 A CN107943958 A CN 107943958A CN 201711202107 A CN201711202107 A CN 201711202107A CN 107943958 A CN107943958 A CN 107943958A
- Authority
- CN
- China
- Prior art keywords
- master data
- shared
- data
- tax system
- caching
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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/12—Accounting
- G06Q40/123—Tax preparation or submission
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Development Economics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computing Systems (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of Individual Income Tax master data shared system and method, database copy mode is utilized by horizontal sharing module, legal person's master data of core Individual Income Tax system production is copied to Individual Income Tax system, is shared legal person's master data to each subsystem of Individual Income Tax internal system by shared service；By shared service and database copy mode, natural person's master data of Individual Income Tax system is copied to paying taxes service platform, master data interface is issued to core Individual Income Tax system by shared service；Total tax system master data to be shared is synchronized to target point tax system by total score sharing module by database copy mode；The unified distribution service of master data more new record is called, master data change record data are issued to target tax system by message queue and are cached.In this way, ensure Individual Income Tax master data laterally shared real-time using shared service and database copy mode；By message queue and database copy mode, ensure the real-time of Individual Income Tax master data between total tax system and point tax system.
Description
Technical field
The present invention relates to tax field, more particularly to a kind of Individual Income Tax master data sharing method and system.
Background technology
In tax system, master data generally refers in whole enterprise-wide data to be sharing between each system, industry
Business rule and strategy, for example, taxpayer, the tax category, the tax rate and tax tissue etc..
To make full use of master data resource, the management of master data with regard to it is particularly important that, wherein, the real-time that master data is shared is again
It is the most important thing.In the prior art, the management mode for tax master data is equal access, i.e., by way of interface, respectively
Between a system and master data host, directly interconnect, in this way, can share the master data that current system produces to other need
The system for consuming the master data.For example, A systems produce master data, it is necessary to share to B system and C system, data duplication is utilized
Mode, the master data that multiple copies A systems produce, is transmitted to B system and C system, to realize that master data is shared by interface.But
It is that the real-time of existing tax master data sharing method is relatively low.
The content of the invention
The object of the present invention is to provide a kind of Individual Income Tax master data sharing method and system, shared with to improve Individual Income Tax master data
Real-time.
To achieve the above object, the present invention provides following technical solution：
A kind of Individual Income Tax master data shared system, applied to tax system, which includes total tax system and multiple
Point tax system, and described be always connected between tax system and each described point of tax system by wide area network；Total tax system
System is provided with the unified distribution service of master data more new record and master data write buffer service；Total tax system includes Individual Income Tax system
System, core Individual Income Tax system and paying taxes service platform, and the Individual Income Tax system, the core Individual Income Tax system and the paying taxes service are put down
Platform is connected by LAN, and the Individual Income Tax system is provided with shared service；The system includes：
Horizontal sharing module, for utilizing database copy mode, by the main number of legal person of the core Individual Income Tax system production
According to being copied to the Individual Income Tax system, and legal person's master data is shared to the Individual Income Tax internal system by the shared service
Each subsystem；By the shared service and database copy mode, natural person's master data of the Individual Income Tax system production is answered
System issues master data interface to the paying taxes service platform, and by the shared service to the core Individual Income Tax system；
Total score sharing module, for by database copy mode that the master data to be shared of total tax system is synchronous
Divide the database of tax system to target；The unified distribution service of the master data more new record is called, master data is changed and is recorded
Data are issued to the caching of the target tax system by message queue；The master data write buffer service is called, by described in
The master data to be shared in database writes the caching.
Alternatively, described point of tax system further includes reconciliation service, and the Individual Income Tax master data shared system further includes：
Reconciliation module, for calling the reconciliation service, compares total tax system and stores the master data change record number
According to the first change record sheet and target tax system store the second change record sheet of master data change record data, sentence
Whether the disconnected first change record sheet and the master data change record data in the described second change record sheet are consistent；It is if described
First change record sheet is consistent with the master data change record data in the described second change record sheet, compares second change
During the renewal of the renewal time of the master data change record data in record sheet and the master data to be shared of the database
Between, judge whether consistent；If renewal time is inconsistent or described first changes in record sheet and the second change record sheet
Master data change record data are inconsistent, and the corresponding new master data is updated to the data by database copy mode
Storehouse, the corresponding master data change record data are issued to described in the target tax system by the message queue
Caching.
Alternatively, the total score sharing module includes：
Time order and function judging submodule, for calling the master data write buffer service, the main number in the caching
The master data change record data of the first renewal time of data and the database of the target tax system are recorded according to change
Second renewal time, judges the priority of first renewal time and second renewal time；
First caching writes submodule, for when first renewal time is prior to second renewal time, then not writing
The master data to be shared is to the caching；
Second caching writes submodule, described in when first renewal time being equal to second renewal time, inciting somebody to action
The status indication of master data to be shared is available, and the master data to be shared after mark writes the caching；
3rd caching writes submodule, described in when second renewal time is prior to first renewal time, inciting somebody to action
The status indication of master data to be shared is unavailable, and the master data to be shared after mark writes the caching；
Queue failure alarm submodule, for being unavailable by the status indication of the master data to be shared, and marks
After the master data to be shared afterwards writes the caching, message queue fault alarm information is sent.
Alternatively, the Individual Income Tax system includes the unified access service of caching, and the total score sharing module includes：
Condition adjudgement submodule, for calling the caching is unified to access service, changes record data by the master data
The caching is write, and detects the state of master data to be shared described in the caching, judges whether can use；
Submodule is removed, for when the master data to be shared in the caching is in upstate, described in removing
The master data to be shared in caching；
Status modifier submodule, for when the master data to be shared in the caching is in down state, repairing
The state for changing the master data to be shared in the caching is available.
Alternatively, the Individual Income Tax master data shared system further includes GoldenGate fault alarm modules, for periodically obtaining
The newest master data in the caching is taken to change the 3rd renewal time of record data；Calculate the 3rd renewal time with
The time difference of the renewal time of the corresponding master data of object table in the database of the target tax system；Judge the time
Size between difference and predetermined threshold value；When the time difference is more than the predetermined threshold value, GoldenGate failure reports are sent
Alert information.
Alternatively, the Individual Income Tax shared system further includes master data abatement modules, for obtaining the master of the tax system
Data；The master data of the tax system is analyzed, draws master data quality definition standard；According to the master data quality definition mark
Standard, generates master data proof rule and master data modification rule；By proof rule engine, the master data verification rule are called
Then, master data to be measured is detected, draws quality measurements；By modification rule engine, the master data modification rule is called, is repaiied
Master data just to be modified.
A kind of Individual Income Tax master data sharing method, applied to any of the above-described Individual Income Tax master data shared system, this method includes：
Horizontal sharing module utilizes database copy mode, and legal person's master data of the core Individual Income Tax system production is replicated
To the Individual Income Tax system, and legal person's master data is shared to each subsystem of Individual Income Tax internal system by the shared service
System；By the shared service and database copy mode, natural person's master data of the Individual Income Tax system production is copied to institute
Paying taxes service platform is stated, and master data interface is issued to the core Individual Income Tax system by the shared service；
The master data to be shared of total tax system is synchronized to mesh by total score sharing module by database copy mode
Mark divides the database of tax system；The unified distribution service of the master data more new record is called, master data is changed into record data
The caching of the target tax system is issued to by message queue；The master data write buffer service is called, by the data
The master data to be shared in storehouse writes the caching.
Alternatively, after the master data to be shared by the database writes the caching, further include：
Reconciliation module calls the target to divide the reconciliation service of tax system, compares total tax system and stores the master data
The the first change record sheet and the target tax system storage master data of change record data change the second of record data and become
Change record sheet, judge whether the master data change in the first change record sheet and the second change record sheet records data
Unanimously；
If the first change record sheet is consistent with the master data change record data in the described second change record sheet, than
To described second change record sheet in master data change record data renewal time and the database it is described to be shared
The renewal time of master data, judges whether consistent；
If renewal time is inconsistent or the described first master data changed in record sheet and the second change record sheet becomes
It is inconsistent to change record data, the corresponding new master data is updated to the database by database copy mode, by phase
The master data change record data answered are issued to the caching of the target tax system by the message queue.
Alternatively, the master data write buffer service for calling the target to divide tax system, by the database
The master data to be shared writes the caching, including：
Call the master data write buffer service, the first renewal of the master data change record data in the caching
Second renewal time of the master data to be shared of the database of time and the target tax system, when judging first renewal
Between and second renewal time priority；
When first renewal time is prior to second renewal time, then the master data to be shared is not write to described
Caching；
When first renewal time being equal to second renewal time, by the status indication of the master data to be shared
It is available, and the master data to be shared after mark writes the caching；
When second renewal time is prior to first renewal time, by the status indication of the master data to be shared
To be unavailable, and the master data to be shared after mark writes the caching.
Alternatively, after the master data to be shared by the database writes the caching, further include：
3rd renewal time of the newest master data change record data in caching described in timing acquisition；
Calculate first renewal time master data corresponding to the object table in the database of the target tax system
Renewal time time difference；
Judge the size between the time difference and predetermined threshold value；When the time difference is more than the predetermined threshold value,
Send GoldenGate fault alarm informations.
Individual Income Tax master data shared system and method provided by the present invention, the horizontal sharing module of the system utilize database
Copy mode, Individual Income Tax system is copied to by legal person's master data of core Individual Income Tax system production, and by shared service by legal person master
Data sharing is to each subsystem of Individual Income Tax internal system；By shared service and database copy mode, by Individual Income Tax system production
Natural person's master data is copied to paying taxes service platform, and issues master data interface to core Individual Income Tax system by shared service；Always
The master data to be shared of total tax system is synchronized to target point tax system by point sharing module by database copy mode
Database；The unified distribution service of master data more new record is called, master data is changed record data is issued to by message queue
The caching of target tax system；Master data write buffer service is called, the master data to be shared in database is write into caching.
In this way, Individual Income Tax system, core Individual Income Tax system and paying taxes service are realized by shared service and database copy mode
The Real-Time Sharing of master data between platform, and each subsystem of Individual Income Tax internal system, that is, utilize shared service and database duplication side
Formula ensures that the transverse direction of Individual Income Tax master data shares real-time；Master data change record data are issued using message queue, pass through data
Storehouse copy mode synchronization main data object, i.e., by message queue and database copy mode, ensure total tax system and divide tax
The shared real-time of Individual Income Tax master data between business system.It is higher compared to existing Individual Income Tax master data sharing method, its real-time.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is attached drawing needed in technology description to be briefly described, it should be apparent that, drawings in the following description are 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 structural schematic block diagram of Individual Income Tax master data shared system provided in an embodiment of the present invention；
Fig. 2 laterally shares schematic diagram for Individual Income Tax master data provided in an embodiment of the present invention；
Fig. 3 is that natural person's master data between general bureau provided in an embodiment of the present invention and A provinces point tax system shares schematic diagram；
Fig. 4 is the flow diagram of Individual Income Tax master data sharing method provided in an embodiment of the present invention.
Embodiment
To make the purpose, technical scheme and advantage of the embodiment of the present invention clearer, below in conjunction with the embodiment of the present invention
In attached drawing, the technical solution in the embodiment of the present invention is clearly and completely described, it is clear that described embodiment is
Part of the embodiment of the present invention, instead of all the embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art
All other embodiments obtained without making creative work, belong to the scope of protection of the invention.
Please refer to Fig.1, Fig. 1 is the structural schematic block diagram of Individual Income Tax master data shared system provided in an embodiment of the present invention, should
For tax system, which includes total tax system and multiple points of tax systems, and total tax system and each point of tax
It is connected between business system by wide area network；Total tax system is provided with the unified distribution service of master data more new record and master data write it is slow
The service of depositing；Total tax system includes Individual Income Tax system, core Individual Income Tax system and paying taxes service platform, and Individual Income Tax system, core Individual Income Tax
System is connected with paying taxes service platform by LAN, and Individual Income Tax system is provided with shared service；The system can include：
Horizontal sharing module 11, for utilizing database copy mode, by legal person's master data of core Individual Income Tax system production
Individual Income Tax system is copied to, and is shared legal person's master data to each subsystem of Individual Income Tax internal system by shared service；By shared
Service and database copy mode, paying taxes service platform is copied to by natural person's master data of Individual Income Tax system production, and by altogether
The service of enjoying issues master data interface to core Individual Income Tax system；
Total score sharing module 12, for being synchronized to the master data to be shared of total tax system by database copy mode
Target divides the database of tax system；The unified distribution service of master data more new record is called, master data is changed record data leads to
Cross the caching that message queue is issued to target tax system；Master data write buffer service is called, by the master to be shared in database
Data write-in caching.
It is appreciated that above-mentioned tax system can be specially the tax system of three phase of Golden Taxes, total tax system can be specific
For general bureau's tax system, each point of tax system can be the tax system of each province.Each system passes through office between general bureau's tax system
Domain net is connected, i.e., in the same network segment.General bureau's tax system is connected with the tax system of each province by wide area network, i.e. general bureau's tax
System and province's tax system are in different segment.
Core Individual Income Tax system is produces the tax system of legal person's master data, its general data with storage legal person's master data
Storehouse, and legal person's master data can specifically include taxpayer's essential information (such as Taxpayer Identification Number, taxpayer's title and registration note
Volume type etc.), taxpayer's tax category register information, taxpayer's tax storehouse silver relevant information and this month declare information, taxpayer basis shape
State information etc..
Individual Income Tax system produces natural person's master data, which can include but is not limited to stepping on substantially for natural person
Note information, the base state information of natural person and paid amount of tax to be paid information for declaring year of natural person etc..Individual Income Tax internal system bag
Multiple subsystems are included, are particularly but not limited to taxpayer's management subsystem, legal person declares collection subsystem, natural person declares collection
System and assessment audit subsystem etc..
It is to be appreciated that this example provides horizontal sharing module and total score sharing module, wherein, horizontal sharing module is mainly real
Individual Income Tax master data between existing Individual Income Tax system, core Individual Income Tax system and paying taxes service platform, and each subsystem of Individual Income Tax internal system
Shared, total score sharing module mainly realizes that the Individual Income Tax master data between total tax system and point tax system is shared.
First, the process that Individual Income Tax master data is laterally shared to total tax system is introduced.Referring to the Individual Income Tax master shown in Fig. 2
Laterally shared schematic diagram, Individual Income Tax system are provided with Individual Income Tax core processing platform to data, which is provided with altogether
The service of enjoying, shared service respectively with taxpayer management, legal person declares collection, natural person declares collection, proof and assessment audit etc.
Subsystem is connected, and each subsystem has corresponding database, has corresponding taxpayer to manage for example, taxpayer manages subsystem
Li Ku, legal person, which declares collection subsystem, has corresponding legal person to declare collection storehouse.Individual Income Tax system is provided with for storing natural person master
The database of data and the database for storing legal person's master data.
Wherein, core Individual Income Tax system is the producer of legal person's master data, will by database copy mode GoldenGate
Legal person's master data replicates the database of storage legal person's master data of Individual Income Tax system, and then, Individual Income Tax system is accessed by shared service
Associated databases, to complete the consumption of legal person's master data.
Individual Income Tax system is the producer of natural person's master data, by GoldenGate modes, the natural person master that will be produced
In the database of data duplication paying taxes service platform, and the inquiry of natural person's master data and more new interface are provided by shared service,
To complete the consumption of natural person's master data.
In total tax system laterally shared Individual Income Tax master data, mainly ensure between each system by shared service
The real-time of tax master data synchronization.
Then, the Individual Income Tax master data between total tax system and each point of tax system is shared and be introduced.In total tax
After system responds corresponding service request, Individual Income Tax master data can be produced in itself and master data change record data both main numbers
According to type.Need both master data Real-Time Sharings to consuming the target point tax system of both master datas, and need to protect
The shared real-time of card.
Total score sharing module can correspondingly update the corresponding master data of total tax system after business operation success, and
Update corresponding business datum table.This portion of primary data is copied to target point tax system especially by GoldenGate modes
Storage master data database.Then, the master data write buffer service of target point tax system is recycled to divide target to the tax
Master data in the database of system is write into caching, waits the application program that target divides tax system to read main number in caching
According to.
Master data change record data can be but be limited to electronic record number, master data type and newest transformation period etc. number
According to this portion of primary data is issued to target point by calling the unified distribution service of master data more new record using message queue
In the caching of tax system.
To ensure the uniformity and accuracy of master data, the judgement of time order and function can be carried out.Therefore in the present embodiment, it is above-mentioned
Total score sharing module can include：Time order and function judging submodule, for calling master data write buffer service, compares in caching
The master data change record data of first renewal time of master data change record data and the database of target tax system
Second renewal time, judges the priority of the first renewal time and the second renewal time；First caching writes submodule, for when first
When renewal time is prior to the second renewal time, then master data to be shared is not write to caching；Second caching writes submodule, for when the
When one renewal time was equal to for the second renewal time, the status indication by master data to be shared is available, and to be shared after mark
Master data write-in caching；3rd caching writes submodule, will be to be shared for when the second renewal time is prior to the first renewal time
The status indication of master data is unavailable, and the master data to be shared write-in caching after mark；Queue failure alarm submodule, is used
To be unavailable, and after the master data to be shared write-in caching after marking, send and disappear in by the status indication of master data to be shared
Cease queue failure warning message.
It is appreciated that above-mentioned first renewal time and the second renewal time refer to reaching the main number in caching and database
According to recorded data renewal time in change record data.
By compare master data change record data and master data renewal time, when master data change record data earlier than
Master data reaches, i.e. the first renewal time prior to the second renewal time, at this time, corresponding master data is not write in caching；When
The time consistency that master data change record data are reached with master data, i.e. the first renewal time were equal to for the second renewal time, then will
The status indication of master data is available, and is write in caching；Reached when master data change record data are later than master data, i.e., second
Renewal time prior to the first renewal time, at this time, then understands message queue there are failure, and it is completeer to cause to issue the time, except will
Master data is labeled as unavailable, and accordingly write-in caching is outer, can be sent out queue failure warning message.
In addition, to ensure accuracy that master data issues, corresponding GoldenGate can be set to monitor.Therefore the present embodiment
In, Individual Income Tax master data shared system can also include GoldenGate fault alarm modules, in being cached for timing acquisition most
First renewal time of new master data change record data；Calculate the database of the first renewal time and target tax system
In the corresponding master data of object table renewal time time difference；Judge the size between time difference and predetermined threshold value；At that time
Between difference when being more than predetermined threshold value, send GoldenGate fault alarm informations.
The unified distribution service of master data more new record include the unified access service of asynchronous components, asynchronous service processing component,
Distribution channel for distribution is unified in master data order distribution service, master data more new record, and asynchronous service processing component includes a unified life
Queue and multiple distribution queues are made, is specifically as follows a unity of command queue and the master data distribution queue of 36 provinces.Specifically
Will corresponding main number by the queue that divides master data change record data distribution to tax system to target, then passing through queue
In the caching for dividing tax system to target according to change record data distributing.
Wherein, when master data more new recorded data arrival target divides tax system, it can utilize and cache unique caching access
Main number more new recorded data is write and cached by service.
Therefore in the present embodiment, above-mentioned Individual Income Tax system includes unified access of caching and services, and total score sharing module can include：Shape
State judging submodule, unified access service is cached for calling, and master data is changed record data write-in caches, and detects caching
In master data to be shared state, judge whether can use；Submodule is removed, being in for the master data to be shared in caching can
During with state, the master data to be shared in caching is removed；Status modifier submodule, at the master data to be shared in caching
When down state, the state of the master data to be shared in modification caching is available.
To ensure that total tax system and target divide the uniformity and accuracy of the Individual Income Tax master data between tax system, Ke Yitong
Cross and compare the uniformity of shared Individual Income Tax master data between the two to judge.Therefore in the present embodiment, point tax system can also include
Reconciliation service, Individual Income Tax master data shared system can also include：Reconciliation module, for calling reconciliation service, compares total tax system
The the first change record sheet and target tax system storage master data change record data of system storage master data change record data
Second change record sheet, judge first change record sheet and second change record sheet in master data change record data whether
Unanimously；If the master data change record data in the first change record sheet and the second change record sheet are consistent, the second change is compared
The renewal time of master data change record data in record sheet and the renewal time of the master data to be shared of database, judgement are
It is no consistent；If renewal time is inconsistent or the first master data change changed in record sheet and the second change record sheet records data
It is inconsistent, corresponding new master data is updated to database by database copy mode, corresponding master data is changed and is recorded
Data are issued to the caching of target tax system by message queue.
Further, the reconciliation operation between total tax system and target point tax system can be timing, for example, every
Half a day or one day then carry out a reconciliation or not timing.
Preferably to divide total tax system and target the master data shared procedure between tax system, it may refer to Fig. 3 and show
Natural person's master data that the general bureau gone out and A are saved between point tax system is shared schematic diagram and is illustrated.
As shown in figure 3, general bureau is main data producer, it is main data consumer that A, which saves tax system,.General bureau produces master data
After object and master data change record data, using GoldenGate modes by the shared main number in general bureau's natural person's primary database
In database according to the natural person's master data for being copied to A provinces.Meanwhile the unified distribution service of master data more new record is called, by master
Data change record data save master data distribution queue to A, then, MDB are uniformly distributed by Maurer Data Record and is issued to A provinces
Unified access of caching services, and caching is unified to access service by master data change record data write-in caching.Main data object exists
After the database for reaching natural person's master data that A is saved, by calling the service of master data write buffer to write corresponding main data object
Enter caching.Whether the state that then the unified access service of caching can detect the main data object in caching can use.In addition, utilize figure
In reconciliation service and the specific implementation processes of GoldenGate main data channel monitoring services may refer to corresponding contents above.
To improve the master data quality of tax system, it can then pass through these by defining the quality definition of master data
Quality definition detects amendment master data.Therefore in the present embodiment, Individual Income Tax shared system can also include master data abatement modules, use
In the master data for obtaining tax system；The master data of analyzing tax system, draws master data quality definition standard；According to master data
Quality definition standard, generates master data proof rule and master data modification rule；By proof rule engine, master data is called to test
Card rule, detects master data to be measured, draws quality measurements；By modification rule engine, master data modification rule is called, is repaiied
Master data just to be modified.
It is to be appreciated that quality definition can include but is not limited to accuracy definition, integrality defines, representative defines and can
The definition of access property.Master can be corrected to detect by dimensions such as the accuracy of master data, integrality, representative and accessibilities
The quality of data.
When correcting master data, can be it is automatic correct or manual correction, when manual correction, is repaiied manually by providing
Positive interface is realized.
For ease of analyzing testing result and correction result, by analyzing testing result and correction result, to draw
Corresponding information, can preserve correction result and testing result, can specifically be stored in daily record, in this way, after being easy to
Continuous data analysis.
In the present embodiment, Individual Income Tax system, core Individual Income Tax system are realized by shared service and database copy mode and received
The Real-Time Sharing of master data, that is, utilize shared service and database between tax service platform, and each subsystem of Individual Income Tax internal system
Copy mode ensures that the transverse direction of Individual Income Tax master data shares real-time；Master data change record data are issued using message queue, are led to
Database copy mode synchronization main data object is crossed, i.e., by message queue and database copy mode, ensures total tax system
And divide the shared real-time of the Individual Income Tax master data between tax system.Compared to existing Individual Income Tax master data sharing method, its real-time
It is higher.
Individual Income Tax master data sharing method provided in an embodiment of the present invention is introduced below, the main number of Individual Income Tax described below
According to sharing method reference can be corresponded with above-described Individual Income Tax master data shared system.
Please refer to Fig.4, Fig. 4 be Individual Income Tax master data sharing method provided in an embodiment of the present invention flow diagram, the party
Method is applied to above-mentioned Individual Income Tax master data shared system, and this method includes：
Step 401, horizontal sharing module utilize database copy mode, by legal person's master data of core Individual Income Tax system production
Individual Income Tax system is copied to, and is shared legal person's master data to each subsystem of Individual Income Tax internal system by shared service；By shared
Service and database copy mode, paying taxes service platform is copied to by natural person's master data of Individual Income Tax system production, and by altogether
The service of enjoying issues master data interface to core Individual Income Tax system；
Step 402, total score sharing module are synchronous by the master data to be shared of total tax system by database copy mode
Divide the database of tax system to target；The unified distribution service of master data more new record is called, master data is changed into record data
The caching of target tax system is issued to by message queue；Master data write buffer service is called, will be to be shared in database
Master data write-in caching.
, can be with after by the master data to be shared write-in caching in database in some feasible embodiments
Including：
Reconciliation module invocation target divides the reconciliation service of tax system, compares total tax system storage master data change record
First change record sheet of data and the second change record sheet of target tax system storage master data change record data, judge
Whether the master data change record data in the first change record sheet and the second change record sheet are consistent；
If the master data change record data in the first change record sheet and the second change record sheet are consistent, compare second and become
Change the renewal time of the master data change record data in record sheet and the renewal time of the master data to be shared of database, judge
It is whether consistent；
If renewal time is inconsistent or the first master data change changed in record sheet and the second change record sheet records number
According to inconsistent, corresponding new master data is updated to database by database copy mode, corresponding master data is changed and is remembered
Record data are issued to the caching of target tax system by message queue.
In some feasible embodiments, invocation target divides the master data write buffer service of tax system, by database
In master data to be shared write-in caching process be specially：
Master data write buffer service is called, compares the first renewal time and mesh that the master data change in caching records data
The second renewal time of the primary database change record data of the database of tax system is marked, judges the first renewal time and second
The priority of renewal time；
When the first renewal time is prior to the second renewal time, then master data to be shared is not write to caching；
When the first renewal time being equal to for the second renewal time, the status indication by master data to be shared is available, and is marked
Master data to be shared write-in caching after note；
It is unavailable by the status indication of master data to be shared when the second renewal time is prior to the first renewal time, and
Master data to be shared write-in caching after mark.
, can be with after by the master data to be shared write-in caching in database in some feasible embodiments
Including：
First renewal time of the newest master data change record data in timing acquisition caching；
When calculating the renewal of the first renewal time master data corresponding to the object table in the database of target tax system
Between time difference；
Judge the size between time difference and predetermined threshold value；When time difference is more than predetermined threshold value, send
GoldenGate fault alarm informations.
Individual Income Tax master data sharing method provided in this embodiment has same beneficial with above-mentioned Individual Income Tax master data shared system
Effect, details are not described herein.
Each embodiment is described by the way of progressive in specification, and what each embodiment stressed is and other realities
Apply the difference of example, between each embodiment identical similar portion mutually referring to.For device disclosed in embodiment
Speech, since it is corresponded to the methods disclosed in the examples, so description is fairly simple, related part is referring to method part illustration
.
Professional further appreciates that, with reference to each exemplary unit of the embodiments described herein description
And algorithm steps, can be realized with electronic hardware, computer software or the combination of the two, in order to clearly demonstrate hardware and
The interchangeability of software, generally describes each exemplary composition and step according to function in the above description.These
Function is performed with hardware or software mode actually, application-specific and design constraint depending on technical solution.Specialty
Technical staff can realize described function to each specific application using distinct methods, but this realization should not
Think beyond the scope of this invention.
Can directly it be held with reference to the step of method or algorithm that the embodiments described herein describes with hardware, processor
Capable software module, or the two combination are implemented.Software module can be placed in random access memory (RAM), memory, read-only deposit
Reservoir (ROM), electrically programmable ROM, electrically erasable ROM, register, hard disk, moveable magnetic disc, CD-ROM or technology
In any other form of storage medium well known in field.
Individual Income Tax master data shared system provided by the present invention and method are described in detail above.It is used herein
Specific case is set forth the principle of the present invention and embodiment, to understand the explanation of above example is only intended to helping
The method and its core concept of the present invention.It should be pointed out that for those skilled in the art, this is not being departed from
On the premise of inventive principle, some improvement and modification can also be carried out to the present invention, these are improved and modification also falls into the present invention
In scope of the claims.
Claims (10)
1. a kind of Individual Income Tax master data shared system, it is characterised in that applied to tax system, which includes total tax system
System and multiple points of tax systems, and described be always connected between tax system and each described point of tax system by wide area network；It is described
Total tax system is provided with the unified distribution service of master data more new record and master data write buffer service；Total tax system bag
Include Individual Income Tax system, core Individual Income Tax system and paying taxes service platform, and the Individual Income Tax system, the core Individual Income Tax system and described receive
Tax service platform is connected by LAN, and the Individual Income Tax system is provided with shared service；The system includes：
Horizontal sharing module, for utilizing database copy mode, legal person's master data of the core Individual Income Tax system production is answered
System shares legal person's master data to each son of Individual Income Tax internal system to the Individual Income Tax system, and by the shared service
System；By the shared service and database copy mode, natural person's master data of the Individual Income Tax system production is copied to
The paying taxes service platform, and master data interface is issued to the core Individual Income Tax system by the shared service；
Total score sharing module, for the master data to be shared of total tax system to be synchronized to mesh by database copy mode
Mark divides the database of tax system；The unified distribution service of the master data more new record is called, master data is changed into record data
The caching of the target tax system is issued to by message queue；The master data write buffer service is called, by the data
The master data to be shared in storehouse writes the caching.
2. the system as claimed in claim 1, it is characterised in that described point of tax system further includes reconciliation service, the Individual Income Tax
Master data shared system further includes：
Reconciliation module, for calling the reconciliation service, compares total tax system and stores the master data change record data
First change record sheet and target tax system store the second change record sheet of the master data change record data, judge institute
State the first change record sheet and whether the master data change record data in the described second change record sheet are consistent；If described first
It is consistent with the master data change record data in the described second change record sheet to change record sheet, compares the second change record
The renewal time of master data change record data in table and the renewal time of the master data to be shared of the database, sentence
It is disconnected whether consistent；If renewal time it is inconsistent or it is described first change record sheet and it is described second change record sheet in master data
Change record data are inconsistent, and the corresponding new master data is updated to the database by database copy mode, will
The corresponding master data change record data are issued to the caching of the target tax system by the message queue.
3. system as claimed in claim 2, it is characterised in that the total score sharing module includes：
Time order and function judging submodule, for calling the master data write buffer service, the master data in the caching becomes
Change the second of the master data change record data of the first renewal time of record data and the database of the target tax system
Renewal time, judges that first renewal time and described second reaches the priority of renewal；
First caching writes submodule, described for when first renewal time is prior to second renewal time, then not writing
Master data to be shared is to the caching；
Second caching writes submodule, for when first renewal time being equal to second renewal time, being treated described altogether
The status indication for enjoying master data is available, and the master data to be shared after mark writes the caching；
3rd caching writes submodule, for when second renewal time is prior to first renewal time, being treated described altogether
The status indication for enjoying master data is unavailable, and the master data to be shared after mark writes the caching；
Queue failure alarm submodule, for being unavailable by the status indication of the master data to be shared, and after mark
After the master data to be shared writes the caching, message queue fault alarm information is sent.
4. system as claimed in claim 2, it is characterised in that the Individual Income Tax system includes unified access of caching and services, described
Total score sharing module includes：
Condition adjudgement submodule, for calling the caching is unified to access service, changes record data write-in by the master data
The caching, and the state of master data to be shared described in the caching is detected, judge whether can use；
Submodule is removed, for when the master data to be shared in the caching is in upstate, removing the caching
In the master data to be shared；
Status modifier submodule, for when the master data to be shared in the caching is in down state, changing institute
The state for stating the master data to be shared in caching is available.
5. such as Claims 1-4 any one of them system, it is characterised in that the Individual Income Tax master data shared system further includes
GoldenGate fault alarm modules, for the newest master data change record data in caching described in timing acquisition the 3rd
Renewal time；Calculate the 3rd renewal time master data corresponding to the object table in the database of the target tax system
Renewal time time difference；Judge the size between the time difference and predetermined threshold value；When the time difference is more than institute
When stating predetermined threshold value, GoldenGate fault alarm informations are sent.
6. system as claimed in claim 5, it is characterised in that the Individual Income Tax shared system further includes master data abatement modules,
For obtaining the master data of the tax system；The master data of the tax system is analyzed, draws master data quality definition standard；
According to the master data quality definition standard, master data proof rule and master data modification rule are generated；Drawn by proof rule
Hold up, call the master data proof rule, detect master data to be measured, draw quality measurements；By modification rule engine, adjust
With the master data modification rule, master data to be modified is corrected.
7. a kind of Individual Income Tax master data sharing method, it is characterised in that applied to above-mentioned such as any one of claim 1 to 6 Individual Income Tax master
Data-sharing systems, this method include：
Horizontal sharing module utilizes database copy mode, and legal person's master data of the core Individual Income Tax system production is copied to institute
Individual Income Tax system is stated, and is shared legal person's master data to each subsystem of Individual Income Tax internal system by the shared service；
By the shared service and database copy mode, natural person's master data of the Individual Income Tax system production is copied to described receive
Tax service platform, and master data interface is issued to the core Individual Income Tax system by the shared service；
The master data to be shared of total tax system is synchronized to target point by total score sharing module by database copy mode
The database of tax system；The unified distribution service of the master data more new record is called, master data is changed record data passes through
Message queue is issued to the caching of the target tax system；The master data write buffer service is called, by the database
The master data to be shared write the caching.
8. the method as described in right 7, it is characterised in that write in the master data to be shared by the database
After the caching, further include：
Reconciliation module calls the target to divide the reconciliation service of tax system, compares total tax system and stores the master data change
Record the first change record sheet of data and target tax system stores the second change note of the master data change record data
Record table, judge it is described first change record sheet and it is described second change record sheet in master data change record data whether one
Cause；
If the first change record sheet is consistent with the master data change record data in the described second change record sheet, institute is compared
State the renewal time of master data change record data in the second change record sheet and the main number to be shared of the database
According to renewal time, judge whether consistent；
If renewal time is inconsistent or the described first master data change changed in record sheet and the second change record sheet is remembered
It is inconsistent to record data, the corresponding new master data is updated to the database by database copy mode, will be corresponding
The master data change record data are issued to the caching of the target tax system by the message queue.
9. method as claimed in claim 8, it is characterised in that the master data of the calling target point tax system is write slow
The service of depositing, the caching is write by the master data to be shared in the database, including：
Call the master data write buffer service, the first renewal time of the master data change record data in the caching
With the second renewal time of the master data change record data of the database of the target tax system, first renewal is judged
Time and the priority of second renewal time；
When first renewal time is prior to second renewal time, then the master data to be shared is not write and is delayed to described
Deposit；
When first renewal time being equal to second renewal time, being by the status indication of the master data to be shared can
With, and the master data to be shared after mark writes the caching；
When second renewal time is prior to first renewal time, by the status indication of the master data to be shared for not
It can use, and the master data to be shared after mark writes the caching.
10. such as claim 7 to 9 any one of them method, it is characterised in that will be treated described described in the database
Shared master data is write after the caching, is further included：
3rd renewal time of the newest master data change record data in caching described in timing acquisition；
Calculate the 3rd renewal time master data corresponding to the object table in the database of the target tax system more
The time difference of new time；
Judge the size between the time difference and predetermined threshold value；When the time difference is more than the predetermined threshold value, send
GoldenGate fault alarm informations.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711202107.4A CN107943958B (en) | 2017-11-24 | 2017-11-24 | Individual tax owner data sharing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711202107.4A CN107943958B (en) | 2017-11-24 | 2017-11-24 | Individual tax owner data sharing method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107943958A true CN107943958A (en) | 2018-04-20 |
| CN107943958B CN107943958B (en) | 2021-05-25 |
Family
ID=61948950
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711202107.4A Active CN107943958B (en) | 2017-11-24 | 2017-11-24 | Individual tax owner data sharing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107943958B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109241072A (en) * | 2018-08-31 | 2019-01-18 | 携程计算机技术（上海）有限公司 | Buffering updating method and system based on Canal |
| CN110413673A (en) * | 2019-07-08 | 2019-11-05 | 中国人民银行清算总中心 | The unified acquisition of database data and distribution method and system |
| CN113377857A (en) * | 2021-07-02 | 2021-09-10 | 招商局金融科技有限公司 | Data distribution method and device, electronic equipment and readable storage medium |
| CN117473017A (en) * | 2023-11-24 | 2024-01-30 | 西安道弘至微信息科技有限公司 | Main data management method based on custom structure |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105574158A (en) * | 2015-12-15 | 2016-05-11 | 广州品唯软件有限公司 | Refreshing method and system of database caching data |
| US9503542B1 (en) * | 2014-09-30 | 2016-11-22 | Emc Corporation | Writing back data to files tiered in cloud storage |
| CN106203988A (en) * | 2016-07-26 | 2016-12-07 | 通联支付网络服务股份有限公司 | A kind of aggregate payment core system |
| CN106254457A (en) * | 2016-08-05 | 2016-12-21 | 四川省国土资源厅信息中心 | Real estate data-sharing systems based on WCF technology and data sharing method |
| CN106533804A (en) * | 2016-12-22 | 2017-03-22 | 成都西加云杉科技有限公司 | Network operation support system |
-
2017
- 2017-11-24 CN CN201711202107.4A patent/CN107943958B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9503542B1 (en) * | 2014-09-30 | 2016-11-22 | Emc Corporation | Writing back data to files tiered in cloud storage |
| CN105574158A (en) * | 2015-12-15 | 2016-05-11 | 广州品唯软件有限公司 | Refreshing method and system of database caching data |
| CN106203988A (en) * | 2016-07-26 | 2016-12-07 | 通联支付网络服务股份有限公司 | A kind of aggregate payment core system |
| CN106254457A (en) * | 2016-08-05 | 2016-12-21 | 四川省国土资源厅信息中心 | Real estate data-sharing systems based on WCF technology and data sharing method |
| CN106533804A (en) * | 2016-12-22 | 2017-03-22 | 成都西加云杉科技有限公司 | Network operation support system |
Non-Patent Citations (1)
| Title |
|---|
| 咸亚梅 等: "Oracle 数据复制及灾难备份解决", 《艺术文化交流》 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109241072A (en) * | 2018-08-31 | 2019-01-18 | 携程计算机技术（上海）有限公司 | Buffering updating method and system based on Canal |
| CN110413673A (en) * | 2019-07-08 | 2019-11-05 | 中国人民银行清算总中心 | The unified acquisition of database data and distribution method and system |
| CN110413673B (en) * | 2019-07-08 | 2022-02-11 | 中国人民银行清算总中心 | Database data unified acquisition and distribution method and system |
| CN113377857A (en) * | 2021-07-02 | 2021-09-10 | 招商局金融科技有限公司 | Data distribution method and device, electronic equipment and readable storage medium |
| CN117473017A (en) * | 2023-11-24 | 2024-01-30 | 西安道弘至微信息科技有限公司 | Main data management method based on custom structure |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107943958B (en) | 2021-05-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107943958A (en) | A kind of Individual Income Tax master data sharing method and system | |
| CN111159157B (en) | Index processing method and device for enterprise report data | |
| CN104462432B (en) | Adaptive distributed computing method | |
| CN107589915A (en) | Capacity information monitoring method, device and the equipment of a kind of distributed memory system | |
| CN110191168A (en) | Processing method, device, computer equipment and the storage medium of online business datum | |
| CN110399351A (en) | The processing method and system of audit log data | |
| CN113485988A (en) | Data quality monitoring method and device and computer readable storage medium | |
| CN106504140A (en) | The intellectual property data system of various dimensions technology correlation evaluation | |
| CN107506466A (en) | A kind of small documents storage method and system | |
| CN110175206A (en) | Intellectual analysis operational approach, system and medium for multiple database separation | |
| CN107491558A (en) | Metadata updates method and device | |
| CN113342834A (en) | Method for solving historical data change in big data system | |
| CN109325011A (en) | Data storage, processing, sharing method and system based on block chain | |
| CN105867895A (en) | Method for realizing code management and need management information synchronization and device thereof | |
| CN111737266B (en) | Block data access method, block data storage method and device | |
| CN108228624A (en) | Data acquisition and update method, piece list service system and piece single system | |
| CN113297146A (en) | Processing model and method for local supervision submission data | |
| CN115129618A (en) | Method and apparatus for optimizing data caching | |
| CN106126568A (en) | One promotes mainly formula serializing buffer memory management method and system | |
| CN111813880B (en) | Homeland space planning project management method, system and storage medium | |
| CN107391708A (en) | The method and device that performance statistics file stores in a kind of storage system | |
| CN107622124A (en) | Data query method and system based on block number evidence | |
| CN115018657B (en) | Vehicle insurance quotation quantification method and device, computer equipment and storage medium | |
| CN109034982A (en) | Order information accelerated processing method and device in millions order table | |
| CN115017223B (en) | A system that supports import and export of large amounts of data |
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 |