CN109857736A - The data encoding of hospital's heterogeneous system unitized method and system, equipment, medium - Google Patents
The data encoding of hospital's heterogeneous system unitized method and system, equipment, medium Download PDFInfo
- Publication number
- CN109857736A CN109857736A CN201811636969.2A CN201811636969A CN109857736A CN 109857736 A CN109857736 A CN 109857736A CN 201811636969 A CN201811636969 A CN 201811636969A CN 109857736 A CN109857736 A CN 109857736A
- Authority
- CN
- China
- Prior art keywords
- standard
- data
- source data
- hospital
- code
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 28
- 238000013507 mapping Methods 0.000 claims abstract description 31
- 230000008676 import Effects 0.000 claims abstract description 4
- 230000011218 segmentation Effects 0.000 claims description 15
- 238000004590 computer program Methods 0.000 claims description 6
- 238000010606 normalization Methods 0.000 claims description 6
- 238000007726 management method Methods 0.000 abstract description 7
- 238000013506 data mapping Methods 0.000 abstract description 3
- 239000003814 drug Substances 0.000 description 17
- 229940079593 drug Drugs 0.000 description 9
- 238000010276 construction Methods 0.000 description 6
- 238000005516 engineering process Methods 0.000 description 6
- 238000011161 development Methods 0.000 description 5
- 230000018109 developmental process Effects 0.000 description 5
- QGZKDVFQNNGYKY-UHFFFAOYSA-N Ammonia Chemical compound N QGZKDVFQNNGYKY-UHFFFAOYSA-N 0.000 description 4
- VEXZGXHMUGYJMC-UHFFFAOYSA-N Hydrochloric acid Chemical compound Cl VEXZGXHMUGYJMC-UHFFFAOYSA-N 0.000 description 4
- AVKUERGKIZMTKX-NJBDSQKTSA-N ampicillin Chemical compound C1([C@@H](N)C(=O)N[C@H]2[C@H]3SC([C@@H](N3C2=O)C(O)=O)(C)C)=CC=CC=C1 AVKUERGKIZMTKX-NJBDSQKTSA-N 0.000 description 4
- 229960000723 ampicillin Drugs 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 4
- ZKLPARSLTMPFCP-OAQYLSRUSA-N 2-[2-[4-[(R)-(4-chlorophenyl)-phenylmethyl]-1-piperazinyl]ethoxy]acetic acid Chemical compound C1CN(CCOCC(=O)O)CCN1[C@@H](C=1C=CC(Cl)=CC=1)C1=CC=CC=C1 ZKLPARSLTMPFCP-OAQYLSRUSA-N 0.000 description 2
- 229930182555 Penicillin Natural products 0.000 description 2
- JGSARLDLIJGVTE-MBNYWOFBSA-N Penicillin G Chemical compound N([C@H]1[C@H]2SC([C@@H](N2C1=O)C(O)=O)(C)C)C(=O)CC1=CC=CC=C1 JGSARLDLIJGVTE-MBNYWOFBSA-N 0.000 description 2
- 229910021529 ammonia Inorganic materials 0.000 description 2
- 229960003022 amoxicillin Drugs 0.000 description 2
- LSQZJLSUYDQPKJ-NJBDSQKTSA-N amoxicillin Chemical compound C1([C@@H](N)C(=O)N[C@H]2[C@H]3SC([C@@H](N3C2=O)C(O)=O)(C)C)=CC=C(O)C=C1 LSQZJLSUYDQPKJ-NJBDSQKTSA-N 0.000 description 2
- 125000001797 benzyl group Chemical group [H]C1=C([H])C([H])=C(C([H])=C1[H])C([H])([H])* 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 230000036541 health Effects 0.000 description 2
- 229960001508 levocetirizine Drugs 0.000 description 2
- 238000003032 molecular docking Methods 0.000 description 2
- LSQZJLSUYDQPKJ-UHFFFAOYSA-N p-Hydroxyampicillin Natural products O=C1N2C(C(O)=O)C(C)(C)SC2C1NC(=O)C(N)C1=CC=C(O)C=C1 LSQZJLSUYDQPKJ-UHFFFAOYSA-N 0.000 description 2
- 229940049954 penicillin Drugs 0.000 description 2
- 230000002441 reversible effect Effects 0.000 description 2
- BCHZICNRHXRCHY-UHFFFAOYSA-N 2h-oxazine Chemical compound N1OC=CC=C1 BCHZICNRHXRCHY-UHFFFAOYSA-N 0.000 description 1
- JGSARLDLIJGVTE-UHFFFAOYSA-N 3,3-dimethyl-7-oxo-6-[(2-phenylacetyl)amino]-4-thia-1-azabicyclo[3.2.0]heptane-2-carboxylic acid Chemical compound O=C1N2C(C(O)=O)C(C)(C)SC2C1NC(=O)CC1=CC=CC=C1 JGSARLDLIJGVTE-UHFFFAOYSA-N 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000003111 delayed effect Effects 0.000 description 1
- 238000003745 diagnosis Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 210000001503 joint Anatomy 0.000 description 1
- 230000007774 longterm Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000005180 public health Effects 0.000 description 1
- 238000012163 sequencing technique Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Landscapes
- Medical Treatment And Welfare Office Work (AREA)
Abstract
The present invention provides the unitized method of data encoding of hospital's heterogeneous system, comprising the following steps: creation index database imports normal data, is equipped with standard code in normal data, establishes the corresponding index database of normal data；Source data is imported, the source data of hospital's heterogeneous system is imported, is equipped in source data to unitized coding；Unitized coding, source data is matched with index database, establishes standard code and the mapping relations to unitized coding.The present invention relates to the unitized system of the data encoding of hospital's heterogeneous system, electronic equipment and readable storage medium storing program for executing.The source data of each heterogeneous system can be encoded and compare unified standard code by the present invention, and unified standard code is converted by the data encoding of isomery and is stored and is applied, it can quickly locate and complete data mapping, index efficiency is high, it realizes the information exchange between heterogeneous system, is conducive to the high efficiency operation management of hospital.
Description
Technical Field
The invention relates to the technical field of computer information, in particular to a data code unification method, electronic equipment and a storage medium of a hospital heterogeneous system.
Background
Through long-term development, China has established a medical health service system covering cities and countryside, which is composed of hospitals, basic medical health institutions, professional public health institutions and the like. Under the popularization and development of the information technology, the information management gradually becomes a basic sign of the hospital modernization construction, the information technology is integrated into the hospital modernization construction, the efficiency of the hospital modernization construction development can be improved, the hospital is promoted to develop in a deeper direction, and more convenient and faster service is provided for medical decision making. Therefore, the realization of the informatization construction development of the hospital becomes a necessary way for the modernization construction of the hospital.
Hospital information management systems have become an important component of modern hospital management. Resource sharing among information systems makes the work of data standard unification important. With the continuous deepening of the sanitary reform and the development of the clinical business subject construction, the situation of 'information isolated islands' of dozens of hundreds of systems such as HIS, PACS, LIS and the like in hospitals is obviously unable to adapt to the new requirements which are continuously emerging. Therefore, before medical data is used and analyzed in a hospital, various data of the hospital is generally standardized, and the standardized data is used for data analysis and utilization. Data standardization, namely the indexing of statistical data, is well done, so that the data quality is improved, the service interconnection and intercommunication are facilitated, the regional cooperation is enhanced, and a foundation is provided for the future classified diagnosis and treatment.
Each subsystem of the hospital information system may come from different suppliers, and information exchange between the systems will certainly occur, but because the definitions, understandings, connotations and the like of data sources of the suppliers are different, the exchange between the information becomes difficult, so that software is difficult to popularize, data is difficult to share, and data utilization is insufficient. Before the informatization technology reaches the data standardization capability, the hospital mainly carries out data standardization operation through manual matching; with the progress of the technology, a point-to-point communication method is adopted to realize the butt joint of different systems; secondly, the method can also be realized by an HL7Server, wherein an HL7Server is actually an application Server, and a central database which is positioned at an HL7 interface is formed, so that the number of interfaces is reduced, and the reliability of the system is improved. If the data is standardized manually, there may be a problem that the hospital coding personnel will not understand and hold the standard code constantly, which will result in the difference of the coding result. Although the manual verification can ensure the accuracy relatively speaking, the working mode will cause low data standardization efficiency, which will seriously affect the working efficiency of doctors and is not beneficial to the high-efficiency operation management of hospitals. The method of point-to-point communication and HL7server can realize the docking of hospital systems and the modernization of medical information, but the quality and the reliability of data standardization cannot be guaranteed, and the data standardization lags behind. Moreover, most search (database) engines in the market maintain indexes by using a B-tree structure, so that the updating of the indexes results in a large number of IO operations, which seriously affects the efficiency of the indexes.
Disclosure of Invention
In order to overcome the defects of the prior art, the invention aims to provide a data coding unification method of a hospital heterogeneous system, and solves the problems that the quality and reliability of data standardization cannot be guaranteed, data standardization is delayed, and index efficiency is low in the conventional hospital system docking method.
The invention provides a data coding unification method of a hospital heterogeneous system, which comprises the following steps:
creating an index library, importing standard data, wherein standard codes are arranged in the standard data, and establishing the index library corresponding to the standard data;
importing source data, importing source data of a hospital heterogeneous system, wherein the source data is internally provided with codes to be unified;
and a unified code, namely matching the source data with the index database and establishing a mapping relation between the standard code and the code to be unified.
Further, in the step of creating the index database, records in the standard data are read one by one, the standard name values corresponding to the standard name fields in the records are segmented to obtain a plurality of vocabulary units, the standard name fields and the vocabulary units are combined to form a plurality of items, a document is built through the items, the document is stored, and the index database is generated.
Further, the step of unifying encoding includes automatic unification, performing word segmentation on a standard name value corresponding to a standard name field in the record of the source data, combining the word segmentation and the standard name field into an item, searching the index database to obtain a search result, and establishing a mapping relationship between the standard encoding and a code to be unified corresponding to the search result.
Further, the step of unifying encoding further includes manual unification, when the automatic matching of the source data and the index library is unsuccessful, a standard name value corresponding to a standard name field in the record of the source data is segmented, the segmented word and the query field are combined into an item according to a query field specified by a user, the index library is searched to obtain a retrieval result, the retrieval result is inverted according to the similarity matching degree to obtain an optimal result, and a mapping relation between the standard encoding and the code to be unified corresponding to the optimal result is established.
Further, in the step of unified encoding, the primary key of the index library and the primary key of the source data are merged to form a mapping relationship.
Further, the step of unified coding further comprises outputting a comparison result, and performing platform application.
An electronic device, comprising: a processor;
a memory; and a program, wherein the program is stored in the memory and configured to be executed by the processor, the program comprising data encoding unification methods for performing the hospital heterogeneous system described above.
A computer-readable storage medium having stored thereon a computer program, characterized in that: the computer program is used for executing the data code unification method of the hospital heterogeneous system by a processor.
The data coding unification system of the hospital heterogeneous system comprises an index base creation module, a source data importing module and a unification coding module; wherein,
the index base creating module is used for importing standard data, standard codes are arranged in the standard data, records in the standard data are read one by one, a standard name value corresponding to a standard name field in the records is subjected to word segmentation to obtain a plurality of word units, the standard name field and the word units are combined to form a plurality of items, a document is built through the plurality of items, the document is stored, and an index base is generated;
the import source data module is used for importing source data and importing the source data of the hospital heterogeneous system, wherein the source data are internally provided with codes to be unified;
the unified coding module is used for matching the source data with the index database and establishing the mapping relation between the standard code and the code to be unified.
Further, the normalization coding module comprises an automatic normalization sub-module, and the automatic normalization sub-module is configured to perform word segmentation on a standard name value corresponding to a standard name field in the record of the source data, combine the word segmentation and the standard name field into an item, search the index library to obtain a search result, and establish a mapping relationship between the standard code and a code to be normalized corresponding to the search result;
the unification coding module further comprises a manual unification submodule, and the manual unification submodule is used for segmenting a standard name value corresponding to a standard name field in a record of the source data when the source data is unsuccessfully matched with the index library, combining the segmented word and the query field into an item according to a query field specified by a user, searching the index library to obtain a retrieval result, arranging the retrieval result backwards according to the similarity matching degree to obtain an optimal result, and establishing a mapping relation between the standard code and a code to be unified corresponding to the optimal result.
Compared with the prior art, the invention has the beneficial effects that:
the invention provides a data coding unification method of a hospital heterogeneous system, which comprises the following steps: creating an index library, importing standard data, setting standard codes in the standard data, and establishing an index library corresponding to the standard data; importing source data, importing source data of a hospital heterogeneous system, wherein the source data is internally provided with codes to be unified; and (3) unified coding, namely matching the source data with an index library and establishing a mapping relation between the standard coding and the code to be unified. The invention relates to a data coding unification system of a hospital heterogeneous system, an electronic device and a readable storage medium. The invention can compare the source data codes of various heterogeneous systems with the unified standard codes, convert the heterogeneous data codes into the unified standard codes for storage and application, can quickly position and complete data mapping, has high indexing efficiency, realizes information exchange among the heterogeneous systems, improves the unified and standardized quality of data, accelerates the circulation rate of standard data on a hospital information platform, and is beneficial to the high-efficiency operation management of hospitals.
The foregoing description is only an overview of the technical solutions of the present invention, and in order to make the technical solutions of the present invention more clearly understood and to implement them in accordance with the contents of the description, the following detailed description is given with reference to the preferred embodiments of the present invention and the accompanying drawings. The detailed description of the present invention is given in detail by the following examples and the accompanying drawings.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:
FIG. 1 is a flow chart of a data code unification method of the hospital heterogeneous system according to the present invention;
fig. 2 is a schematic diagram of a data coding unification system of the hospital heterogeneous system according to the present invention.
Detailed Description
The present invention will be further described with reference to the accompanying drawings and the detailed description, and it should be noted that any combination of the embodiments or technical features described below can be used to form a new embodiment without conflict.
The data coding unification method for the hospital heterogeneous system includes, but is not limited to, using Lucene technology to perform data coding unification for the hospital heterogeneous system, as shown in fig. 1, including the following steps:
creating an index library, importing standard data, setting standard codes in the standard data, and establishing an index library corresponding to the standard data; preferably, in the step of creating the index library, records in the standard data are read one by one, the standard name value corresponding to the standard name field in the records is subjected to word segmentation to obtain a plurality of vocabulary units, the standard name field and the vocabulary units are combined to form a plurality of items, a document is constructed through the plurality of items, and the document is stored to generate the index library.
In one embodiment, the drug table is defined as follows:
| standard drug code | int |
| standard name | varchar |
| standard address | varchar |
creating an index library for the medicine table, specifically, creating an index node named user, constructing a schema structure which is the same as the table, assigning a varchar type to a participler, and reading records item by item, wherein the index library comprises the following steps:
performing word segmentation on the standard name, specifically, extracting sentences and removing punctuations to obtain: the levocetirizine hydrochloride tablet removes common words and reduces the words into a word stem form: levocetirizine hydrochloride tablets. Each separated word is a vocabulary unit (token), the token is combined with a field to form an item (term), wherein the item comprises < standard name, hydrochloric acid >, < standard name, left >, < standard name, west >, < standard name, alternative >, < standard name, benefit >, < standard name, oxazine >, and the field without the separated word directly forms the term by the field name + the field value: < standard drug 10101009> etc., the lucene technique records text values and metadata when segmenting into tokens: the offset of the original text from the starting point to the ending point, the type of vocabulary unit, and the position increment, etc. A position increment of 1, meaning that each single occurrence at successive positions in the domain, the position increment factor directly affects both phrase queries and span queries because these queries require knowledge of the distance between terms in the domain; if the position increment is larger than 1, a gap is allowed between the vocabulary units, and the gap can be used for representing deleted words such as deleted stop words; the increment of the position is 0, which indicates that the vocabulary unit is placed at the position of the previous vocabulary unit, and the synonym segmenter can indicate the inserted synonym through the increment of 0, so that any synonym can be matched with the same result when being input during phrase query. The offset is typically used to highlight the search results, reducing the cost of duplicate analysis. The document is constructed by the above items, where the document is a collection of multiple domains, and the actual storage is still stored according to the column of a single field, which is specifically as follows:
standard name
hydrochloric acid document number position increment/offset (token brought in information)
Left document number position increment/offset (token brings in information)
Western-style document number position increment/offset (token brought information)
Replace document number position increment/offset (token brought information)
And storing the constructed document, wherein after data submission is performed once, the lucene stores forward information and reverse information for the submitted data: the forward information is kept in layers from indexes up to the inclusion relationship of words: the Index (Index) - > segment (segment) - > Document (Document) - > Field (Field) - > word (Term), each level stores the information of the level and the meta information of the next level, namely the attribute information; the reverse information preserves the mapping of the dictionary to the inverted table: the word (Term) > Document (Document). In order to reduce the storage capacity of the inverted index, storing a document number list corresponding to term by using a difference value; in order to facilitate finding the document number quickly, a skip list structure is adopted for the forward file, and the traversal times are reduced.
Importing source data, importing source data of a hospital heterogeneous system, wherein the source data is internally provided with codes to be unified;
and (3) unifying coding, namely matching the source data with the index database, establishing a mapping relation between the standard coding and the code to be unified, and specifically combining the primary key of the index database with the primary key of the source data to form the mapping relation. Preferably, the step of unifying encoding further comprises outputting the comparison result for platform application. Preferably, the step of unifying encoding includes automatic unification, performing word segmentation on a standard name value corresponding to a standard name field in the record of the source data, combining the word segmentation and the standard name field into an item, searching the index database to obtain a search result, and establishing a mapping relationship between the standard code and the code to be unified corresponding to the search result. The hospital heterogeneous system includes, but is not limited to, a medicine dictionary, the source data of the medicine dictionary of the hospital heterogeneous system is shown in table 1, and the data of the medicine standard database is shown in table 2.
TABLE 1 Hospital heterogeneous System drug dictionary Source data
TABLE 2 drug Standard database data
The medical heterogeneous system medicine dictionary source data and the medicine standard database data of the hospital are automatically unified through the automatic unification step, and the obtained mapping relation is shown in table 3.
TABLE 3 Primary Key mapping relationship one
| Medicine coding | Standard medicine code |
| 000001 | 10101001 |
| 000005 | 10101009 |
In an embodiment, preferably, the step of normalizing codes further includes manual normalization, when the source data is unsuccessfully matched with the index database automatically, a standard name value corresponding to a standard name field in a record of the source data is segmented, the segmented word and the query field are combined into an item according to a query field designated by a user, the index database is searched to obtain a retrieval result, the retrieval result is inverted according to the similarity matching degree to obtain an optimal result, and a mapping relation of the standard codes and the codes to be normalized corresponding to the optimal result is established. The embodiment can control the fields needing to be indexed, and reduce the indexing times by the type classification technology. If the index library is searched for the results related to amoxicillin and ampicillin, the search words input in the search box are as follows: amoxicillin and ampicillin; obtaining a plurality of words after word segmentation: a, amomo, cillin, ammonia, benzyl, ampicillin; combining words and fields into term according to specified query fields: < standard name, a >, < standard name, a > and < standard name, penicillin >, < standard name, ammonia >, < standard name, benzyl >, < standard name, ampicillin >, then find this column in memory, a (e4, b8,9c) m (e5,8c,97), penicillin (e5, ae, b6), converted to byte and expressed in 16, constructed with the FST structure:
Tip：
| flag | e5 | flag | 8c | Addr_8c | flag | ae | Addr_ae |
addr _8c points to 97, Addr _ ae points to b 6;
Tim：
| 97 | Addr_doc1 | Addr_doc2 | b6 | Addr_doc2 | Addr_doc3 |
compressing term of all columns into a memory according to the structure, finding the position of a suffix word block by matching prefixes through FST, wherein the prefixes are non-leaf nodes, and the suffixes are leaf nodes; reading suffix blocks in the tim file in the disk and finding suffixes and corresponding inverted list position information according to the word block positions; and loading the inverted list in the document file according to the position of the inverted list, and finally taking out the result of the inverted list. And then, performing conditional filtering, and taking the file list according to the suffix corresponding to the prefix found in the FST from the generated term to the corresponding column. And (4) reversely arranging according to the matching similarity, and sequencing according to the word vector model relevance reflecting similarity matching degree.
The data that did not match successfully was normalized by the above-described manual normalization step, and the obtained search results are shown in table 4.
Table 4 search results
After the unified encoding step is performed, the primary keys of the hospital heterogeneous system drug dictionary source data and the drug standard database data are merged to form a mapping relation, as shown in table 5.
TABLE 5 Primary Key mapping relationship two
| Medicine coding | Standard medicine code |
| 000001 | 10101001 |
| 000005 | 10101009 |
| 000003 | 10101002 |
| 000004 | 10101005 |
| 000006 | 10101007 |
An electronic device, comprising: a processor;
a memory; and a program, wherein the program is stored in the memory and configured to be executed by the processor, the program comprising data code unification means for performing the hospital heterogeneous system described above.
A computer-readable storage medium having stored thereon a computer program, characterized in that: the computer program is used for executing the data code unification method of the hospital heterogeneous system by the processor.
A data code unification system of a hospital heterogeneous system, as shown in fig. 2, includes an index library creating module, a source data importing module, and a unification code module; wherein,
creating an index library module for importing standard data, wherein standard codes are arranged in the standard data, reading records in the standard data one by one, performing word segmentation on standard name values corresponding to standard name fields in the records to obtain a plurality of vocabulary units, combining the standard name fields with the vocabulary units to form a plurality of items, constructing a document through the plurality of items, storing the document, and generating an index library;
the import source data module is used for importing source data and importing the source data of the hospital heterogeneous system, and the source data is internally provided with codes to be unified;
the unified coding module is used for matching the source data with the index database and establishing a mapping relation between the standard code and the code to be unified. Preferably, the unification coding module includes an automatic unification sub-module, and the automatic unification sub-module is configured to perform word segmentation on a standard name value corresponding to a standard name field in a record of the source data, combine the word segmentation and the standard name field into an item, search the index library to obtain a search result, and establish a mapping relationship between the standard code and the to-be-unified code corresponding to the search result; specifically, the primary key of the index library is merged with the primary key of the source data to form a mapping relationship. And the unified coding module is used for outputting the comparison result and performing platform application.
The unification coding module further comprises a manual unification submodule, and the manual unification submodule is used for segmenting standard name values corresponding to the standard name fields in records of the source data when the source data are unsuccessfully matched with the index database automatically, combining the segmented words and the query fields into terms according to query fields specified by a user, searching the index database to obtain a retrieval result, reversely arranging the retrieval result according to the similarity matching degree to obtain an optimal result, and establishing a mapping relation of the standard codes and the optimal result, wherein the mapping relation of the standard codes and the optimal result is to be unified codes.
The invention provides a data coding unification method of a hospital heterogeneous system, which comprises the following steps: creating an index library, importing standard data, setting standard codes in the standard data, and establishing an index library corresponding to the standard data; importing source data, importing source data of a hospital heterogeneous system, wherein the source data is internally provided with codes to be unified; and (3) unified coding, namely matching the source data with an index library and establishing a mapping relation between the standard coding and the code to be unified. The invention relates to a data coding unification system of a hospital heterogeneous system, an electronic device and a readable storage medium. The invention can compare the source data codes of various heterogeneous systems with the unified standard codes, convert the heterogeneous data codes into the unified standard codes for storage and application, can quickly position and complete data mapping, has high indexing efficiency, realizes information exchange among the heterogeneous systems, improves the unified and standardized quality of data, accelerates the circulation rate of standard data on a hospital information platform, and is beneficial to the high-efficiency operation management of hospitals.
The foregoing is merely a preferred embodiment of the invention and is not intended to limit the invention in any manner; those skilled in the art can readily practice the invention as shown and described in the drawings and detailed description herein; however, those skilled in the art should appreciate that they can readily use the disclosed conception and specific embodiments as a basis for designing or modifying other structures for carrying out the same purposes of the present invention without departing from the scope of the invention as defined by the appended claims; meanwhile, any changes, modifications, and evolutions of the equivalent changes of the above embodiments according to the actual techniques of the present invention are still within the protection scope of the technical solution of the present invention.
Claims (10)
1. The data coding unification method of the hospital heterogeneous system is characterized by comprising the following steps:
creating an index library, importing standard data, wherein standard codes are arranged in the standard data, and establishing the index library corresponding to the standard data;
importing source data, importing source data of a hospital heterogeneous system, wherein the source data is internally provided with codes to be unified;
and a unified code, namely matching the source data with the index database and establishing a mapping relation between the standard code and the code to be unified.
2. The data code unification method of the hospital heterogeneous system according to claim 1, wherein: in the step of creating the index library, records in the standard data are read one by one, a standard name value corresponding to a standard name field in the records is subjected to word segmentation to obtain a plurality of vocabulary units, the standard name field and the vocabulary units are combined to form a plurality of items, a document is built through the plurality of items, the document is stored, and the index library is generated.
3. The data code unification method of the hospital heterogeneous system according to claim 1, wherein: the step of the normalized coding comprises automatic normalization, a standard name value corresponding to a standard name field in the record of the source data is participated, the participated word and the standard name field are combined into an item, the index database is searched to obtain a search result, and the mapping relation between the standard coding and the code to be normalized corresponding to the search result is established.
4. The data code unification method of the hospital heterogeneous system according to claim 3, wherein: the step of the unified coding further comprises manual unification, when the automatic matching of the source data and the index library is unsuccessful, the standard name values corresponding to the standard name fields in the records of the source data are segmented, the segmented words and the query fields are combined into terms according to the query fields designated by a user, the index library is searched to obtain a retrieval result, the retrieval result is inverted according to the similarity matching degree to obtain an optimal result, and the mapping relation of the standard codes and the codes to be unified corresponding to the optimal result is established.
5. The hospital heterogeneous system data code unification method of claim 4, wherein: in the step of unified encoding, the primary keys of the index library and the primary keys of the source data are merged to form a mapping relation.
6. The hospital heterogeneous system data code unification method of claim 4, wherein: the step of unified coding also comprises the step of outputting a comparison result and carrying out platform application.
7. An electronic device, characterized by comprising: a processor;
a memory; and a program, wherein the program is stored in the memory and configured to be executed by the processor, the program comprising instructions for carrying out the method of any one of claims 1-6.
8. A computer-readable storage medium having stored thereon a computer program, characterized in that: the computer program is executed by a processor for performing the method according to any of claims 1-6.
9. The data code unification system of heterogeneous system of hospital, its characterized in that: the method comprises an index base creating module, a source data importing module and a unified coding module; wherein,
the index base creating module is used for importing standard data, standard codes are arranged in the standard data, records in the standard data are read one by one, a standard name value corresponding to a standard name field in the records is subjected to word segmentation to obtain a plurality of word units, the standard name field and the word units are combined to form a plurality of items, a document is built through the plurality of items, the document is stored, and an index base is generated;
the import source data module is used for importing source data and importing the source data of the hospital heterogeneous system, wherein the source data are internally provided with codes to be unified;
the unified coding module is used for matching the source data with the index database and establishing the mapping relation between the standard code and the code to be unified.
10. The data code unification system of the hospital heterogeneous system according to claim 9, wherein: the uniform coding module comprises an automatic uniform submodule, and the automatic uniform submodule is used for segmenting a standard name value corresponding to a standard name field in a record of the source data, combining the segmented word with the standard name field into items, searching the index database to obtain a search result, and establishing a mapping relation between the standard code and a code to be uniform corresponding to the search result;
the unification coding module further comprises a manual unification submodule, and the manual unification submodule is used for segmenting a standard name value corresponding to a standard name field in a record of the source data when the source data is unsuccessfully matched with the index library, combining the segmented word and the query field into an item according to a query field specified by a user, searching the index library to obtain a retrieval result, arranging the retrieval result backwards according to the similarity matching degree to obtain an optimal result, and establishing a mapping relation between the standard code and a code to be unified corresponding to the optimal result.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811636969.2A CN109857736A (en) | 2018-12-29 | 2018-12-29 | The data encoding of hospital's heterogeneous system unitized method and system, equipment, medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811636969.2A CN109857736A (en) | 2018-12-29 | 2018-12-29 | The data encoding of hospital's heterogeneous system unitized method and system, equipment, medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109857736A true CN109857736A (en) | 2019-06-07 |
Family
ID=66893191
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811636969.2A Pending CN109857736A (en) | 2018-12-29 | 2018-12-29 | The data encoding of hospital's heterogeneous system unitized method and system, equipment, medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109857736A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110955753A (en) * | 2019-11-28 | 2020-04-03 | 泰康保险集团股份有限公司 | Data mapping method, device, equipment and storage medium |
| CN111063446A (en) * | 2019-12-17 | 2020-04-24 | 医渡云（北京）技术有限公司 | Method, apparatus, device and storage medium for standardizing medical text data |
| CN111190970A (en) * | 2019-12-27 | 2020-05-22 | 远光软件股份有限公司 | Data mapping method, device and computer readable storage medium |
| CN111625542A (en) * | 2020-05-25 | 2020-09-04 | 泰康保险集团股份有限公司 | Allergy information database establishing method and device, storage medium and electronic equipment |
| CN111797207A (en) * | 2020-07-14 | 2020-10-20 | 山东健康医疗大数据有限公司 | Method for realizing hospital diagnosis data standardization |
| CN111933244A (en) * | 2020-08-17 | 2020-11-13 | 医渡云（北京）技术有限公司 | Medicine data encoding method and device, computer readable medium and electronic equipment |
| CN112069774A (en) * | 2020-09-03 | 2020-12-11 | 微医云(杭州)控股有限公司 | Data mapping method and device, electronic terminal and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6199195B1 (en) * | 1999-07-08 | 2001-03-06 | Science Application International Corporation | Automatically generated objects within extensible object frameworks and links to enterprise resources |
| CN104156415A (en) * | 2014-07-31 | 2014-11-19 | 沈阳锐易特软件技术有限公司 | Mapping processing system and method for solving problem of standard code control of medical data |
| CN105574103A (en) * | 2015-12-11 | 2016-05-11 | 浙江大学 | Method and system for automatically establishing medical term mapping relationship based on word segmentation and coding |
-
2018
- 2018-12-29 CN CN201811636969.2A patent/CN109857736A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6199195B1 (en) * | 1999-07-08 | 2001-03-06 | Science Application International Corporation | Automatically generated objects within extensible object frameworks and links to enterprise resources |
| CN104156415A (en) * | 2014-07-31 | 2014-11-19 | 沈阳锐易特软件技术有限公司 | Mapping processing system and method for solving problem of standard code control of medical data |
| CN105574103A (en) * | 2015-12-11 | 2016-05-11 | 浙江大学 | Method and system for automatically establishing medical term mapping relationship based on word segmentation and coding |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110955753A (en) * | 2019-11-28 | 2020-04-03 | 泰康保险集团股份有限公司 | Data mapping method, device, equipment and storage medium |
| CN110955753B (en) * | 2019-11-28 | 2023-04-18 | 泰康保险集团股份有限公司 | Data mapping method, device, equipment and storage medium |
| CN111063446A (en) * | 2019-12-17 | 2020-04-24 | 医渡云（北京）技术有限公司 | Method, apparatus, device and storage medium for standardizing medical text data |
| CN111190970A (en) * | 2019-12-27 | 2020-05-22 | 远光软件股份有限公司 | Data mapping method, device and computer readable storage medium |
| CN111190970B (en) * | 2019-12-27 | 2023-09-15 | 远光软件股份有限公司 | Data mapping method, device and computer readable storage medium |
| CN111625542A (en) * | 2020-05-25 | 2020-09-04 | 泰康保险集团股份有限公司 | Allergy information database establishing method and device, storage medium and electronic equipment |
| CN111797207A (en) * | 2020-07-14 | 2020-10-20 | 山东健康医疗大数据有限公司 | Method for realizing hospital diagnosis data standardization |
| CN111797207B (en) * | 2020-07-14 | 2024-03-26 | 山东浪潮智慧医疗科技有限公司 | Method for realizing hospital diagnosis data standardization |
| CN111933244A (en) * | 2020-08-17 | 2020-11-13 | 医渡云（北京）技术有限公司 | Medicine data encoding method and device, computer readable medium and electronic equipment |
| CN112069774A (en) * | 2020-09-03 | 2020-12-11 | 微医云(杭州)控股有限公司 | Data mapping method and device, electronic terminal and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109857736A (en) | The data encoding of hospital's heterogeneous system unitized method and system, equipment, medium | |
| CN108920453B (en) | Data processing method and device, electronic equipment and computer readable medium | |
| WO2022121171A1 (en) | Similar text matching method and apparatus, and electronic device and computer storage medium | |
| CN106407443B (en) | Method and device for generating structured medical data | |
| CN110134796B (en) | Knowledge graph-based clinical trial retrieval method, device, computer equipment and storage medium | |
| US9613125B2 (en) | Data store organizing data using semantic classification | |
| US9239872B2 (en) | Data store organizing data using semantic classification | |
| WO2022222943A1 (en) | Department recommendation method and apparatus, electronic device and storage medium | |
| CN108427702B (en) | Target document acquisition method and application server | |
| US20190266158A1 (en) | System and method for optimizing search query to retreive set of documents | |
| US9081847B2 (en) | Data store organizing data using semantic classification | |
| Si et al. | An OMOP CDM-based relational database of clinical research eligibility criteria | |
| WO2022134355A1 (en) | Keyword prompt-based search method and apparatus, and electronic device and storage medium | |
| CN112687364B (en) | Medical data management method and system based on Hbase | |
| Lakshmi et al. | Association rule extraction from medical transcripts of diabetic patients | |
| CN106933859A (en) | The moving method and device of a kind of medical data | |
| CN111986759A (en) | Method and system for analyzing electronic medical record, computer equipment and readable storage medium | |
| CN116737879A (en) | Knowledge base query method and device, electronic equipment and storage medium | |
| US20090234852A1 (en) | Sub-linear approximate string match | |
| JP7211901B2 (en) | Information processing device and information processing method | |
| CN111984745A (en) | Dynamic expansion method, device, equipment and storage medium for database field | |
| CN106933824A (en) | The method and apparatus that the collection of document similar to destination document is determined in multiple documents | |
| CN113343680B (en) | Structured information extraction method based on multi-type medical record text | |
| CN109299238B (en) | Data query method and device | |
| CN113111660A (en) | Data processing method, device, equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190607 |
|
| RJ01 | Rejection of invention patent application after publication |