Method and device for solving data association failure

Abstract

The invention discloses a method and a device for solving data association failure, and relates to the technical field of electronic government data government. Comprising the following steps of: 1, establishing a redundant coding system compatible with standard 12-bit administrative division codes by using a UUIDv4 format, establishing a dynamic mapping relationship between the redundant codes and standard codes according to requirements, and distributing administrative division codes and unique and unchanged redundant codes for each administrative division; the method comprises the following steps: step 1, providing four types of standard operations of adding, changing, cancelling or merging, step 2, performing data publishing by using two channels of REST API and a message queue: notifying the latest administrative division code, the redundant code and the dynamic mapping relationship, and performing real-time synchronization of cross-system data association; according to the method, by establishing a redundant coding system and a dynamic synchronization mechanism, continuous traceability of historical data after zoning change is ensured, and normal operation of an existing service system is maintained at the same time.

Description

Technical Field

[0001] The present invention discloses a solution and device for data association failure, and relates to the technical field of e-government data governance. Background Art

[0002] Current government systems generally use a 12-digit administrative division coding system. The fact that this code changes with administrative adjustments can easily lead to problems. For example, when a division is split, merged, or revoked, the data association corresponding to the original code becomes permanently invalid. Some existing systems attempt to address this issue by establishing temporary mapping tables, but this fails to fully trace change records and lacks a standardized cross-system synchronization mechanism, making it difficult to ensure data consistency across different government systems. Existing methods, in particular, can break data association chains when dealing with nested changes to multiple levels of divisions, seriously impacting the accuracy of key operations such as statistics. Summary of the Invention

[0003] This invention addresses the challenges of existing technologies by providing a solution and device for data association failure, resolving the data association failure issues that arise in government information systems during administrative division adjustments. The device is suitable for multi-department collaborative systems that handle administrative division changes, such as those for civil administration, demographics, and social security. By establishing a redundant coding system and dynamic synchronization mechanism, it ensures the continuous traceability of historical data after division changes while maintaining the normal operation of existing business systems.

[0004] The specific scheme proposed by the present invention is: The present invention provides a solution to data association failure, including: Step 1: Use the UUIDv4 format to establish a redundant coding system that is compatible with the standard 12-bit administrative division code. Establish a dynamic mapping relationship between redundant codes and standard codes based on demand, assign an administrative division code and a unique and unchanging redundant code to each administrative division to ensure the traceability of historical data. Step 2: Provide an automated administrative division processing flow, offering four standard operations: add, change, cancel, or merge. The add operation refers to generating a new 12-digit administrative division code and redundant code; the change operation refers to retaining the original redundant code to generate a new 12-digit administrative division code; the cancel operation refers to associating with a valid administrative division code and the corresponding redundant code and marking the historical status; the merge operation refers to performing a combination of add and cancel operations; Step 3: Use REST API and message queue dual channels to publish data: notify the latest administrative division codes and redundant codes, as well as dynamic mapping relationships, to achieve real-time synchronization of cross-system data associations.

[0005] Furthermore, in step 1 of the solution to data association failure, an administrative division code and a unique and unchanging redundant code are assigned to each administrative division, including: assigning a variable 12-bit standard administrative division code, and assigning an unchanging redundant code of a preset number of bits in the UUIDv4 format.

[0006] Furthermore, the entire change processing flow involved in step 2 of the aforementioned solution to data association failure is: making changes according to the operation type coding processing rules, wherein the operation type coding processing rules are to generate a new 12-bit standard code + a new redundant code, change to generate a new 12-bit code + inherit the original redundant code to cancel the marked historical status, and associate the existing code.

[0007] Furthermore, in step 2 of the solution to data association failure, administrative division change events are monitored. The change events include: Original standard code and redundant code, New standard coding and redundancy code, Change timestamp and operation type.

[0008] The present invention also provides a device for solving data association failure, including a zoning code management module, a dynamic processing engine module and a data publishing module. The district code management module uses the UUIDv4 format to establish a redundant coding system that is compatible with the standard 12-bit administrative district code. It establishes a dynamic mapping relationship between redundant codes and standard codes based on demand, and assigns an administrative district code and a unique and unchanged redundant code to each administrative district to ensure the traceability of historical data. The dynamic processing engine module provides an automated administrative division processing flow, offering four standard operations: add, change, cancel, or merge. The add operation refers to generating a new 12-digit administrative division code and redundant code; the change operation refers to retaining the original redundant code to generate a new 12-digit administrative division code; the cancel operation refers to associating with the valid administrative division code and the corresponding redundant code and marking the historical status; the merge operation refers to performing a combination of add + cancel operations; The data publishing module uses REST API and message queue dual channels to publish data: notifying the latest administrative division codes and redundant codes, as well as dynamic mapping relationships, to achieve real-time synchronization of cross-system data associations.

[0009] Furthermore, the district code management module of the device for solving data association failure assigns an administrative district code and a unique and unchanging redundant code to each administrative district, including: assigning a variable 12-bit standard administrative district code, and assigning an unchanging redundant code of a preset number of bits in the UUIDv4 format.

[0010] Furthermore, the dynamic processing engine module of the device for solving data association failure involves the entire change processing flow, and changes are made according to the operation type coding processing rules, wherein the operation type coding processing rules are to generate a new 12-bit standard code + a new redundant code, change to generate a new 12-bit code + inherit the original redundant code to cancel the marked historical status, and associate the existing code.

[0011] Furthermore, the dynamic processing engine module of the device for resolving data association failure monitors administrative division change events, and the change events include: Original standard code and redundant code, New standard coding and redundancy code, Change timestamp and operation type.

[0012] The benefits of the present invention are: Achieve data association stability: Through a dual mapping mechanism of redundant coding and 12-bit standard coding, the historical data association relationship is ensured to remain unchanged after district changes, solving the common "data disconnection" problem in government systems. Achieve system compatibility: Dynamic updates are achieved while maintaining standard compatibility, and existing systems can be integrated into the new coding system without modification: Improved operation and maintenance efficiency: Automated processing of zoning change events reduces the operation and maintenance workload by more than 90% compared to manual maintenance of mapping tables. Achieve cross-system consistency: Adopt a dual-channel synchronization mechanism (REST API + message queue) to ensure that data update delays between different government systems are controlled at the millisecond level. BRIEF DESCRIPTION OF THE DRAWINGS

[0013] Figure 1 It is a schematic flow chart of the method of the present invention. DETAILED DESCRIPTION

[0014] The present invention will be further described below with reference to the accompanying drawings and specific embodiments so that those skilled in the art can better understand the present invention and implement it. However, the embodiments are not intended to limit the present invention.

[0015] Embodiment 1: The present invention provides a solution to data association failure, including: Step 1: Use the UUIDv4 format to establish a redundant coding system compatible with the standard 12-digit administrative division code. A dynamic mapping relationship between the redundant code and the standard code is established as needed. Each administrative division is assigned an administrative division code and a unique, unchanging redundant code to ensure the traceability of historical data. The allocation of an administrative division code and a unique, unchanging redundant code to each administrative division may include: assigning a variable 12-digit standard administrative division code and assigning an unchanging redundant code of a preset number of bits in the UUIDv4 format.

[0016] Step 2: Provides an automated administrative division processing flow, offering four standard operations: add, change, cancel, or merge. Add refers to generating a new 12-digit administrative division code and redundant code; change refers to retaining the original redundant code and generating a new 12-digit administrative division code; cancel refers to associating a valid administrative division code and corresponding redundant code and marking the historical status; and merge refers to performing a combined add and cancel operation. Administrative division change events are monitored, including the original standard code and redundant code, the new standard code and redundant code, the change timestamp, and the operation type.

[0017] For example, when adding a new operation, the civil affairs system enters the administrative division information of the newly established "X New District". Management side execution: Generates a standard 12-bit code such as 371203, assigns a 32-bit redundant code in UUIDv4 format: 3d4fe...8a2b, records the operation timestamp and operator information, Push events to statistics and other systems through the message queue: { "event_type": "New", "new_code": "370102102000", "new_redundant_code": "3d4fe...8a2b", "new_name": "XX Town", "effective_date": "2025-06-01" } The entire change processing process involves the following: change according to the operation type coding processing rules, where the operation type coding processing rules are to generate a new 12-digit standard code + a new redundant code for new additions, to generate a new 12-digit code + inherit the original redundant code, to cancel the historical status mark, and to associate the existing code. For example, the original A County code 130121 and B County code 130122 are merged into the new C City code 130181. The management side then executes: generate a new standard code + redundant code for City C, and mark the original two county codes as historical status. Establish the mapping relationship of 130121→130181 and 130122→130181. The data end is synchronized: the original A / B county data keeps the original redundant code unchanged and is automatically associated with the new standard code of C city to achieve data inheritance.

[0018] Step 3: Use REST API and message queue dual channels to publish data: notify the latest administrative division codes and redundant codes, as well as dynamic mapping relationships, to achieve real-time synchronization of cross-system data associations.

[0019] Embodiment 2: The present invention also provides a device for solving data association failure, comprising a zone code management module, a dynamic processing engine module and a data publishing module. The district code management module uses the UUIDv4 format to establish a redundant coding system that is compatible with the standard 12-bit administrative district code. It establishes a dynamic mapping relationship between redundant codes and standard codes based on demand, and assigns an administrative district code and a unique and unchanged redundant code to each administrative district to ensure the traceability of historical data. The dynamic processing engine module provides an automated administrative division processing flow, offering four standard operations: add, change, cancel, or merge. The add operation refers to generating a new 12-digit administrative division code and redundant code; the change operation refers to retaining the original redundant code to generate a new 12-digit administrative division code; the cancel operation refers to associating with the valid administrative division code and the corresponding redundant code and marking the historical status; the merge operation refers to performing a combination of add + cancel operations; The data publishing module uses REST API and message queue dual channels to publish data: notifying the latest administrative division codes and redundant codes, as well as dynamic mapping relationships, to achieve real-time synchronization of cross-system data associations.

[0020] Since the information interaction, execution process and other contents between the modules in the above-mentioned device are based on the same concept as the embodiment of the method of the present invention, the specific contents can be found in the description of the embodiment of the method of the present invention and will not be repeated here.

[0021] Likewise, the benefits of the device of the present invention are: Achieve data association stability: Through a dual mapping mechanism of redundant coding and 12-bit standard coding, the historical data association relationship is ensured to remain unchanged after district changes, solving the common "data disconnection" problem in government systems. Achieve system compatibility: Dynamic updates are achieved while maintaining standard compatibility, and existing systems can be integrated into the new coding system without modification: Improved operation and maintenance efficiency: Automated processing of zoning change events reduces the operation and maintenance workload by more than 90% compared to manual maintenance of mapping tables. Achieve cross-system consistency: Adopt a dual-channel synchronization mechanism (REST API + message queue) to ensure that data update delays between different government systems are controlled at the millisecond level.

[0022] It should be noted that not all steps and modules in the above-mentioned processes and device structures are required, and certain steps or modules can be omitted according to actual needs. The execution order of each step is not fixed and can be adjusted as needed. The system structure described in the above-mentioned embodiments can be a physical structure or a logical structure, that is, some modules may be implemented by the same physical entity, or some modules may be implemented by multiple physical entities, or may be implemented by certain components in multiple independent devices.

[0023] The above embodiments are merely preferred embodiments for the purpose of fully illustrating the present invention, and the scope of protection of the present invention is not limited thereto. Equivalent substitutions or modifications made by those skilled in the art based on the present invention are within the scope of protection of the present invention. The scope of protection of the present invention shall be subject to the claims.

Claims

1. A solution to data association failure, characterized by include: Step 1: Use the UUIDv4 format to establish a redundant coding system that is compatible with the standard 12-bit administrative division code. Establish a dynamic mapping relationship between redundant codes and standard codes based on demand, assign an administrative division code and a unique and unchanging redundant code to each administrative division to ensure the traceability of historical data. Step 2: Provide an automated administrative division processing flow, offering four standard operations: add, change, cancel, or merge. The add operation refers to generating a new 12-digit administrative division code and redundant code; the change operation refers to retaining the original redundant code to generate a new 12-digit administrative division code; the cancel operation refers to associating with a valid administrative division code and the corresponding redundant code and marking the historical status; the merge operation refers to performing a combination of add and cancel operations; Step 3: Use REST API and message queue dual channels to publish data: notify the latest administrative division codes and redundant codes, as well as dynamic mapping relationships, to achieve real-time synchronization of cross-system data associations.

2. The data association failure solution according to claim 1, wherein the step of assigning an administrative division code and a unique, unchanged redundant code to each administrative division in step 1 comprises: Assign a variable 12-bit standard administrative division code and an unchanging redundant code of a preset number of bits in the UUIDv4 format.

3. A solution to data association failure according to claim 1, characterized in that The entire change processing flow involved in step 2 is: make changes according to the operation type coding processing rules, where the operation type coding processing rules are to generate a new 12-digit standard code + a new redundant code for new additions, to generate a new 12-digit code + inherit the original redundant code, unmark the historical status, and associate the existing code.

4. The data association failure solution according to claim 1, wherein the monitoring of administrative division change events in step 2 includes: Original standard code and redundant code, New standard coding and redundancy code, Change timestamp and operation type.

5. A device for solving data association failure, characterized by Including zoning code management module, dynamic processing engine module and data publishing module, The district code management module uses the UUIDv4 format to establish a redundant coding system that is compatible with the standard 12-bit administrative district code. It establishes a dynamic mapping relationship between redundant codes and standard codes based on demand, and assigns an administrative district code and a unique and unchanged redundant code to each administrative district to ensure the traceability of historical data. The dynamic processing engine module provides an automated administrative division processing flow, offering four standard operations: add, change, cancel, or merge. The add operation refers to generating a new 12-digit administrative division code and redundant code; the change operation refers to retaining the original redundant code to generate a new 12-digit administrative division code; the cancel operation refers to associating with the valid administrative division code and the corresponding redundant code and marking the historical status; the merge operation refers to performing a combination of add + cancel operations; The data publishing module uses REST API and message queue dual channels to publish data: notifying the latest administrative division codes and redundant codes, as well as dynamic mapping relationships, to achieve real-time synchronization of cross-system data associations.

6. The device for solving data association failure according to claim 5, characterized in that Zoning code The management module allocates an administrative division code and a unique and unchanged redundant code to each administrative division, including: allocating a variable 12-bit standard administrative division code, and allocating an unchanged redundant code with a preset number of bits in the UUIDv4 format.

7. The device for solving data association failure according to claim 5, characterized in that The dynamic processing engine module involves the entire change processing flow and makes changes according to the operation type coding processing rules. The operation type coding processing rules are to generate a new 12-digit standard code + a new redundant code for new additions, and to generate a new 12-digit code + inherit the original redundant code, unmark the historical status, and associate the existing code.

8. The device for solving data association failure according to claim 5, characterized in that The dynamic processing engine module monitors administrative division change events, which include: Original standard code and redundant code, New standard coding and redundancy code, Change timestamp and operation type.

Images