CN107943958B - Individual tax owner data sharing method and system - Google Patents

Individual tax owner data sharing method and system Download PDF

Info

Publication number
CN107943958B
CN107943958B CN201711202107.4A CN201711202107A CN107943958B CN 107943958 B CN107943958 B CN 107943958B CN 201711202107 A CN201711202107 A CN 201711202107A CN 107943958 B CN107943958 B CN 107943958B
Authority
CN
China
Prior art keywords
main data
data
tax
cache
change record
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.)
Active
Application number
CN201711202107.4A
Other languages
Chinese (zh)
Other versions
CN107943958A (en
Inventor
刘红玉
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Servyou Software Group Co ltd
Original Assignee
Servyou Software Group Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Servyou Software Group Co ltd filed Critical Servyou Software Group Co ltd
Priority to CN201711202107.4A priority Critical patent/CN107943958B/en
Publication of CN107943958A publication Critical patent/CN107943958A/en
Application granted granted Critical
Publication of CN107943958B publication Critical patent/CN107943958B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12Accounting
    • G06Q40/123Tax 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 system and a method for sharing main data of individual taxes, which are characterized in that main data of a legal person produced by a core individual taxes system is copied to the individual taxes system by a transverse sharing module in a database copying mode, and the main data of the legal person is shared to each subsystem in the individual taxes system by sharing service; copying the natural person main data of the personal tax system to a tax payment service platform in a sharing service and database copying mode, and issuing a main data interface to the core personal tax system through the sharing service; the total sharing module synchronizes main data to be shared of the total tax system to the target branch tax system in a database copying mode; calling a main data updating record unified distribution service, and issuing main data change record data to a target tax system cache through a message queue. Therefore, the horizontal sharing real-time performance of the personal tax owner data is ensured by using a sharing service and a database copying mode; the real-time performance of the tax owner data between the total tax system and the tax branch system is ensured by the message queue and the database copying mode.

Description

Individual tax owner data sharing method and system
Technical Field
The invention relates to the field of tax affairs, in particular to a method and a system for sharing personal tax owner data.
Background
In a tax system, primary data generally refers to data, business rules and policies to be shared among various systems throughout the enterprise, such as taxpayers, taxes, tax rates, and tax organizations.
The management of the main data is particularly important to fully utilize the main data resources, wherein the real-time performance of the main data sharing is important. In the prior art, the management mode of the tax main data is equal access, namely, the management mode of the tax main data is that all systems and a main data host are directly interconnected in an interface mode, so that the main data generated by the current system can be shared to other systems needing to consume the main data. For example, the system a generates main data, which needs to be shared to the system B and the system C, and the main data generated by the system a is copied for multiple times by using a data copying manner and transmitted to the system B and the system C through the interface, so as to realize the sharing of the main data. However, the existing tax main data sharing method is low in real-time performance.
Disclosure of Invention
The invention aims to provide a method and a system for sharing personal tax owner data so as to improve the real-time performance of the sharing of the personal tax owner data.
In order to achieve the purpose, the invention provides the following technical scheme:
a tax owner data sharing system is applied to a tax system, the tax system comprises a total tax system and a plurality of branch tax systems, and the total tax system is connected with each branch tax system through a wide area network; the total tax system is provided with a main data updating record unified distribution service and a main data writing cache service; the general tax system comprises a personal tax system, a core personal tax system and a tax payment service platform, wherein the personal tax system, the core personal tax system and the tax payment service platform are connected through a local area network, and the personal tax system is provided with a sharing service; the system comprises:
the transverse sharing module is used for copying the main data of the legal person produced by the core individual tax system to the individual tax system by using a database copying mode and sharing the main data of the legal person to each subsystem in the individual tax system through the sharing service; copying the natural person master data produced by the personal tax system to the tax payment service platform through the sharing service and a database copying mode, and issuing a master data interface to the core personal tax system through the sharing service;
the total sharing module is used for synchronizing the main data to be shared of the total tax system to a database of a target tax system in a database replication mode; calling the main data updating record unified distribution service, and issuing main data change record data to the cache of the target tax system through a message queue; and calling the main data write cache service to write the main data to be shared in the database into the cache.
Optionally, the tax separating system further includes an account checking service, and the tax owner data sharing system further includes:
the account checking module is used for calling the account checking service, comparing a first change record table of the main data change record data stored by a total tax system with a second change record table of the main data change record data stored by a target tax system, and judging whether the main data change record data in the first change record table and the second change record table are consistent; if the main data change record data in the first change record table and the second change record table are consistent, comparing the update time of the main data change record data in the second change record table with the update time of the main data to be shared of the database, and judging whether the update time is consistent; and if the updating time is not consistent or the main data change record data in the first change record table and the second change record table are not consistent, updating the corresponding new main data to the database in a database copying manner, and issuing the corresponding main data change record data to the cache of the target tax system through the message queue.
Optionally, the total score sharing module includes:
the time sequence judging submodule is used for calling the main data writing cache service, comparing first updating time of main data change record data in the cache with second updating time of main data change record data of a database of the target tax system, and judging the sequence of the first updating time and the second updating time;
the first cache writing submodule is used for not writing the main data to be shared into the cache when the first updating time is prior to the second updating time;
the second cache writing submodule is used for marking the state of the main data to be shared as available when the first updating time is equal to the second updating time, and writing the marked main data to be shared into the cache;
a third cache writing submodule, configured to mark the state of the to-be-shared main data as unavailable when the second update time is prior to the first update time, and write the marked to-be-shared main data into the cache;
and the queue fault alarm submodule is used for marking the state of the main data to be shared as unavailable, writing the marked main data to be shared into the cache and then sending message queue fault alarm information.
Optionally, the tax system includes a cache unified access service, and the total score sharing module includes:
the state judgment submodule is used for calling the cache unified access service, writing the main data change record data into the cache, detecting the state of the main data to be shared in the cache and judging whether the main data is available;
the clearing submodule is used for clearing the main data to be shared in the cache when the main data to be shared in the cache is in an available state;
and the state modification submodule is used for modifying the state of the main data to be shared in the cache to be available when the main data to be shared in the cache is in an unavailable state.
Optionally, the tax master data sharing system further includes a golden gate fault alarm module, configured to periodically obtain a third update time of the latest master data change record data in the cache; calculating the time difference value of the third updating time and the updating time of the corresponding main data of the target table in the database of the target tax system; judging the size between the time difference and a preset threshold value; and when the time difference is greater than the preset threshold, sending golden gate fault alarm information.
Optionally, the tax sharing system further includes a master data governance module, configured to obtain master data of the tax system; analyzing the main data of the tax system to obtain a main data quality definition standard; generating a main data verification rule and a main data correction rule according to the main data quality definition standard; calling the main data verification rule through a verification rule engine, detecting the main data to be detected, and obtaining a quality detection result; and calling the main data correction rule through a correction rule engine to correct the main data to be corrected.
A method for sharing tax owner data, which is applied to any one of the above tax owner data sharing systems, the method comprising:
the transverse sharing module copies the main data of the legal person produced by the core personal tax system to the personal tax system by using a database copying mode, and shares the main data of the legal person to each subsystem in the personal tax system through the sharing service; copying the natural person master data produced by the personal tax system to the tax payment service platform through the sharing service and a database copying mode, and issuing a master data interface to the core personal tax system through the sharing service;
the general tax sharing module synchronizes the main data to be shared of the general tax system to a database of a target sub-tax system in a database replication mode; calling the main data updating record unified distribution service, and issuing main data change record data to the cache of the target tax system through a message queue; and calling the main data write cache service to write the main data to be shared in the database into the cache.
Optionally, after the writing the to-be-shared main data in the database into the cache, the method further includes:
the account checking module calls an account checking service of the target branch tax system, compares a first change record table of the main data change record data stored by the main tax system with a second change record table of the main data change record data stored by the target tax system, and judges whether the main data change record data in the first change record table and the second change record table are consistent;
if the main data change record data in the first change record table and the second change record table are consistent, comparing the update time of the main data change record data in the second change record table with the update time of the main data to be shared of the database, and judging whether the update time is consistent;
and if the updating time is not consistent or the main data change record data in the first change record table and the second change record table are not consistent, updating the corresponding new main data to the database in a database copying manner, and issuing the corresponding main data change record data to the cache of the target tax system through the message queue.
Optionally, the invoking a main data write cache service of the target tax sharing system, and writing the main data to be shared in the database into the cache includes:
calling the main data write cache service, comparing first updating time of main data change record data in the cache with second updating time of main data to be shared of a database of the target tax system, and judging the sequence of the first updating time and the second updating time;
when the first updating time is prior to the second updating time, the main data to be shared is not written into the cache;
when the first updating time is equal to the second updating time, marking the state of the main data to be shared as available, and writing the marked main data to be shared into the cache;
when the second updating time is prior to the first updating time, the state of the main data to be shared is marked as unavailable, and the marked main data to be shared is written into the cache.
Optionally, after the writing the to-be-shared main data in the database into the cache, the method further includes:
regularly acquiring third updating time of the latest main data change record data in the cache;
calculating the time difference value of the first updating time and the updating time of the corresponding main data of the target table in the database of the target tax system;
judging the size between the time difference and a preset threshold value; and when the time difference is greater than the preset threshold, sending golden gate fault alarm information.
The invention provides a personal tax owner data sharing system and a method, wherein a transverse sharing module of the system copies the main data of a legal person produced by a core personal tax system to the personal tax system by using a database copying mode, and shares the main data of the legal person to each subsystem in the personal tax system through a sharing service; copying the main data of the natural person produced by the personal tax system to a tax payment service platform in a sharing service and database copying mode, and issuing a main data interface to the core personal tax system through the sharing service; the general tax sharing module synchronizes main data to be shared of the general tax system to a database of a target sub-tax system in a database copying mode; calling a main data updating record unified distribution service, and issuing main data change record data to a cache of a target tax system through a message queue; and calling a main data write cache service, and writing the main data to be shared in the database into a cache.
Thus, the personal tax system, the core personal tax system and the tax payment service platform are realized through the sharing service and the database replication mode, and the real-time sharing of the main data among all subsystems in the personal tax system is realized, namely, the transverse sharing real-time performance of the personal tax main data is ensured by utilizing the sharing service and the database replication mode; the message queue is used for issuing the main data change record data, and the main data object is synchronized in a database copying mode, namely, the sharing instantaneity of the individual tax main data between the total tax system and the tax branch system is ensured in the message queue and database copying mode. Compared with the existing method for sharing the personal tax owner data, the method is higher in real-time performance.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
FIG. 1 is a block diagram illustrating the structure of a personal tax owner data sharing system according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of horizontal sharing of tax owner data according to an embodiment of the invention;
FIG. 3 is a diagram illustrating the sharing of native human master data between the head office and the tax system of province A according to an embodiment of the present invention;
fig. 4 is a flowchart illustrating a method for sharing personal tax owner data according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, fig. 1 is a schematic block diagram of a structure of a tax master data sharing system according to an embodiment of the present invention, applied to a tax system, where the tax system includes a total tax system and a plurality of sub-tax systems, and the total tax system is connected to each sub-tax system through a wide area network; the total tax system is provided with a main data updating record unified distribution service and a main data writing cache service; the general tax system comprises a personal tax system, a core personal tax system and a tax payment service platform, wherein the personal tax system, the core personal tax system and the tax payment service platform are connected through a local area network, and the personal tax system is provided with a sharing service; the system may include:
the transverse sharing module 11 is used for copying the main data of the legal person produced by the core individual tax system to the individual tax system by using a database copying mode, and sharing the main data of the legal person to each subsystem in the individual tax system through a sharing service; copying the main data of the natural person produced by the personal tax system to a tax payment service platform in a sharing service and database copying mode, and issuing a main data interface to the core personal tax system through the sharing service;
the total sharing module 12 is used for synchronizing the main data to be shared of the total tax system to the database of the target tax system in a database replication mode; calling a main data updating record unified distribution service, and issuing main data change record data to a cache of a target tax system through a message queue; and calling a main data write cache service, and writing the main data to be shared in the database into a cache.
It can be understood that the tax system may be embodied as a tax system of the third tax period of the gold tax, the general tax system may be embodied as a general office tax system, and each sub-tax system may be a tax system of each province. The systems of the head office tax system are connected through a local area network, namely in the same network segment. The general office tax system and the tax systems of all provinces are connected through a wide area network, namely the general office tax system and the tax systems of all provinces are in different network segments.
The core personal tax system is a tax system for generating main data of a legal person, which generally has a database for storing the main data of the legal person, and the main data of the legal person can specifically include basic information of the taxpayer (such as taxpayer identification number, taxpayer name, registration type and the like), taxpayer tax type registration information, taxpayer tax bank silver related information, monthly declaration information, basic state information of the taxpayer and the like.
The personal tax system generates natural person master data which may include, but is not limited to, basic registration information of natural persons, basic status information of natural persons, information of taxes paid by the declared years of natural persons, and the like. The individual tax system comprises a plurality of subsystems, particularly but not limited to a taxpayer management subsystem, a legal declaration collection subsystem, a natural person declaration collection subsystem, an evaluation auditing subsystem and the like.
It should be noted that, in this embodiment, a horizontal sharing module and a total sharing module are provided, where the horizontal sharing module mainly implements the individual tax system, the core individual tax system and the tax payment service platform, and shares the individual tax owner data among the subsystems in the individual tax system, and the total sharing module mainly implements the individual tax owner data sharing between the total tax system and the tax payment system.
First, a process of horizontally sharing the individual tax master data by the general tax system will be described. Referring to a schematic diagram of horizontal sharing of personal tax master data shown in fig. 2, a personal tax system is provided with a personal tax core processing platform, the personal tax core processing platform is provided with a sharing service, and the sharing service is respectively connected with subsystems of taxpayer management, legal declaration and collection, natural person declaration and collection, certification, evaluation and audit and the like, and each subsystem is provided with a corresponding database, for example, the taxpayer management subsystem is provided with a corresponding taxpayer management library, and the legal declaration and collection subsystem is provided with a corresponding legal declaration and collection library. The personal tax system is provided with a database for storing natural person master data and a database for storing legal person master data.
The core personal tax system is a producer of main data of a legal person, the golden gate copies the main data of the legal person to a database of the personal tax system for storing the main data of the legal person in a database copying mode, and then the personal tax system accesses the corresponding database through a sharing service to finish the consumption of the main data of the legal person.
The personal tax system is a producer of the main data of the natural person, copies the produced main data of the natural person into a database of a tax payment service platform in a golden gate mode, and provides an inquiry and update interface of the main data of the natural person through a sharing service so as to finish the consumption of the main data of the natural person.
In the transverse sharing of the personal tax master data in the general tax system, the synchronization instantaneity of the personal tax master data among the systems is ensured mainly through a sharing service.
Next, description is made of the sharing of the tax master data between the total tax system and each of the sub-tax systems. After the total tax system responds to the corresponding service request, two main data types of the tax main data and the main data change record data are generated. The two kinds of main data need to be shared in real time to a target tax sharing system consuming the two kinds of main data, and the sharing real-time performance needs to be guaranteed.
And after the business operation is successful, the total score sharing module correspondingly updates the corresponding main data of the total tax system and updates the corresponding business data table. The part of main data is specifically copied to a database of the target tax scoring system for storing the main data in a golden gate mode. And then, writing the main data in the database of the target tax separating system into a cache by using the main data writing cache service of the target tax separating system, and waiting for the application program of the target tax separating system to read the main data in the cache.
The main data change record data can be but is limited to data such as an electronic file number, a main data type, latest change time and the like, and the main data is transmitted to a cache of the target tax sharing system by calling a main data update record unified distribution service and utilizing a message queue.
In order to ensure the consistency and accuracy of the main data, the judgment of time sequence can be carried out. Therefore, in this embodiment, the total score sharing module may include: the time sequence judging submodule is used for calling a main data writing cache service, comparing first updating time of main data change record data in a cache with second updating time of main data change record data of a database of a target tax system, and judging the sequence of the first updating time and the second updating time; the first cache writing submodule is used for not writing the main data to be shared into the cache when the first updating time is prior to the second updating time; the second cache writing submodule is used for marking the state of the main data to be shared as available when the first updating time is equal to the second updating time, and writing the marked main data to be shared into the cache; the third cache writing submodule is used for marking the state of the main data to be shared as unavailable when the second updating time is prior to the first updating time, and writing the marked main data to be shared into the cache; and the queue fault alarm submodule is used for marking the state of the main data to be shared as unavailable, writing the marked main data to be shared into a cache and then sending message queue fault alarm information.
It is to be understood that the first update time and the second update time refer to data update times recorded within the arrival buffer and the main data change record data in the database.
By comparing the update time of the main data change record data with the update time of the main data, when the main data change record data arrives earlier than the main data, namely the first update time is earlier than the second update time, at this time, the corresponding main data is not written into the cache; when the time of the main data change record data is consistent with the time of the main data, namely the first updating time is equal to the second updating time, the state of the main data is marked as available and is written into a cache; when the main data change record data arrives later than the main data, namely the second updating time is earlier than the first updating time, at the moment, the message queue is known to have a fault, so that the issuing time is over, and besides the main data is marked as unavailable and is correspondingly written into the cache, queue fault alarm information can be sent out.
In addition, in order to ensure the accuracy of main data transmission, corresponding golden gate monitoring can be set. In this embodiment, the tax master data sharing system may further include a golden gate fault alarm module, configured to periodically obtain a first update time of the latest master data change record data in the cache; calculating the time difference value of the first updating time and the updating time of the corresponding main data of the target table in the database of the target tax system; judging the size between the time difference and a preset threshold value; and when the time difference is greater than a preset threshold value, sending golden gate fault alarm information.
The main data updating record uniform distribution service comprises an asynchronous component uniform access service, an asynchronous service processing component, a main data command distribution service and a main data updating record uniform distribution channel, wherein the asynchronous service processing component comprises a uniform command queue and a plurality of distribution queues, and specifically can be a uniform command queue and 36 provincial main data distribution queues. Specifically, the main data change record data is distributed to a queue of the target tax system, and then the corresponding main data change record data is sent to a cache of the target tax system through the queue.
When the main data updating record data reaches the target tax system, the main data updating record data can be written into the cache by using the cache unified cache access service.
Therefore, in this embodiment, the tax system includes a cache unified access service, and the total score sharing module may include: the state judgment submodule is used for calling the cache unified access service, writing the main data change record data into the cache, detecting the state of the main data to be shared in the cache and judging whether the main data is available; the clearing submodule is used for clearing the main data to be shared in the cache when the main data to be shared in the cache is in an available state; and the state modification submodule is used for modifying the state of the main data to be shared in the cache to be available when the main data to be shared in the cache is in an unavailable state.
In order to ensure the consistency and the accuracy of the personal tax master data between the total tax system and the target sub-tax system, the consistency of the shared personal tax master data between the total tax system and the target sub-tax system can be judged by comparing. Therefore, in this embodiment, the tax separating system may further include an account checking service, and the tax owner data sharing system may further include: the account checking module is used for calling account checking service, comparing a first change record table of main data change record data stored in the main tax system with a second change record table of main data change record data stored in the target tax system, and judging whether the main data change record data in the first change record table and the second change record table are consistent; if the main data change record data in the first change record table and the second change record table are consistent, comparing the update time of the main data change record data in the second change record table with the update time of the main data to be shared in the database, and judging whether the main data change record data are consistent; and if the updating time is not consistent or the main data change record data in the first change record table and the second change record table are not consistent, updating the corresponding new main data to the database in a database copying mode, and issuing the corresponding main data change record data to the cache of the target tax system through a message queue.
Further, the reconciliation operation between the total tax system and the target divided tax system may be timed, for example, reconciliation may be performed every other half day or every day, or may be non-timed.
To better explain the main data sharing process between the general tax system and the target tax separating system, reference may be made to the natural human main data sharing diagram between the general bureau and the province tax separating system A shown in FIG. 3.
As shown in FIG. 3, the head office is the primary data producer and the provincial tax system A is the primary data consumer. And after the central office generates a main data object and main data change record data, copying shared main data in a main database of natural people of the central office into a database of main data of natural people in province A by using a golden gate mode. And simultaneously, calling a main data updating record unified distribution service, sending main data change record data to a main data distribution queue of province A, then sending the main data change record data to a cache unified access service of province A through a main data record unified distribution MDB, and writing the main data change record data into a cache by the cache unified access service. And after the main data object reaches the database of the main data of the natural person in the province A, the corresponding main data object is written into the cache by calling the main data writing cache service. The cache unified access service then detects whether the status of the primary data object in the cache is available. In addition, the specific implementation process of the reconciliation service and the golden gate main data channel monitoring service in the graph can be referred to the corresponding content above.
To improve the quality of the primary data of the tax system, the revised primary data may be detected by defining quality definitions for the primary data and then passing these quality definitions. Therefore, in this embodiment, the tax sharing system may further include a master data governance module for acquiring master data of the tax system; analyzing the main data of the tax system to obtain a main data quality definition standard; generating a main data verification rule and a main data correction rule according to a main data quality definition standard; calling a main data verification rule through a verification rule engine, detecting main data to be detected, and obtaining a quality detection result; and calling a main data correction rule through a correction rule engine to correct the main data to be corrected.
It should be noted that quality definitions may include, but are not limited to, accuracy definitions, integrity definitions, representational definitions, and accessibility definitions. That is, the quality of the modified main data can be detected through the dimensions of the accuracy, the integrity, the representation, the accessibility and the like of the main data.
When the main data is corrected, the main data can be corrected automatically or manually, and when the main data is corrected manually, a manual correction interface is provided for realizing the manual correction.
In order to facilitate the analysis of the detection result and the correction result, corresponding information is obtained by analyzing the detection result and the correction result, and the correction result and the detection result can be stored, particularly in a log, so that the subsequent data analysis is facilitated.
In the embodiment, the personal tax system, the core personal tax system and the tax payment service platform are realized through a sharing service and database replication mode, and the real-time sharing of the main data among subsystems in the personal tax system is realized, namely, the transverse sharing real-time performance of the personal tax main data is ensured by utilizing the sharing service and the database replication mode; the message queue is used for issuing the main data change record data, and the main data object is synchronized in a database copying mode, namely, the sharing instantaneity of the individual tax main data between the total tax system and the tax branch system is ensured in the message queue and database copying mode. Compared with the existing method for sharing the personal tax owner data, the method is higher in real-time performance.
In the following, the method for sharing the personal tax owner data according to the embodiment of the present invention is introduced, and the method for sharing the personal tax owner data described below and the system for sharing the personal tax owner data described above may be referred to correspondingly.
Referring to fig. 4, fig. 4 is a schematic flow chart of a method for sharing personal tax owner data according to an embodiment of the present invention, where the method is applied to the personal tax owner data sharing system, and the method includes:
step 401, the transverse sharing module copies the main data of the legal person produced by the core individual tax system to the individual tax system by using a database copying mode, and shares the main data of the legal person to each subsystem in the individual tax system through a sharing service; copying the main data of the natural person produced by the personal tax system to a tax payment service platform in a sharing service and database copying mode, and issuing a main data interface to the core personal tax system through the sharing service;
step 402, synchronizing main data to be shared of the general tax system to a database of a target tax sharing system by a general tax sharing module in a database replication mode; calling a main data updating record unified distribution service, and issuing main data change record data to a cache of a target tax system through a message queue; and calling a main data write cache service, and writing the main data to be shared in the database into a cache.
In some possible embodiments, after writing the master data to be shared in the database into the cache, the method may further include:
the account checking module calls an account checking service of the target sub-tax system, compares a first change record table of main data change record data stored in the main tax system with a second change record table of main data change record data stored in the target tax system, and judges whether the main data change record data in the first change record table and the second change record table are consistent;
if the main data change record data in the first change record table and the second change record table are consistent, comparing the update time of the main data change record data in the second change record table with the update time of the main data to be shared in the database, and judging whether the main data change record data are consistent;
and if the updating time is not consistent or the main data change record data in the first change record table and the second change record table are not consistent, updating the corresponding new main data to the database in a database copying mode, and issuing the corresponding main data change record data to the cache of the target tax system through a message queue.
In some possible embodiments, the main data write cache service of the target tax sharing system is called, and the process of writing the main data to be shared in the database into the cache specifically includes:
calling a main data write cache service, comparing first updating time of main data change record data in cache with second updating time of main database change record data of a database of the target tax system, and judging the sequence of the first updating time and the second updating time;
when the first updating time is prior to the second updating time, the main data to be shared is not written into the cache;
when the first updating time is equal to the second updating time, the state of the main data to be shared is marked as available, and the marked main data to be shared is written into a cache;
and when the second updating time is prior to the first updating time, marking the state of the main data to be shared as unavailable, and writing the marked main data to be shared into the cache.
In some possible embodiments, after writing the master data to be shared in the database into the cache, the method may further include:
regularly acquiring first updating time of the latest main data change record data in the cache;
calculating the time difference value of the first updating time and the updating time of the corresponding main data of the target table in the database of the target tax system;
judging the size between the time difference and a preset threshold value; and when the time difference is greater than a preset threshold value, sending golden gate fault alarm information.
The method for sharing personal tax owner data provided by the embodiment has the same beneficial effects as the system for sharing personal tax owner data, and is not described herein again.
The embodiments are described in a progressive manner in the specification, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other. The device disclosed by the embodiment corresponds to the method disclosed by the embodiment, so that the description is simple, and the relevant points can be referred to the method part for description.
Those of skill would further appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both, and that the various illustrative components and steps have been described above generally in terms of their functionality in order to clearly illustrate this interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied directly in hardware, in a software module executed by a processor, or in a combination of the two. A software module may reside in Random Access Memory (RAM), memory, Read Only Memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.
The above description describes the system and method for sharing personal tax owner data provided by the present invention in detail. The principles and embodiments of the present invention are explained herein using specific examples, which are presented only to assist in understanding the method and its core concepts. It should be noted that, for those skilled in the art, it is possible to make various improvements and modifications to the present invention without departing from the principle of the present invention, and those improvements and modifications also fall within the scope of the claims of the present invention.

Claims (8)

1. A tax owner data sharing system is characterized in that the tax owner data sharing system is applied to a tax system, the tax system comprises a total tax system and a plurality of sub tax systems, and the total tax system is connected with the sub tax systems through a wide area network; the total tax system is provided with a main data updating record unified distribution service and a main data writing cache service; the general tax system comprises a personal tax system, a core personal tax system and a tax payment service platform, wherein the personal tax system, the core personal tax system and the tax payment service platform are connected through a local area network, and the personal tax system is provided with a sharing service; the system comprises:
the transverse sharing module is used for copying the main data of the legal person produced by the core individual tax system to the individual tax system by using a database copying mode and sharing the main data of the legal person to each subsystem in the individual tax system through the sharing service; copying the natural person master data produced by the personal tax system to the tax payment service platform through the sharing service and a database copying mode, and issuing a master data interface to the core personal tax system through the sharing service;
the total sharing module is used for synchronizing the main data to be shared of the total tax system to a database of a target tax system in a database replication mode; calling the main data updating record unified distribution service, and issuing main data change record data to the cache of the target tax system through a message queue; calling the main data write cache service, and writing the main data to be shared in the database into the cache;
wherein, the tax separating system also comprises an account checking service, and the tax owner data sharing system also comprises:
the account checking module is used for calling the account checking service, comparing a first change record table of the main data change record data stored by a total tax system with a second change record table of the main data change record data stored by a target tax system, and judging whether the main data change record data in the first change record table and the second change record table are consistent; if the main data change record data in the first change record table and the second change record table are consistent, comparing the update time of the main data change record data in the second change record table with the update time of the main data to be shared of the database, and judging whether the update time is consistent; and if the updating time is not consistent or the main data change record data in the first change record table and the second change record table are not consistent, updating the corresponding new main data to the database in a database copying manner, and issuing the corresponding main data change record data to the cache of the target tax system through the message queue.
2. The system of claim 1, wherein the score total sharing module comprises:
the time sequence judging submodule is used for calling the main data writing cache service, comparing first updating time of main data change record data in the cache with second updating time of main data change record data of a database of the target tax system, and judging the sequence of the first updating time and the second arrival updating;
the first cache writing submodule is used for not writing the main data to be shared into the cache when the first updating time is prior to the second updating time;
the second cache writing submodule is used for marking the state of the main data to be shared as available when the first updating time is equal to the second updating time, and writing the marked main data to be shared into the cache;
a third cache writing submodule, configured to mark the state of the to-be-shared main data as unavailable when the second update time is prior to the first update time, and write the marked to-be-shared main data into the cache;
and the queue fault alarm submodule is used for marking the state of the main data to be shared as unavailable, writing the marked main data to be shared into the cache and then sending message queue fault alarm information.
3. The system of claim 1, wherein the tax system includes a cache unified access service, the total score sharing module comprising:
the state judgment submodule is used for calling the cache unified access service, writing the main data change record data into the cache, detecting the state of the main data to be shared in the cache and judging whether the main data is available;
the clearing submodule is used for clearing the main data to be shared in the cache when the main data to be shared in the cache is in an available state;
and the state modification submodule is used for modifying the state of the main data to be shared in the cache to be available when the main data to be shared in the cache is in an unavailable state.
4. The system according to any one of claims 1 to 3, wherein the tax master data sharing system further comprises a golden gate fault alarm module for periodically acquiring a third update time of the latest master data change record data in the cache; calculating the time difference value of the third updating time and the updating time of the corresponding main data of the target table in the database of the target tax system; judging the size between the time difference and a preset threshold value; and when the time difference is greater than the preset threshold, sending golden gate fault alarm information.
5. The system of claim 4, wherein the tax sharing system further comprises a master data governance module for obtaining master data of the tax system; analyzing the main data of the tax system to obtain a main data quality definition standard; generating a main data verification rule and a main data correction rule according to the main data quality definition standard; calling the main data verification rule through a verification rule engine, detecting the main data to be detected, and obtaining a quality detection result; and calling the main data correction rule through a correction rule engine to correct the main data to be corrected.
6. A method for sharing tax owner data, which is applied to the tax owner data sharing system according to any one of claims 1 to 5, the method comprising:
the transverse sharing module copies the main data of the legal person produced by the core personal tax system to the personal tax system by using a database copying mode, and shares the main data of the legal person to each subsystem in the personal tax system through the sharing service; copying the natural person master data produced by the personal tax system to the tax payment service platform through the sharing service and a database copying mode, and issuing a master data interface to the core personal tax system through the sharing service;
the general tax sharing module synchronizes the main data to be shared of the general tax system to a database of a target sub-tax system in a database replication mode; calling the main data updating record unified distribution service, and issuing main data change record data to the cache of the target tax system through a message queue; calling the main data write cache service, and writing the main data to be shared in the database into the cache;
the account checking module calls the account checking service, compares a first change record table of the main data change record data stored by a total tax system with a second change record table of the main data change record data stored by a target tax system, and judges whether the main data change record data in the first change record table and the second change record table are consistent; if the main data change record data in the first change record table and the second change record table are consistent, comparing the update time of the main data change record data in the second change record table with the update time of the main data to be shared of the database, and judging whether the update time is consistent; and if the updating time is not consistent or the main data change record data in the first change record table and the second change record table are not consistent, updating the corresponding new main data to the database in a database copying manner, and issuing the corresponding main data change record data to the cache of the target tax system through the message queue.
7. The method of claim 6, wherein the invoking a primary data write cache service of the target tax sharing system to write the primary data to be shared in the database to the cache comprises:
calling the main data write cache service, comparing first updating time of main data change record data in the cache with second updating time of main data change record data of a database of the target tax system, and judging the sequence of the first updating time and the second updating time;
when the first updating time is prior to the second updating time, the main data to be shared is not written into the cache;
when the first updating time is equal to the second updating time, marking the state of the main data to be shared as available, and writing the marked main data to be shared into the cache;
when the second updating time is prior to the first updating time, the state of the main data to be shared is marked as unavailable, and the marked main data to be shared is written into the cache.
8. The method of claim 6 or 7, wherein after the writing the master data to be shared in the database to the cache, further comprising:
regularly acquiring third updating time of the latest main data change record data in the cache;
calculating the time difference value of the third updating time and the updating time of the corresponding main data of the target table in the database of the target tax system;
judging the size between the time difference and a preset threshold value; and when the time difference is greater than the preset threshold, sending golden gate fault alarm information.
CN201711202107.4A 2017-11-24 2017-11-24 Individual tax owner data sharing method and system Active CN107943958B (en)

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 CN107943958A (en) 2018-04-20
CN107943958B true 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)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109241072A (en) * 2018-08-31 2019-01-18 携程计算机技术(上海)有限公司 Buffering updating method and system based on Canal
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

Family Cites Families (5)

* Cited by examiner, † Cited by third party
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
CN105574158B (en) * 2015-12-15 2019-03-12 广州品唯软件有限公司 The method for refreshing and its system of database caches 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

Also Published As

Publication number Publication date
CN107943958A (en) 2018-04-20

Similar Documents

Publication Publication Date Title
US10657607B2 (en) Implementation of payroll smart contract on a distributed ledger
WO2020082579A1 (en) Risk review and approval method, device, storage medium, and server
US10255108B2 (en) Parallel execution of blockchain transactions
CA2978488C (en) Systems and methods for managing data
US9965364B2 (en) Fault tolerant listener registration in the presence of node crashes in a data grid
CN107943958B (en) Individual tax owner data sharing method and system
AU2018206822A1 (en) Simplified tax interview
JP2019008791A (en) Smart contract life cycle management
US10832217B2 (en) Blockchain-based workflow system
DE112012005037T5 (en) Manage redundant immutable files using deduplications in storage clouds
CN113094434A (en) Database synchronization method, system, device, electronic equipment and medium
CN110321339A (en) A kind of data migration method, device, equipment and storage medium
US11750619B2 (en) Modify assigned privilege levels and limit access to resources
CN106021566A (en) Method, device and system for improving concurrent processing capacity of single database
Williams et al. Discrete-event simulation modeling of critical care flow: New hospital, old challenges
CN109558409A (en) Data processing method and device
US11816163B2 (en) Systems and methods for improved transactional mainframes
CN113342834A (en) Method for solving historical data change in big data system
CN115329011A (en) Data model construction method, data query method, data model construction device and data query device, and storage medium
US20220222752A1 (en) Methods for analyzing insurance data and devices thereof
CN109360102A (en) Stock exchange data processing method, device, computer equipment and storage medium
CN112035458B (en) Data isolation method, device and equipment
CN111444212A (en) Unified accounting method and device based on accounting system and accounting system
CN111274255A (en) Service data monitoring method and system, monitoring architecture, equipment and storage medium
CN114372111A (en) Service data uploading method and device, computer equipment and storage medium

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