Mapping method and system for realizing standardization of medical institution heterogeneous data value domain code

Abstract

This invention discloses a mapping method and system for standardizing value domain codes of heterogeneous data from medical institutions, belonging to the field of data processing technology. The technical problem it addresses is how to improve mapping efficiency while ensuring the uniqueness of mapping the same value domain code to a standard value domain code. The method includes: obtaining value domain code parameters for the target hospital; determining the mapping method based on the standard value domain code; loading the corresponding dictionary document based on the standard value domain code, and performing a search and matching operation on the loaded dictionary document based on the meaning of the hospital's value domain code values ​​to form mapping information as the output mapping result; matching the meaning of the hospital's value domain code values ​​one by one with the meaning of all values ​​corresponding to the standard value domain code using regular expressions, and forming mapping information based on the optimal matching result; manually verifying the mapping results of the dictionary mapping and matching mapping, and manually mapping value domain code parameters that are incorrectly mapped or have not been successfully mapped.

Description

Technical Field

[0001] This invention relates to the field of data processing technology, specifically to a mapping method and system for standardizing the value domain codes of heterogeneous data in medical institutions. Background Technology

[0002] Data governance involves rationally processing collected data according to existing platform standards and supervising the acquisition, processing, and use of data. In the process of heterogeneous data governance in hospitals, data standardization is a demanding yet crucial task, which includes the mapping of value domain codes.

[0003] The standard value range code is a set of mapping results. It can be a national standard or a standard set by the medical platform itself. For example, Table 1 shows the drug type value range codes of some standard chemical drug categories. The value range code name is STD_DRUG_TYPE.

[0004] Table 1. Value Range Codes for Drug Types in Some Major Categories of Chemical Drugs Value range code Value domain code name value Value meaning illustrate STD_DRUG_TYPE Drug type code 10119 Antifungal drugs STD_DRUG_TYPE Drug type code 10901 diuretics and dehydrating agents STD_DRUG_TYPE Drug type code 12203 ophthalmic medications The hospital value domain code is the value domain code used by each hospital. Table 2 shows some data of the value domain codes for drug types in a certain hospital's chemical drug category.

[0005] Table 2. Value range codes for some drug types within a major category of chemical drugs in a certain hospital Drug type value of a certain hospital Meaning of Drug Type Values ​​in a Certain Hospital 10119 Antifungal drugs 10901 diuretics 4668 Cataract prevention drugs The mapping of value range codes for manual standardization can be broadly categorized into the following three types: 1. The meanings of the hospital value field codes and the content of the hospital value field code values ​​are completely matched, as shown in row 2 of Table 3; 2. The meanings of hospital value domain codes and hospital value domain codes partially overlap, as shown in row 3 of Table 3; 3. The meanings of hospital value domain codes and hospital value domain codes seem unrelated on the surface, but they are actually related, as shown in row 4 of Table 3.

[0006] Table 3. Mapping Status Table

[0007] Due to the different design schemes and logical architectures of various hospital business systems (HIS, LIS, PACS, EMR, etc.), the value domain code standards implemented for data vary. The workload of manually standardizing value domain codes is large. Furthermore, due to different people's understanding of medical data, manual mapping may result in the same value domain code being mapped to different standard value domain codes. Therefore, a unified mapping method is needed that can improve mapping efficiency and ensure the uniqueness of the same value domain code mapping to the standard value domain code.

[0008] How to improve mapping efficiency while ensuring the uniqueness of mapping the same domain code to the standard domain code is a technical problem that needs to be solved. Summary of the Invention

[0009] The technical objective of this invention is to address the above-mentioned shortcomings by providing a mapping method and system for standardizing the value domain codes of heterogeneous data in medical institutions, thereby solving the technical problem of how to improve mapping efficiency while ensuring the uniqueness of the mapping of the same value domain code to the standard value domain code.

[0010] In a first aspect, the present invention provides a mapping method for standardizing the value domain codes of heterogeneous data in medical institutions, comprising the following steps: Parameter acquisition: Obtain the value domain code parameter of the target hospital. The value domain code parameter includes the hospital code, hospital value domain code, hospital value domain code value, meaning of hospital value domain code value, and standard value domain code. Mapping method filtering: Determine the mapping method based on the standard value domain code. If a dictionary containing the standard value domain code exists, perform dictionary mapping; otherwise, perform matching mapping. Dictionary mapping: Load the corresponding dictionary document based on the standard value domain code, and search for and match the meaning of the hospital value domain code value from the loaded dictionary document. If a matching standard value domain code value meaning is found, the corresponding flag value domain code value is queried based on the standard value domain code meaning, and the mapping information is output as the mapping result. If no matching flag value domain code value meaning is found, the matching mapping is performed. The mapping information includes the standard value domain code value, the standard value domain code value meaning, the hospital code, the hospital value domain code value, and the hospital value domain code. Matching Mapping: Based on regular expressions, the meaning of the hospital value domain code is matched one by one with the meaning of all values ​​corresponding to the standard value domain code. If a matching result exists, the optimal matching result is selected based on the matching degree, and mapping information is formed based on the optimal matching result. The mapping information is output as the mapping result. If no matching result exists, the hospital value domain code value and the meaning of the hospital value domain code value are output as the mapping result. Manual verification: Manually verify the mapping results of dictionary mapping and matching mapping, and manually map the value domain code parameters that are mapped incorrectly or unsuccessfully.

[0011] Preferably, the matching mapping includes the following operations: Regular expression construction: To define the meaning of hospital value field codes, predefined symbols are inserted between two adjacent characters to form a regular expression pattern; Matching execution: Compile the regular expression pattern into a regular expression object, match the regular expression object with the meaning of all values ​​corresponding to the standard value field code one by one, store the meaning of the successfully matched field code value and the meaning of the flag value field code value as the matching result in the result array, calculate the matching degree of each matching result in the result array and sort them in descending order, and select the best matching result; Matching result processing: If an optimal matching result exists, the hospital code, hospital value domain code, hospital value domain code value and the standard value domain code value corresponding to the optimal matching result and the meaning of the standard value domain code value are supplemented to form complete mapping information and stored in the data table. If no matching result exists, only the hospital value domain code value and its corresponding meaning are stored in the data table and marked as unmatched.

[0012] As a preferred option, the matching degree calculation formula is as follows: Matching degree = length of meaning of value range code / length of meaning of matched flag value range code * 100%.

[0013] As a preferred approach, before dictionary mapping, a dictionary document is constructed based on the existing mapping relationships. The existing mapping relationships are used to record the meanings of labeled value domain codes, standard value domain codes, hospital value domain codes, and the mapping relationships between hospital value domain codes. The dictionary document records the mapping relationship between the meanings of standard value domain codes and the meanings of hospital value domain codes.

[0014] Preferably, the standard value range code value, the meaning of the standard value range code value, the hospital code, the hospital value range code value, and the hospital value range code in the mapping information are stored in an Excel data table in a predetermined field order.

[0015] Secondly, the present invention provides a mapping system for standardizing the value domain codes of heterogeneous data in medical institutions, comprising a parameter acquisition module, a mapping method filtering module, a dictionary mapping module, a matching mapping module, and a manual verification module; The parameter acquisition module is used to perform the following: obtain the value domain code parameter of the target hospital, which includes the hospital code, hospital value domain code, hospital value domain code value, meaning of hospital value domain code value, and standard value domain code; The mapping method filtering module is used to perform the following: determine the mapping method based on the standard value domain code; if a dictionary containing the standard value domain code exists, call the dictionary mapping module to perform dictionary mapping; if a dictionary containing the standard value domain code does not exist, call the matching mapping module to perform matching mapping. The dictionary mapping module performs the following operations: loads the corresponding dictionary document based on the standard value domain code; searches and matches the hospital value domain code value meaning from the loaded dictionary document; if a matching standard value domain code value meaning is found, it queries the corresponding flag value domain code value based on the standard value domain code meaning, forming mapping information as the mapping result output; if no matching flag value domain code value meaning is found, it performs matching mapping, where the mapping information includes the standard value domain code value, the standard value domain code value meaning, the hospital code, the hospital value domain code value, and the hospital value domain code. The matching and mapping module is used to perform the following: Based on regular expressions, it matches the meaning of the hospital value domain code with the meaning of all values ​​corresponding to the standard value domain code one by one. If a matching result exists, the optimal matching result is selected based on the matching degree. The mapping information is formed based on the optimal matching result and output as the mapping result. If no matching result exists, the hospital value domain code and its meaning are output as the mapping result. The manual verification module is used to perform the following: manually verify the mapping results of dictionary mapping and matching mapping, and manually map the value domain code parameters that are mapped incorrectly or unsuccessfully.

[0016] Preferably, the matching mapping module is used to perform the following operations: Regular expression construction: To define the meaning of hospital value field codes, predefined symbols are inserted between two adjacent characters to form a regular expression pattern; Matching execution: Compile the regular expression pattern into a regular expression object, match the regular expression object with the meaning of all values ​​corresponding to the standard value field code one by one, store the meaning of the successfully matched field code value and the meaning of the flag value field code value as the matching result in the result array, calculate the matching degree of each matching result in the result array and sort them in descending order, and select the best matching result; Matching result processing: If an optimal matching result exists, the hospital code, hospital value domain code, hospital value domain code value and the standard value domain code value corresponding to the optimal matching result and the meaning of the standard value domain code value are supplemented to form complete mapping information and stored in the data table. If no matching result exists, only the hospital value domain code value and its corresponding meaning are stored in the data table and marked as unmatched.

[0017] As a preferred option, the matching degree calculation formula is as follows: Matching degree = length of meaning of value range code / length of meaning of matched flag value range code * 100%.

[0018] Preferably, before performing dictionary mapping, the dictionary mapping module is used to construct a dictionary document based on the existing mapping relationship. The existing mapping relationship is used to record the meaning of the labeled value domain code, the meaning of the standard value domain code, the hospital value domain code, and the mapping relationship between the hospital value domain codes. The dictionary document records the mapping relationship between the meaning of the standard value domain code and the meaning of the hospital value domain code.

[0019] Preferably, the standard value range code value, the meaning of the standard value range code value, the hospital code, the hospital value range code value, and the hospital value range code in the mapping information are stored in an Excel data table in a predetermined field order.

[0020] The mapping method and system for standardizing heterogeneous data value domain codes in medical institutions, as described in this invention, have the following advantages: By combining dictionary mapping and matching mapping, heterogeneous data value domain code annotation mapping can minimize repetitive and manual mapping work, and ensure the uniqueness of the mapping from the same value domain code to the standard value domain code. As the amount of dictionary data increases and the accuracy improves, the amount of manual mapping required will gradually decrease, and the mapping accuracy will gradually improve. Attached Figure Description

[0021] To more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0022] The invention will be further described below with reference to the accompanying drawings.

[0023] Figure 1 This is a flowchart of a mapping method for standardizing the value domain codes of heterogeneous data in medical institutions, as described in Example 1. Detailed Implementation

[0024] 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 and implement the present invention. However, the embodiments are not intended to limit the present invention. In the absence of conflict, the embodiments of the present invention and the technical features in the embodiments can be combined with each other.

[0025] This invention provides a mapping method and system for standardizing the value domain codes of heterogeneous data in medical institutions, which solves the technical problem of mapping methods and systems for standardizing the value domain codes of heterogeneous data in medical institutions.

[0026] Example 1:

[0027] This invention provides a mapping method for standardizing the value domain codes of heterogeneous data in medical institutions, comprising five steps: data collection, mapping method filtering, dictionary mapping, matching mapping, and manual verification.

[0028] Step S100 Parameter Acquisition: Obtain the value domain code parameter of the target hospital. The value domain code parameter includes the hospital code, hospital value domain code, hospital value domain code value, meaning of hospital value domain code value, and standard value domain code.

[0029] In this embodiment, step S100 obtains the value domain code parameters for a specific hospital mapping, including the hospital code, the hospital value domain code value and its meaning, and the standard value domain code. For example, when standardizing drug type data for a hospital, the following parameters are input: (1) Hospital code: HOSPITAL_XXX; (2) Drug type value range code: STD_DRUG_TYPE; (3) The hospital value domain code and its meaning are shown in Table 4.

[0030] Table 4. Input hospital value range codes and their meanings Value range code value Value range code value meaning 10119 Antifungal drugs 10901 diuretics 4668 Cataract prevention drugs Step S200 Mapping method filtering: Determine the mapping method based on the standard value domain code. If a dictionary containing the standard value domain code exists, perform dictionary mapping. If a dictionary containing the standard value domain code does not exist, perform matching mapping.

[0031] In step S200 of this embodiment, when filtering by mapping method, it is determined whether there is a dictionary for the input standard value domain code (the dictionary and the value domain code are named with the same name). If there is a dictionary, dictionary mapping is performed first in each of the following steps. If there is no dictionary, matching mapping is performed.

[0032] Step S300 Dictionary Mapping: Load the corresponding dictionary document based on the standard value domain code, and search for and match the meaning of the hospital value domain code value from the loaded dictionary document. If a matching standard value domain code value meaning is found, query the corresponding flag value domain code value based on the standard value domain code meaning to form mapping information as the mapping result output. If no matching flag value domain code value meaning is found, perform matching mapping. The mapping information includes the standard value domain code value, the standard value domain code value meaning, the hospital code, the hospital value domain code value, and the hospital value domain code.

[0033] Before performing dictionary mapping in this embodiment, a dictionary document is constructed based on the existing mapping relationship. The existing mapping relationship is used to record the meaning of the labeled value domain code, the standard value domain code, the hospital value domain code, and the mapping relationship between the hospital value domain codes. The dictionary document records the mapping relationship between the meaning of the standard value domain code and the meaning of the hospital value domain code.

[0034] The mapping information, including the standard value field code, the meaning of the standard value field code, the hospital code, the hospital value field code, and the hospital value field code, is stored in an Excel data table according to a predetermined field order.

[0035] In this embodiment, the dictionary mapping method is to construct a dictionary based on the already matched empirical values. The dictionary mapping can not only match the cases where the meanings of the standard value domain code value and the meanings of the hospital value domain code value are mutually inclusive, but also match the cases where the meanings of the standard value domain code value and the meanings of the hospital value domain code value have no literal correlation.

[0036] Dictionary construction involves taking the pre-mapped mapping relationships and forming them into a document according to certain rules. For example, Table 5 shows some of the pre-mapped mapping relationships for drug types, forming the dictionary document format shown in Table 6.

[0037] Table 5. Mapping Relationships Standard value range code value Standard range code value meaning Hospital value field code value Hospital value field code 10119 Antifungal drugs 111 Antifungal drugs 10901 diuretics and dehydrating agents 168 diuretics 12203 ophthalmic medications 4668 Cataract prevention drugs Table 6. Dictionary Document Table Standard range code value meaning Meaning of hospital value range codes Antifungal drugs Antifungal drugs diuretics and dehydrating agents diuretics ophthalmic medications Cataract prevention drugs Name the document STD_DRUG_TYPE.txt based on the value range code STD_DRUG_TYPE for the drug type.

[0038] The dictionary mapping process is as follows: (1) Dictionary loading: Load the dictionary according to the input value range code. For example, if the value range code is mapped to the drug type, then load the contents of the STD_DRUG_TYPE.txt document; (2) Read the meaning of the hospital value domain code value line by line, and then look it up in the dictionary. If it is found, the corresponding standard value domain code value meaning will be found. This completes the mapping from the meaning of the hospital value domain code value to the meaning of the standard value domain code value. (3) Query the standard value range code value according to the meaning of the standard value range code value, and then complete the standard value range code value of the hospital and save it into an Excel data table. Table 7 below shows the mapping relationship after dictionary mapping of the sample.

[0039] Table 7. Mapping Relationship Results Table Standard value range code value Standard range code value meaning Hospital Code Hospital value field code value Hospital value field code 10119 Antifungal drugs HOSPITAL_XXX 111 Antifungal drugs 10901 diuretics and dehydrating agents HOSPITAL_XXX 168 diuretics 12203 ophthalmic medications HOSPITAL_XXX 4668 Cataract prevention drugs Step S400 Matching Mapping: Based on regular expressions, the meaning of the hospital value domain code is matched one by one with the meaning of all values ​​corresponding to the standard value domain code. If a matching result exists, the optimal matching result is selected based on the matching degree, and mapping information is formed based on the optimal matching result. The mapping information is output as the mapping result. If no matching result exists, the hospital value domain code value and the meaning of the hospital value domain code value are output as the mapping result.

[0040] As a specific implementation of the matching mapping, this step includes the following operations: (1) Regular expression construction: For the meaning of the hospital value field code, a predetermined symbol is inserted between two adjacent characters to form a regular expression pattern; (2) Matching execution: Compile the regular expression pattern into a regular expression object, match the regular expression object with the meaning of all values ​​corresponding to the standard value field code one by one, store the meaning of the successfully matched field code value and the meaning of the flag value field code value as the matching result in the result array, calculate the matching degree of each matching result in the result array and sort them in descending order, and select the best matching result; (3) Matching result processing: If there is an optimal matching result, the hospital code, hospital value domain code, hospital value domain code value and the standard value domain code value corresponding to the optimal matching result and the meaning of the standard value domain code value are supplemented to form complete mapping information and stored in the data table. If there is no matching result, only the hospital value domain code value and its corresponding meaning are stored in the data table and marked as unmatched.

[0041] The formula for calculating the matching degree is: Matching degree = length of meaning of value range code / length of meaning of matched flag value range code * 100%.

[0042] In this embodiment, the matching mapping method is based on regular expressions, which can match cases where the standard value field code and the hospital value field code mutually contain each other. This scheme is implemented using the `re` module in Python 3.6; other programming languages ​​also have similar modules, which use `re.`. The specific matching mapping method is as follows: (1) Formulating a regular expression: The specific regular expression is to split the input value into characters to form a rule containing the input value. For example, if the input is "diuretic drug", then the rule "diuretic.*?dilution.*?dilution" will be formed. The method for formulating a regular expression in Python 3.6 is as follows: pattern = '.*?'.join(“diuretics”), Note: pattern is a string variable, and rules are formed using the join() method; (2) Matching method, the specific process is as follows: (2-1) After inputting the value to be matched, perform pattern matching against the meaning of the standard value range code value. Return as soon as the first match is found; otherwise, return the non-match flag None. The method for specifying this in Python 3.6 is as follows: The regular expression object is generated according to the rules: regex = re.compile(pattern); Then, a pattern match is performed against the standard value range code meaning "diuretics and dehydrating agents", returning a match object: match = regex.search("diuretics and dehydrating agents"), If match is not None, it means the match was successful; (2-2) Input the meaning of the value range code to be matched. The meaning of the value needs to be matched with the meaning of all values ​​of the standard value range code one by one, and the matching results are stored in an array, such as named result=[]. (2-3) After traversing the meaning of the standard value range code values, sort the matching results according to the matching degree, and take the best matching result as the final result; (3) Matching result processing: If the match is successful, it means that there is a mutual inclusion relationship between the two. By default, the two values ​​have the same or similar meanings. This completes the mapping from the meaning of the hospital value range code value to the meaning of the standard value range code value. After the hospital value range code value and the standard value range code value are completed, they are stored in an Excel data table. Table 8 below shows the mapping relationship after the sample matching.

[0043] Table 8. Mapping Relationship Results Table Standard value range code value Standard range code value meaning Hospital Code Hospital value field code value Hospital value field code 10119 Antifungal drugs HOSPITAL_XXX 111 Antifungal drugs 10901 Diuretics and dehydrating agents HOSPITAL_XXX 168 diuretics No match found No match found HOSPITAL_XXX 4668 Cataract prevention drugs Step S500 Manual verification: Manually verify the mapping results of dictionary mapping and matching mapping, and manually map the value domain code parameters that are mapped incorrectly or unsuccessfully.

[0044] After the matching mapping and dictionary mapping are completed, the mapping results should be manually audited, and the value domain codes that are mapped incorrectly or unsuccessfully should be manually mapped.

[0045] This embodiment uses a "matching + dictionary" approach to map different value domain codes from heterogeneous hospital data to standard value domain codes. The matching method uses regular expressions to map value domain codes based on literal meanings. The dictionary method uses a mapping dictionary based on empirical values ​​to automate the mapping of already mapped value domain codes. The matching method uses regular expressions to form expressions like "X.*?X.*?X" (where X represents a character) to map the meanings of standard and individual hospital value domain codes, thus mapping cases where the meanings of value domain codes are mutually inclusive. The dictionary method maintains the mapping relationships of already mapped value domain codes as a dictionary, thereby automating the remapping of already mapped value domain codes.

[0046] The standardization process of value domain codes for heterogeneous hospital data requires significant manual mapping, and this work is repetitive. Furthermore, manual mapping by different people can result in the same value domain code mapping to different standard value domain codes. This mapping method aims to automate the process as much as possible, minimizing repetitive and manual work, and ensuring the uniqueness of the mapping between the same value domain code and the standard value domain code. Example

[0047] This invention provides a mapping system for standardizing the value domain codes of heterogeneous data in medical institutions, comprising a parameter acquisition module, a mapping method filtering module, a dictionary mapping module, a matching mapping module, and a manual verification module.

[0048] The parameter acquisition module is used to perform the following: obtain the value domain code parameter of the target hospital, which includes the hospital code, hospital value domain code, hospital value domain code value, meaning of hospital value domain code value, and standard value domain code.

[0049] In this embodiment, the parameter acquisition module obtains the value domain code parameters for a specific hospital mapping, including the hospital code, the hospital value domain code value and its meaning, and the standard value domain code. For example, when standardizing drug type data for a certain hospital, the following parameters are input: (1) Hospital code: HOSPITAL_XXX; (2) Drug type value range code: STD_DRUG_TYPE; (3) Hospital value domain code and its meaning.

[0050] The mapping method filtering module is used to perform the following: determine the mapping method based on the standard value domain code; if a dictionary containing the standard value domain code exists, call the dictionary mapping module to perform dictionary mapping; if a dictionary containing the standard value domain code does not exist, call the matching mapping module to perform matching mapping.

[0051] In this embodiment, when the mapping method filtering module performs mapping method filtering, it determines whether there is a dictionary for the input standard value domain code (the dictionary and the value domain code are named the same). If there is a dictionary, dictionary mapping is performed first in each of the following steps; if there is no dictionary, matching mapping is performed.

[0052] The dictionary mapping module performs the following operations: it loads the corresponding dictionary document based on the standard value domain code, searches and matches the meaning of the hospital value domain code value from the loaded dictionary document, if a matching standard value domain code value meaning is found, it queries the corresponding flag value domain code value based on the standard value domain code meaning, and outputs the mapping information as the mapping result; if no matching flag value domain code value meaning is found, it performs the matching mapping, where the mapping information includes the standard value domain code value, the standard value domain code value meaning, the hospital code, the hospital value domain code value, and the hospital value domain code.

[0053] Before performing dictionary mapping in this embodiment, the dictionary mapping module is used to construct a dictionary document based on the existing mapping relationship. The existing mapping relationship is used to record the meaning of the labeled value domain code, the meaning of the standard value domain code, the hospital value domain code, and the mapping relationship between the hospital value domain codes. The dictionary document records the mapping relationship between the meaning of the standard value domain code and the meaning of the hospital value domain code.

[0054] The mapping information, including the standard value field code, the meaning of the standard value field code, the hospital code, the hospital value field code, and the hospital value field code, is stored in an Excel data table according to a predetermined field order.

[0055] In this embodiment, the dictionary mapping method is to construct a dictionary based on the already matched empirical values. The dictionary mapping can not only match the cases where the meanings of the standard value domain code value and the meanings of the hospital value domain code value are mutually inclusive, but also match the cases where the meanings of the standard value domain code value and the meanings of the hospital value domain code value have no literal correlation.

[0056] Dictionary construction involves organizing pre-defined mapping relationships into a document according to certain rules. The dictionary mapping process is as follows: (1) Dictionary loading: Load the dictionary according to the input value range code. For example, if the value range code is mapped to the drug type, then load the contents of the STD_DRUG_TYPE.txt document; (2) Read the meaning of the hospital value domain code value line by line, and then look it up in the dictionary. If it is found, the corresponding standard value domain code value meaning will be found. This completes the mapping from the meaning of the hospital value domain code value to the meaning of the standard value domain code value. (3) Find the standard value range code value according to the meaning of the standard value range code value, and then fill in the hospital's standard value range code value and save it into an Excel data table.

[0057] The matching and mapping module is used to perform the following: Based on regular expressions, it matches the meaning of the hospital value domain code with the meaning of all values ​​corresponding to the standard value domain code one by one. If a matching result exists, the optimal matching result is selected based on the matching degree. The mapping information is formed based on the optimal matching result and output as the mapping result. If no matching result exists, the hospital value domain code and its meaning are output as the mapping result.

[0058] As a specific implementation of the matching mapping module, this module is used to perform the following operations: (1) Regular expression construction: For the meaning of the hospital value field code, a predetermined symbol is inserted between two adjacent characters to form a regular expression pattern; (2) Matching execution: Compile the regular expression pattern into a regular expression object, match the regular expression object with the meaning of all values ​​corresponding to the standard value field code one by one, store the meaning of the successfully matched field code value and the meaning of the flag value field code value as the matching result in the result array, calculate the matching degree of each matching result in the result array and sort them in descending order, and select the best matching result; (3) Matching result processing: If there is an optimal matching result, the hospital code, hospital value domain code, hospital value domain code value and the standard value domain code value corresponding to the optimal matching result and the meaning of the standard value domain code value are supplemented to form complete mapping information and stored in the data table. If there is no matching result, only the hospital value domain code value and its corresponding meaning are stored in the data table and marked as unmatched.

[0059] The formula for calculating the matching degree is: Matching degree = length of meaning of value range code / length of meaning of matched flag value range code * 100%.

[0060] In this embodiment, the matching mapping method is based on regular expressions, which can match cases where the standard value field code and the hospital value field code mutually contain each other. This scheme is implemented using the `re` module in Python 3.6; other programming languages ​​also have similar modules, which use `re.`. The specific matching mapping method is as follows: (1) Formulating a regular expression: The specific regular expression is to split the input value into characters to form a rule containing the input value. For example, if the input is "diuretic drug", then the rule "diuretic.*?dilution.*?dilution" will be formed. The method for formulating a regular expression in Python 3.6 is as follows: pattern = '.*?'.join(“diuretics”), Note: pattern is a string variable, and rules are formed using the join() method; (2) Matching method, the specific process is as follows: (2-1) After inputting the value to be matched, perform pattern matching against the meaning of the standard value range code value. Return as soon as the first match is found; otherwise, return the non-match flag None. The method for specifying this in Python 3.6 is as follows: The regular expression object is generated according to the rules: regex = re.compile(pattern); Then, a pattern match is performed against the standard value range code meaning "diuretics and dehydrating agents", returning a match object: match = regex.search("diuretics and dehydrating agents"), If match is not None, it means the match was successful; (2-2) Input the meaning of the value range code to be matched. The meaning of the value needs to be matched with the meaning of all values ​​of the standard value range code one by one, and the matching results are stored in an array, such as named result=[]. (2-3) After traversing the meaning of the standard value range code values, sort the matching results according to the matching degree, and take the best matching result as the final result; (3) Matching result processing: If the match is successful, it means that there is a mutual inclusion relationship between the two. By default, the two values ​​have the same or similar meanings. This completes the mapping from the meaning of the hospital value range code value to the meaning of the standard value range code value. After the hospital value range code value and the standard value range code value are completed, they are stored in an Excel data table. Table 8 below shows the mapping relationship after the sample matching.

[0061] The manual verification module is used to perform the following: manually verify the mapping results of dictionary mapping and matching mapping, and manually map the value domain code parameters that are mapped incorrectly or unsuccessfully.

[0062] In this embodiment, after the matching mapping and dictionary mapping are completed, the mapping results need to be manually audited, and the value domain codes that are mapped incorrectly or unsuccessfully need to be manually mapped.

[0063] The system in this embodiment can execute the method disclosed in Embodiment 1 to achieve the standardization mapping of heterogeneous data value domain codes in hospitals.

[0064] The foregoing has provided a detailed description of the mapping method and system for standardizing the value domain codes of heterogeneous data in medical institutions. Specific examples have been used to illustrate the principles and implementation methods of the present invention. The descriptions of the above embodiments are only for the purpose of helping to understand the method and core ideas of the present invention. At the same time, for those skilled in the art, there will be changes in the specific implementation methods and application scope based on the ideas of the present invention. Therefore, the content of this specification should not be construed as a limitation of the present invention.

Claims

1. A mapping method for standardizing the value domain codes of heterogeneous data in medical institutions, characterized in that, Includes the following steps: Parameter acquisition: Obtain the value domain code parameter of the target hospital. The value domain code parameter includes the hospital code, hospital value domain code, hospital value domain code value, meaning of hospital value domain code value, and standard value domain code. Mapping method filtering: Determine the mapping method based on the standard value domain code. If a dictionary containing the standard value domain code exists, perform dictionary mapping; otherwise, perform matching mapping. Dictionary mapping: Load the corresponding dictionary document based on the standard value domain code, and search for and match the meaning of the hospital value domain code value from the loaded dictionary document. If a matching standard value domain code value meaning is found, the corresponding flag value domain code value is queried based on the standard value domain code meaning, and the mapping information is output as the mapping result. If no matching flag value domain code value meaning is found, the matching mapping is performed. The mapping information includes the standard value domain code value, the standard value domain code value meaning, the hospital code, the hospital value domain code value, and the hospital value domain code. Matching Mapping: Based on regular expressions, the meaning of the hospital value domain code is matched one by one with the meaning of all values ​​corresponding to the standard value domain code. If a matching result exists, the optimal matching result is selected based on the matching degree, and mapping information is formed based on the optimal matching result. The mapping information is output as the mapping result. If no matching result exists, the hospital value domain code value and the meaning of the hospital value domain code value are output as the mapping result. Manual verification: Manually verify the mapping results of dictionary mapping and matching mapping, and manually map the value domain code parameters that are mapped incorrectly or unsuccessfully.

2. The mapping method for standardizing the value domain codes of heterogeneous data in medical institutions according to claim 1, characterized in that, Matching mapping includes the following operations: Regular expression construction: To define the meaning of hospital value field codes, predefined symbols are inserted between two adjacent characters to form a regular expression pattern; Matching execution: Compile the regular expression pattern into a regular expression object, match the regular expression object with the meaning of all values ​​corresponding to the standard value field code one by one, store the meaning of the successfully matched field code value and the meaning of the flag value field code value as the matching result in the result array, calculate the matching degree of each matching result in the result array and sort them in descending order, and select the best matching result; Matching result processing: If an optimal matching result exists, the hospital code, hospital value domain code, hospital value domain code value and the standard value domain code value corresponding to the optimal matching result and the meaning of the standard value domain code value are supplemented to form complete mapping information and stored in the data table. If no matching result exists, only the hospital value domain code value and its corresponding meaning are stored in the data table and marked as unmatched.

3. The mapping method for standardizing the value domain codes of heterogeneous data in medical institutions according to claim 2, characterized in that, The formula for calculating the matching degree is: Matching degree = length of meaning of value range code / length of meaning of matched flag value range code * 100%.

4. The mapping method for standardizing the value domain codes of heterogeneous data in medical institutions according to claim 1, characterized in that, Before dictionary mapping, a dictionary document is constructed based on the existing mapping relationship. The existing mapping relationship is used to record the meaning of the labeled value domain code, the standard value domain code, the hospital value domain code, and the mapping relationship between the hospital value domain codes. The dictionary document records the mapping relationship between the meaning of the standard value domain code and the meaning of the hospital value domain code.

5. The mapping method for standardizing the value domain codes of heterogeneous data in medical institutions according to claim 1, characterized in that, The standard value range code value, the meaning of the standard value range code value, the hospital code, the hospital value range code value, and the hospital value range code are stored in an Excel data table according to a predetermined field order.

6. A mapping system for standardizing value domain codes of heterogeneous data in medical institutions, characterized in that, It includes a parameter acquisition module, a mapping method filtering module, a dictionary mapping module, a matching mapping module, and a manual verification module; The parameter acquisition module is used to perform the following: obtain the value domain code parameter of the target hospital, which includes the hospital code, hospital value domain code, hospital value domain code value, meaning of hospital value domain code value, and standard value domain code; The mapping method filtering module is used to perform the following: determine the mapping method based on the standard value domain code; if a dictionary containing the standard value domain code exists, call the dictionary mapping module to perform dictionary mapping; if a dictionary containing the standard value domain code does not exist, call the matching mapping module to perform matching mapping. The dictionary mapping module performs the following operations: loads the corresponding dictionary document based on the standard value domain code; searches and matches the hospital value domain code value meaning from the loaded dictionary document; if a matching standard value domain code value meaning is found, it queries the corresponding flag value domain code value based on the standard value domain code meaning, forming mapping information as the mapping result output; if no matching flag value domain code value meaning is found, it performs matching mapping, where the mapping information includes the standard value domain code value, the standard value domain code value meaning, the hospital code, the hospital value domain code value, and the hospital value domain code. The matching and mapping module is used to perform the following: Based on regular expressions, it matches the meaning of the hospital value domain code with the meaning of all values ​​corresponding to the standard value domain code one by one. If a matching result exists, the optimal matching result is selected based on the matching degree. The mapping information is formed based on the optimal matching result and output as the mapping result. If no matching result exists, the hospital value domain code and its meaning are output as the mapping result. The manual verification module is used to perform the following: manually verify the mapping results of dictionary mapping and matching mapping, and manually map the value domain code parameters that are mapped incorrectly or unsuccessfully.

7. The mapping system for standardizing the value domain codes of heterogeneous data in medical institutions according to claim 6, characterized in that, The matching mapping module is used to perform the following operations: Regular expression construction: To define the meaning of hospital value field codes, predefined symbols are inserted between two adjacent characters to form a regular expression pattern; Matching execution: Compile the regular expression pattern into a regular expression object, match the regular expression object with the meaning of all values ​​corresponding to the standard value field code one by one, store the meaning of the successfully matched field code value and the meaning of the flag value field code value as the matching result in the result array, calculate the matching degree of each matching result in the result array and sort them in descending order, and select the best matching result; Matching result processing: If an optimal matching result exists, the hospital code, hospital value domain code, hospital value domain code value and the standard value domain code value corresponding to the optimal matching result and the meaning of the standard value domain code value are supplemented to form complete mapping information and stored in the data table. If no matching result exists, only the hospital value domain code value and its corresponding meaning are stored in the data table and marked as unmatched.

8. The mapping system for standardizing the value domain codes of heterogeneous data in medical institutions according to claim 6, characterized in that, The formula for calculating the matching degree is: Matching degree = length of meaning of value range code / length of meaning of matched flag value range code * 100%.

9. The mapping system for standardizing the value domain codes of heterogeneous data in medical institutions according to claim 6, characterized in that, Before performing dictionary mapping, the dictionary mapping module is used to build a dictionary document based on the existing mapping relationship. The existing mapping relationship is used to record the meaning of the labeled value domain code, the standard value domain code, the hospital value domain code, and the mapping relationship between the hospital value domain codes. The dictionary document records the mapping relationship between the meaning of the standard value domain code and the meaning of the hospital value domain code.

10. The mapping system for standardizing the value domain codes of heterogeneous data in medical institutions according to claim 6, characterized in that, The standard value range code value, the meaning of the standard value range code value, the hospital code, the hospital value range code value, and the hospital value range code are stored in an Excel data table according to a predetermined field order.

Images