Data standard management method and device, computer equipment and storage medium
By determining the mapping set and obtaining target encoding in the put into operation system, the problem of difficulty in implementing data standards is solved, and the unity of cross-system data formats and the improvement of data extraction, fusion and analysis efficiency is achieved.
Patent Information
- Application Number
- CN202411726187.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-11-28
- Publication Date
- 2025-02-11
AI Technical Summary
The existing technology is difficult to implement data standards in systems that have been put into operation but have not been built in accordance with the data standards, resulting in inefficiency in cross-system data extraction, fusion and analysis.
By determining the mapping set based on the standard data standards and the source data standards of the source system, the target encoding is obtained under the coded value mapping requirements, and the set is analyzed based on the target encoding and mapping to determine the association of the target encoding. Map pair list, associated source system and code value association relationship.
The unified data formats across systems are achieved without the need to adopt unique standards, and the efficiency of cross-system data extraction, fusion and analysis is improved.
Smart Images
Figure CN119415739A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of computer equipment, and in particular to a data standard management method, device, computer equipment and storage medium. Background Art
[0002] Data standards are the main basis for data standardization. Building a complete data standard system is a good foundation for data management, which is conducive to the interoperability of the underlying data and improving the availability of data. In the digitalization of enterprises, a set of unified data standards for the entire system is usually established in the data standard management system. The newly created database table can directly bind the fields to the unique standard through the platform tools.
[0003] However, for most systems that have been put into operation but not built in accordance with the relevant provisions of data standards, it is difficult to implement data standards in these systems due to their early construction time and long operation time. In addition, from the perspective of standard codes, production systems often have standard codes that conform to their long-term usage habits. In order to improve the efficiency of cross-system data extraction, fusion, and analysis, a solution to unify the data format between multiple systems is urgently needed. Summary of the invention
[0004] Based on this, it is necessary to provide a data standard management method, device, computer equipment and storage medium to address the above-mentioned technical problems, so as to improve the efficiency of cross-system data extraction, fusion and analysis.
[0005] The present application provides a data standard management method, comprising: determining a mapping pair set according to a specification data standard and a source data standard of a source system; obtaining a target code when there is a code value mapping requirement; analyzing the target code and the mapping pair set to determine an associated mapping pair list of the target code; analyzing the associated mapping pair list to determine an associated source system of the target code, and a code value association relationship between the target code and the associated source system.
[0006] In one embodiment, the specification data standard is a regulatory data standard, and determining a mapping pair set based on the specification data standard and the source data standard of the source system includes: obtaining a data item source and a regulatory code of a regulatory data standard, and a system field source and a standard code of the source data standard in a source system; associating and storing the data item source, the regulatory code, the system field source, and the standard code to obtain a mapping pair; and determining a mapping pair set by associating and storing the mapping pairs formed by the regulatory data standard and the source system.
[0007] In one of the embodiments, the analysis based on the target coding and the mapping pair set to determine the associated mapping pair list of the target coding includes: detecting whether the mapping pair set contains a mapping pair associated with the target coding; if an associated mapping pair exists, determining the associated mapping pair list of the target coding based on the associated mapping pair.
[0008] In one of the embodiments, the analysis based on the associated mapping pair list to determine the associated source end system of the target code and the code value association relationship between the target code and the associated source end system includes: taking the source end system corresponding to the mapping pair in the associated mapping pair list as the associated source end system of the target code; determining the regulatory code value associated with the target code according to the associated mapping pair list; determining a first key value set pair according to the target code and the regulatory code value; analyzing the mapping pair column associated with the regulatory code value according to the regulatory code value and the associated mapping pair list; determining a second key value set pair according to the standard code value associated with the regulatory code value in the mapping pair column; and integrating the first key value set pair and the second key value set pair to obtain the code value association relationship between the target code and the associated source end system.
[0009] In one of the embodiments, determining a first key-value set pair based on the target code and the regulatory code value includes: determining a first initial key-value set pair based on the target code; the first initial key-value set pair includes a first code value and a first linked list; inserting the regulatory code value into the linked list of the first initial key-value set pair to obtain a first key-value set pair.
[0010] In one embodiment, a second key value set pair is determined based on the standard code value associated with the regulatory code value in the mapping pair column, including: determining a second initial key value set pair based on the regulatory code value; the second initial key value set pair includes a second code value and a second linked list; and inserting the standard code value associated with the regulatory code value in the mapping pair column into the second linked list of the second initial key value set pair to obtain a second key value set pair.
[0011] In one of the embodiments, the method further includes: after obtaining the associated source end system of the target code and the code value association relationship, reviewing and signing for the associated source end system of the target code and the code value association relationship.
[0012] The present application provides a data standard management device, including: a mapping pair generation module, used to determine a mapping pair set according to a specification data standard and a source data standard of a source system; a code value mapping initiation module, used to obtain a target code when there is a code value mapping requirement; an association mapping analysis module, used to analyze the target code and the mapping pair set to determine an association mapping pair list of the target code; a code value relationship calculation module, used to analyze the association mapping pair list to determine an associated source system of the target code, and a code value association relationship between the target code and the associated source system.
[0013] The present application provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and the processor implements the steps of the above method when executing the computer program.
[0014] The present application provides a computer-readable storage medium having a computer program stored thereon, and the computer program implements the steps of the above method when executed by a processor.
[0015] The above-mentioned data standard management method, device, computer equipment and storage medium can determine the mapping pair set according to the standard data standard and the source data standard of the source system, and then obtain the target code when there is a code value mapping requirement, analyze the target code and the mapping pair set, and determine the associated mapping pair list of the target code; analyze the associated mapping pair list to determine the associated source system of the target code, and the code value association relationship between the target code and the associated source system. Through this scheme, the code of the source data standard in any source system can be used as the target code to perform code value management and analysis, find the associated source systems associated with it, and the code value association relationship between the target code and the associated source system. In this way, by associating two source systems with different data standards, the data format between the systems can be unified without adopting a unique standard, thereby improving the efficiency of cross-system data extraction, fusion and analysis. BRIEF DESCRIPTION OF THE DRAWINGS
[0016] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the related technologies, the drawings required for use in the embodiments or the related technical descriptions are briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.
[0017] FIG1 is a flow chart of a data standard management method in one embodiment of the present application;
[0018] FIG2 is a schematic diagram of a mapping pair set determination process in one embodiment of the present application;
[0019] FIG3 is a schematic diagram showing the relationship between standard coding and the system in one embodiment of the present application;
[0020] FIG4 is a schematic diagram of a mapping pair association relationship in one embodiment of the present application;
[0021] FIG5 is a flow chart of a data standard management method in another embodiment of the present application;
[0022] FIG6 is a schematic diagram of a code value correspondence analysis process in one embodiment of the present application;
[0023] FIG7 is a schematic diagram of a mapping example in one embodiment of the present application;
[0024] FIG8 is a schematic diagram of the structure of a first key-value set pair in one embodiment of the present application;
[0025] FIG9 is a schematic diagram of a second key-value set pair structure in one embodiment of the present application;
[0026] FIG10 is a flow chart of a data standard management method in another embodiment of the present application;
[0027] FIG11 is a schematic diagram of the structure of a data standard management device in one embodiment of the present application;
[0028] FIG. 12 is a schematic diagram of the internal structure of a computer device in one embodiment of the present application. DETAILED DESCRIPTION
[0029] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.
[0030] The data standard management method provided by this application is applied in scenarios where there are multiple different data standards between multiple systems and there are cross-system data processing requirements between multiple systems. For example, it can be applied in financial systems and insurance systems, without specific limitation. In order to facilitate understanding of the technical solution of this application, the following embodiment takes the financial insurance system as an example, which includes multiple supervision systems, and each supervision system can obtain business data from at least one source system to achieve supervision of the source system.
[0031] Please refer to FIG. 1 . The present application provides a data standard management method, including step 102 , step 104 , step 106 and step 108 .
[0032] Step 102, determining a mapping pair set according to the specification data standard and the source data standard of the source system.
[0033] Specifically, the normative data is the only normative standard that establishes the association relationship between various systems; the source system is the source system of the business data. The mapping pair set is the sum of the mapping pairs obtained by associating and mapping the normative data standard and the source data standard in pairs.
[0034] It should be noted that the types of normative data are not unique. In one embodiment, a data standard established in advance by a user may be used as the normative data standard, such as an enterprise-level data standard. In another embodiment, the regulatory standard of the regulatory system may also be used as the normative data standard, which is not specifically limited.
[0035] Data standards refer to a set of rules and specifications that are defined and established in a specific field to unify and standardize data collection, processing, management, storage and use. Data standards usually include encodings or codes, which refer to enumeration values and semantics in data standards. Most of the dimensions of data standards come from encodings or codes.
[0036] Step 104: if there is a code value mapping requirement, obtain the target code.
[0037] Specifically, the code value mapping requirement is the requirement to associate the encoding of a certain data standard with the encoding of other source data standards; code value mapping is to associate the code values representing the same requirement field values between different data standards, so as to achieve unified integration when the requirement field values are inconsistent. The target encoding is the encoding or code value of the data standard that needs to be analyzed and calculated for code value mapping, where the data standard can be any source data standard.
[0038] Step 106 analyzes the target code and the mapping pair set to determine a list of associated mapping pairs of the target code.
[0039] Specifically, the associated mapping pair list refers to a list consisting of mapping pairs with required field values represented by the target code. The solution of this embodiment associates the target code with each mapping pair through the required field values of each data standard.
[0040] Step 108: Analyze the list according to the association mapping to determine the associated source end system of the target code and the code value association relationship between the target code and the associated source end system.
[0041] Specifically, there are various data standards in the association mapping list that are the same as the required field value represented by the target code. You only need to find these data standards and obtain the associated source system of the target code based on the system to which the data standards belong. The code value association relationship refers to the corresponding relationship formed by various code values that are consistent with the required field value represented by the target code. The required field values represented by all code values in the code value association relationship are consistent. For example, in one embodiment, the target code is 01, and the required field value it represents is Beijing. In the code value association relationship, the code values associated with 01 are A, 1001, etc., and the required field values corresponding to these code values are also Beijing.
[0042] The above data standard management method can determine the mapping pair set according to the standard data standard and the source data standard of the source system, and then obtain the target code when there is a code value mapping requirement, analyze the target code and the mapping pair set, and determine the associated mapping pair list of the target code; analyze the associated mapping pair list to determine the associated source system of the target code, and the code value association relationship between the target code and the associated source system. Through this solution, the code of the source data standard in any source system can be used as the target code to perform code value management and analysis, find the associated source systems associated with it, and the code value association relationship between the target code and the associated source system. In this way, by associating two source systems with different data standards, the data format between the systems can be unified without adopting a unique standard, thereby improving the efficiency of cross-system data extraction, fusion, and analysis.
[0043] Please refer to FIG. 2 , in one embodiment, the specification data standard is a regulatory data standard, and step 102 includes step 202 , step 204 , and step 206 .
[0044] Step 202, obtaining a data item source and a supervision code of a supervision data standard, and a system field source and a standard code of a source data standard in a source system.
[0045] Step 204, the data item source, the supervision code, the system field source and the standard code are stored in association to obtain a mapping pair.
[0046] Step 206 , according to the supervision data standard and the source end system, the mapping pairs formed by the storage are associated with each other to determine a mapping pair set.
[0047] Specifically, this embodiment uses the supervision data standard as an example for explanation. From the perspective of data flow analysis, the data of the business system is the source of various upper-level supervision indicators. The data items in the supervision indicators need to be extracted from data of multiple source systems. When supervising and managing each source system, the standard code value mapping of the data items involved in each source system can be performed in parallel.
[0048] The system fields in the source system form a binding relationship with the standard code, and the data item sources in the supervision system form a binding relationship with the supervision code. For details, please refer to Figure 3, where AMIS, GMIS, and DGP are the source systems, and EAST is the supervision system. A one-to-one mapping pair is formed between the source system and the supervision system, as shown in Figure 4. With the direct correspondence between the code values between the mapping pairs, the indirect correspondence represented by the dotted line in Figure 4 can be obtained, so that the standard codes between the systems and the correspondence between the enumeration values in the standard codes are connected as shown in the following table. A [data item source, supervision code, system field source, standard code] is regarded as a mapping pair, and a set of multiple mapping pairs is regarded as a mapping pair set.
[0049]
[0050] It should be noted that the storage method of the mapping pair set is not unique. In one embodiment, the storage can be performed in the form of a database structure. For ease of understanding, taking the mapping pair 2 shown in FIG. 4 as an example, AMIS-T31-province-PROV_NO is respectively the system name, table name, field name, and the standard code bound to the field, which are stored in the source end coding source table, and EAST-T99-province-EAST_PROV_NO is respectively the regulatory system name, table name, field name, and the standard code bound to the field. This section of information is stored in the EAST coding source table, and the corresponding relationship between the code value in the standard code PROV_NO and EAST_PROV_NO "01-Beijing" corresponds to "1001-Beijing", and "02-Shanghai" corresponds to "1002-Shanghai" is stored in the code value mapping table.
[0051] Please refer to FIG. 5 , in one embodiment, step 106 includes step 502 and step 504 .
[0052] Step 502: Detect whether there is a mapping pair associated with the target code in the mapping pair set.
[0053] Step 504: If there is an associated mapping pair, determine an associated mapping pair list of the target code according to the associated mapping pair.
[0054] Specifically, the mapping pair associated with the target encoding refers to a mapping pair that has the same required field value as the target encoding. In the solution of this embodiment, when a mapping pair set is established, a mapping pair can be specified according to actual needs to initiate mapping, that is, a source data standard corresponding to a mapping pair can be specified as the target data standard, and the encoding of the target data standard can be used as the target encoding.
[0055] When performing code value mapping, firstly, an analysis is performed to determine whether there is an associated mapping pair. If so, the subsequent code value mapping operation is continued. If not, the analysis operation is terminated. In this way, the efficiency and accuracy of code value mapping analysis can be greatly improved.
[0056] Please refer to FIG. 6 , in one embodiment, step 108 includes step 601 , step 602 , step 603 , step 604 , step 605 and step 606 .
[0057] Step 601: Use the source end system corresponding to the mapping pair in the associated mapping pair list as the associated source end system of the target code.
[0058] Step 602: Determine the supervision code value associated with the target code according to the association mapping pair list.
[0059] Step 603: Determine a first key-value set pair according to the target code and the supervision code value.
[0060] Step 604: Analyze the list of regulatory code values and associated mapping pairs to determine the mapping pair list associated with the regulatory code value.
[0061] Step 605: Determine a second key-value set pair according to the standard code value associated with the supervision code value in the mapping pair column.
[0062] Step 606: Integrate the first key-value set pair and the second key-value set pair to obtain a code value association relationship between the target code and the associated source system.
[0063] Specifically, a key-value set pair is a common data structure in which each element is a key-value pair, the key is used to uniquely identify the value, and the value is the data associated with the key. First, the first key-value set pair is established with the target code and the regulatory code value to characterize the association relationship between the target code and the regulatory code values associated with each regulatory system. Then, the regulatory code value is combined to analyze in the mapping pair set, and all mapping pairs that have an association relationship with the regulatory code value are found as a mapping pair column. Then, in a similar way, the standard code value associated with the regulatory code value in the mapping pair column is combined to establish a second key-value set pair to characterize the association relationship between the regulatory code value and the standard code value associated with each source system. Finally, the first key-value set pair and the second key-value set pair are integrated to obtain the code value association relationship between the target code and the associated source system.
[0064] Through this solution, the code value association relationship between the target code and the associated source system is analyzed and determined in the form of key-value set pairs, which has high analysis accuracy.
[0065] In one embodiment, step 603 includes: determining a first initial key-value set pair according to the target code; the first initial key-value set pair includes a first code value and a first linked list; inserting the supervision code value into the linked list of the first initial key-value set pair to obtain the first key-value set pair.
[0066] Specifically, the solution of this embodiment first establishes a key-value pair set map01, that is, the first initial key-value set pair. In map01, key is each code value of the target code, value is a linked list, and the associated mapping pair list pairList associated with all target codes is obtained. The associated mapping pair list pairList is traversed, and the regulatory code value corresponding to the code value of the target code in each mapping pair is inserted into the corresponding linked list in map01 to obtain the first key-value set pair.
[0067] For ease of understanding, the following explanation is provided in conjunction with Figure 7. Taking the input target code as PROV_NO as an example, a mapping pair list [mapping pair 1, mapping pair 5, mapping pair 2] can be obtained in the mapping pair set of Figure 7, wherein two regulatory codes are involved, namely EAST_PROV and EAST_PROV_NO. The regulatory code values of the two regulatory codes are inserted into the corresponding linked list of map01, and the final result is shown in Figure 8, that is, the first key-value set pair is obtained.
[0068] In one embodiment, step 605 includes: determining a second initial key value set pair based on the regulatory code value; the second initial key value set pair includes a second code value and a second linked list; inserting the standard code value associated with the regulatory code value in the mapping pair column into the second linked list of the second initial key value set pair to obtain a second key value set pair.
[0069] Specifically, after obtaining the first key-value set pair, continue to map the regulatory code list in the pair list, and further obtain the mapping pair column of the regulatory code in the regulatory code list, establish map02, that is, the second initial key-value set pair. In this initial key-value set pair, key is each code value of the regulatory code in the mapping pair list, value is a linked list, traverse the mapping pair column, and insert the code value of the standard code corresponding to the code value of the regulatory code into the corresponding linked list in map02 to obtain the second key-value set pair.
[0070] For ease of understanding, the explanation is also provided in conjunction with Figure 7. The input target code is also PROV_NO, and the mapping pair column eastPairList involved in the regulatory code list [EAST_PROV, EAST_PROV_NO] is [mapping pair 1, mapping pair 2, mapping pair 3, mapping pair 4]. All mapping pair columns eastPairList are traversed, and the code values of each standard code in the mapping queue are inserted into the linked list corresponding to map02, obtaining the second key-value set pair as shown in Figure 9.
[0071] Please refer to FIG. 10 , in one embodiment, the method further includes step 1002 .
[0072] Step 1002: After obtaining the target code's associated source end system and code value association relationship, the target code's associated source end system and code value association relationship are reviewed and signed.
[0073] Specifically, the solution of this embodiment, after completing the analysis of the associated source system and the calculation of the code value association relationship for the target code, needs to review the final analysis result, sign for it if the review is passed, and directly call it when there is a subsequent use demand, which is extremely convenient.
[0074] It should be understood that, although the various steps in the flowcharts involved in the above-mentioned embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps does not have a strict order restriction, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-mentioned embodiments can include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily to be carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.
[0075] Based on the same inventive concept, the embodiment of the present application also provides a data standard management device for implementing the data standard management method involved above. The implementation solution provided by the device to solve the problem is similar to the implementation solution recorded in the above method, so the specific limitations in one or more data standard management device embodiments provided below can refer to the limitations of the data standard management method above, and will not be repeated here.
[0076] Please refer to FIG. 11 . The present application provides a data standard management device, including a mapping pair generation module 112 , a code value mapping initiation module 114 , an association mapping analysis module 116 , and a code value relationship calculation module 118 .
[0077] The mapping pair generation module 112 is used to determine the mapping pair set according to the specification data standard and the source data standard of the source system; the code value mapping initiation module 114 is used to obtain the target code when there is a code value mapping requirement; the association mapping analysis module 116 is used to analyze the target code and the mapping pair set to determine the associated mapping pair list of the target code; the code value relationship calculation module 118 is used to analyze the associated mapping pair list to determine the associated source system of the target code, as well as the code value association relationship between the target code and the associated source system.
[0078] In one embodiment, the specification data standard is a regulatory data standard, and the mapping pair generation module 112 is also used to obtain a data item source and a regulatory code of a regulatory data standard, as well as a system field source and a standard code of a source data standard in a source system; the data item source, the regulatory code, the system field source and the standard code are associated and stored to obtain a mapping pair; according to the regulatory data standard and the source system, the mapping pairs formed by the associated storage are determined to determine a mapping pair set.
[0079] In one embodiment, the associated mapping analysis module 116 is further configured to detect whether there is a mapping pair associated with the target code in the mapping pair set; if there is an associated mapping pair, then determine an associated mapping pair list of the target code according to the associated mapping pair.
[0080] In one of the embodiments, the code value relationship calculation module 118 is also used to use the source end system corresponding to the mapping pair in the associated mapping pair list as the associated source end system of the target code; determine the regulatory code value associated with the target code according to the associated mapping pair list; determine the first key value set pair according to the target code and the regulatory code value; analyze the regulatory code value and the associated mapping pair list to determine the mapping pair column associated with the regulatory code value; determine the second key value set pair according to the standard code value associated with the regulatory code value in the mapping pair column; integrate the first key value set pair and the second key value set pair to obtain the code value association relationship between the target code and the associated source end system.
[0081] In one embodiment, the code value relationship calculation module 118 is also used to determine a first initial key value set pair according to the target code; the first initial key value set pair includes a first code value and a first linked list; the supervision code value is inserted into the linked list of the first initial key value set pair to obtain the first key value set pair.
[0082] In one embodiment, the code value relationship calculation module 118 is also used to determine a second initial key value set pair based on the regulatory code value; the second initial key value set pair includes a second code value and a second linked list; the standard code value associated with the regulatory code value in the mapping pair column is inserted into the second linked list of the second initial key value set pair to obtain a second key value set pair.
[0083] Each module in the above data standard management device can be implemented in whole or in part by software, hardware or a combination thereof. Each module can be embedded in or independent of a processor in a computer device in the form of hardware, or can be stored in a memory in a computer device in the form of software, so that the processor can call and execute the operations corresponding to each module.
[0084] The above-mentioned data standard management device can determine the mapping pair set according to the specification data standard and the source data standard of the source end system, and then obtain the target code when there is a code value mapping requirement, analyze the target code and the mapping pair set, and determine the associated mapping pair list of the target code; analyze the associated mapping pair list to determine the associated source end system of the target code, and the code value association relationship between the target code and the associated source end system. Through this solution, the code of the source end data standard in any source end system can be used as the target code to perform code value management and analysis, find the associated source end systems associated with it, and the code value association relationship between the target code and the associated source end system. In this way, by associating two source end systems with different data standards, the data format between the systems can be unified without adopting a unique standard, thereby improving the efficiency of cross-system data extraction, fusion, and analysis.
[0085] In an exemplary embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be shown in FIG12. The computer device includes a processor, a memory, an input / output interface (Input / Output, referred to as I / O) and a communication interface. The processor, the memory and the input / output interface are connected via a system bus, and the communication interface is connected to the system bus via the input / output interface. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store business management data. The input / output interface of the computer device is used to exchange information between the processor and an external device. The communication interface of the computer device is used to communicate with an external terminal via a network connection. When the computer program is executed by the processor, a data standard management method is implemented.
[0086] Those skilled in the art will understand that the structure shown in FIG. 12 is merely a block diagram of a partial structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than shown in the figure, or combine certain components, or have a different arrangement of components.
[0087] In an exemplary embodiment, a computer device is provided, including a memory and a processor, wherein a computer program is stored in the memory, and when the processor executes the computer program, the following steps are implemented:
[0088] Determine the mapping pair set according to the specification data standard and the source data standard of the source system; obtain the target code when there is a code value mapping requirement; determine the associated mapping pair list of the target code according to the target code and the mapping pair set; determine the associated source system of the target code and the code value association relationship between the target code and the associated source system according to the associated mapping pair list.
[0089] In one embodiment, when the processor executes the computer program, the following steps are also implemented: obtaining a data item source and a regulatory code of a regulatory data standard, as well as a system field source and a standard code of a source data standard in a source system; associating and storing the data item source, the regulatory code, the system field source and the standard code to obtain a mapping pair; according to the regulatory data standard and the source system, the mapping pairs formed by the pairwise associative storage are determined to form a mapping pair set.
[0090] In one embodiment, when the processor executes the computer program, the following steps are also implemented: detecting whether there is a mapping pair associated with the target code in the mapping pair set; if there is an associated mapping pair, determining an associated mapping pair list of the target code according to the associated mapping pair.
[0091] In one embodiment, when the processor executes the computer program, the following steps are also implemented: the source end system corresponding to the mapping pair in the associated mapping pair list is used as the associated source end system of the target code; according to the associated mapping pair list, the regulatory code value associated with the target code is determined; according to the target code and the regulatory code value, a first key value set pair is determined; according to the regulatory code value and the associated mapping pair list, a mapping pair column associated with the regulatory code value is analyzed; according to the standard code value associated with the regulatory code value in the mapping pair column, a second key value set pair is determined; and the first key value set pair and the second key value set pair are integrated to obtain the code value association relationship between the target code and the associated source end system.
[0092] In one embodiment, when the processor executes the computer program, the following steps are also implemented: determining a first initial key-value set pair according to the target code; the first initial key-value set pair includes a first code value and a first linked list; inserting the supervision code value into the linked list of the first initial key-value set pair to obtain the first key-value set pair.
[0093] In one embodiment, when the processor executes the computer program, the following steps are also implemented: determining a second initial key value set pair based on the supervision code value; the second initial key value set pair includes a second code value and a second linked list; inserting the standard code value associated with the supervision code value in the mapping pair column into the second linked list of the second initial key value set pair to obtain a second key value set pair.
[0094] In one embodiment, a computer readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, the following steps are implemented:
[0095] Determine the mapping pair set according to the specification data standard and the source data standard of the source system; obtain the target code when there is a code value mapping requirement; determine the associated mapping pair list of the target code according to the target code and the mapping pair set; determine the associated source system of the target code and the code value association relationship between the target code and the associated source system according to the associated mapping pair list.
[0096] In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: obtaining a data item source and a regulatory code of a regulatory data standard, as well as a system field source and a standard code of a source data standard in a source system; associating and storing the data item source, the regulatory code, the system field source and the standard code to obtain a mapping pair; according to the regulatory data standard and the source system, the mapping pairs formed by the pairwise associative storage are determined to determine a mapping pair set.
[0097] In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: detecting whether there is a mapping pair associated with the target code in the mapping pair set; if there is an associated mapping pair, determining an associated mapping pair list of the target code based on the associated mapping pair.
[0098] In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: the source end system corresponding to the mapping pair in the associated mapping pair list is used as the associated source end system of the target code; the regulatory code value associated with the target code is determined according to the associated mapping pair list; a first key value set pair is determined according to the target code and the regulatory code value; a mapping pair column associated with the regulatory code value is determined according to the regulatory code value and the associated mapping pair list; a second key value set pair is determined according to the standard code value associated with the regulatory code value in the mapping pair column; and the first key value set pair and the second key value set pair are integrated to obtain the code value association relationship between the target code and the associated source end system.
[0099] In one embodiment, when the computer program is executed by a processor, the following steps are also implemented: determining a first initial key-value set pair according to the target code; the first initial key-value set pair includes a first code value and a first linked list; inserting the supervision code value into the linked list of the first initial key-value set pair to obtain the first key-value set pair.
[0100] In one embodiment, when the computer program is executed by a processor, the following steps are also implemented: determining a second initial key value set pair based on the supervision code value; the second initial key value set pair includes a second code value and a second linked list; inserting the standard code value associated with the supervision code value in the mapping pair column into the second linked list of the second initial key value set pair to obtain a second key value set pair.
[0101] In one embodiment, a computer program product is provided, comprising a computer program, which, when executed by a processor, implements the following steps:
[0102] Determine the mapping pair set according to the specification data standard and the source data standard of the source system; obtain the target code when there is a code value mapping requirement; determine the associated mapping pair list of the target code according to the target code and the mapping pair set; determine the associated source system of the target code and the code value association relationship between the target code and the associated source system according to the associated mapping pair list.
[0103] In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: obtaining a data item source and a regulatory code of a regulatory data standard, as well as a system field source and a standard code of a source data standard in a source system; associating and storing the data item source, the regulatory code, the system field source and the standard code to obtain a mapping pair; according to the regulatory data standard and the source system, the mapping pairs formed by the pairwise associative storage are determined to determine a mapping pair set.
[0104] In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: detecting whether there is a mapping pair associated with the target code in the mapping pair set; if there is an associated mapping pair, determining an associated mapping pair list of the target code based on the associated mapping pair.
[0105] In one embodiment, when the computer program is executed by the processor, the following steps are also implemented: the source end system corresponding to the mapping pair in the associated mapping pair list is used as the associated source end system of the target code; the regulatory code value associated with the target code is determined according to the associated mapping pair list; a first key value set pair is determined according to the target code and the regulatory code value; a mapping pair column associated with the regulatory code value is determined according to the regulatory code value and the associated mapping pair list; a second key value set pair is determined according to the standard code value associated with the regulatory code value in the mapping pair column; and the first key value set pair and the second key value set pair are integrated to obtain the code value association relationship between the target code and the associated source end system.
[0106] In one embodiment, when the computer program is executed by a processor, the following steps are also implemented: determining a first initial key-value set pair according to the target code; the first initial key-value set pair includes a first code value and a first linked list; inserting the supervision code value into the linked list of the first initial key-value set pair to obtain the first key-value set pair.
[0107] In one embodiment, when the computer program is executed by a processor, the following steps are also implemented: determining a second initial key value set pair based on the supervision code value; the second initial key value set pair includes a second code value and a second linked list; inserting the standard code value associated with the supervision code value in the mapping pair column into the second linked list of the second initial key value set pair to obtain a second key value set pair.
[0108] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetoresistive random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, etc., but are not limited to this.
[0109] The above-mentioned computer device and storage medium can determine the mapping pair set according to the standard data standard and the source data standard of the source system, and then obtain the target code when there is a code value mapping requirement, analyze the target code and the mapping pair set, and determine the associated mapping pair list of the target code; analyze the associated mapping pair list to determine the associated source system of the target code, and the code value association relationship between the target code and the associated source system. Through this solution, the code of the source data standard in any source system can be used as the target code to manage and analyze the code value, find the associated source systems associated with it, and the code value association relationship between the target code and the associated source system. In this way, by associating two source systems with different data standards, the data format between the systems can be unified without adopting a unique standard, and the efficiency of cross-system data extraction, fusion, and analysis can be improved.
[0110] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.
[0111] The above-described embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the present application. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the attached claims.
Claims
1. A data standard management method, characterized in that: include: Determine the mapping pair set according to the specification data standard and the source data standard of the source system; When there is a need for code value mapping, obtain the target code; Analyze the target code and the mapping pair set to determine a list of associated mapping pairs of the target code; The list is analyzed according to the association mapping to determine the associated source end system of the target code and the code value association relationship between the target code and the associated source end system.
2. The data standard management method according to claim 1, characterized in that: The specification data standard is a regulatory data standard, and determining a mapping pair set according to the specification data standard and the source data standard of the source system includes: Obtain the data item source and regulatory code of a regulatory data standard, as well as the system field source and standard code of a source data standard in a source system; The data item source, the supervision code, the system field source and the standard code are stored in association to obtain a mapping pair; According to the regulatory data standard and the source end system, the mapping pairs formed by two-way associative storage are determined to determine a mapping pair set.
3. The data standard management method according to claim 1 or 2, characterized in that: The step of analyzing the target code and the mapping pair set to determine a list of associated mapping pairs of the target code includes: Detecting whether the mapping pair set contains a mapping pair associated with the target encoding; If an associated mapping pair exists, an associated mapping pair list of the target encoding is determined according to the associated mapping pair.
4. The data standard management method according to claim 3, characterized in that: The analyzing the list according to the association mapping to determine the associated source end system of the target code and the code value association relationship between the target code and the associated source end system includes: Using the source end system corresponding to the mapping pair in the associated mapping pair list as the associated source end system of the target code; Determining the supervision code value associated with the target code according to the association mapping pair list; Determining a first key-value set pair according to the target code and the supervision code value; Analyze the regulatory code value and the associated mapping pair list to determine the mapping pair list associated with the regulatory code value; Determining a second key-value set pair according to the standard code value associated with the regulatory code value in the mapping pair column; The first key-value set pair and the second key-value set pair are integrated to obtain a code value association relationship between the target code and the associated source end system.
5. The data standard management method according to claim 4, characterized in that: The step of determining a first key-value set pair according to the target code and the supervision code value includes: Determine a first initial key-value set pair according to the target encoding; the first initial key-value set pair includes a first code value and a first linked list; Insert the supervision code value into the linked list of the first initial key-value set pairs to obtain a first key-value set pair.
6. The data standard management method according to claim 4, characterized in that: Determining a second key-value set pair according to the standard code value associated with the regulatory code value in the mapping pair sequence includes: Determine a second initial key-value set pair according to the supervision code value; the second initial key-value set pair includes a second code value and a second linked list; Insert the standard code value associated with the supervision code value in the mapping pair sequence into the second linked list of the second initial key-value set pairs to obtain a second key-value set pair.
7. The data standard management method according to claim 1 or 2, characterized in that: Also includes: After obtaining the associated source end system of the target code and the code value associated relationship, the associated source end system of the target code and the code value associated relationship are reviewed and signed.
8. A data standard management device, characterized in that: include: A mapping pair generation module, used to determine a mapping pair set according to the specification data standard and the source end data standard of the source end system; A code value mapping initiation module is used to obtain the target code when there is a code value mapping requirement; An association mapping analysis module, used to analyze the target code and the mapping pair set to determine an association mapping pair list of the target code; The code value relationship calculation module is used to analyze the list according to the association mapping to determine the associated source end system of the target code and the code value association relationship between the target code and the associated source end system.
9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 7 are implemented.
10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 7 are implemented.