CN109299238B - Data query method and device - Google Patents
Data query method and device Download PDFInfo
- Publication number
- CN109299238B CN109299238B CN201811134133.2A CN201811134133A CN109299238B CN 109299238 B CN109299238 B CN 109299238B CN 201811134133 A CN201811134133 A CN 201811134133A CN 109299238 B CN109299238 B CN 109299238B
- Authority
- CN
- China
- Prior art keywords
- medical
- data
- code
- field
- medical data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Abstract
The application provides a data query method, which comprises the following steps: determining a medical data field contained in a medical data demand and a medical code corresponding to the medical data field based on the medical data demand; querying a field corresponding to the medical data field in a medical database, wherein the medical database comprises a corresponding relation between the field and medical content; if the medical content corresponding to the medical data field is inquired, determining whether the inquired medical content corresponding to the field corresponding to the medical data field contains medical standard terms of the medical code corresponding to the medical data field; and if the queried medical content corresponding to the field corresponding to the medical data field and including at least one medical standard term with codes contains the medical code corresponding to the medical data field, generating a query result based on the medical content containing the medical code.
Description
Technical Field
The application relates to the technical field of medical data analysis, in particular to a data query method and device.
Background
With the development of modern network technology, the retrieval of text data is more accomplished by computer technology. In the conventional search scheme, the following method is also required for searching the literature data related to the clinical trial: firstly, the study direction of the clinical trial is known, and the characteristics of patients or study objects, study contents and the like are clarified; then, the keywords in the medical terms are confirmed, and a large amount of medical data (such as case records, examination report records, and the like) are searched and queried, and after the search result is initially reviewed, the original data is read according to the relevance of the research. Moreover, clinical studies are completed from project establishment to study termination, and similar relevant documents need to be repeatedly searched for many times. However, when the search is performed by the above method, medical cases, report records, and the like need to be acquired from each medical institution, and after the medical cases and the records are acquired, data in the records need to be manually processed, which is troublesome and time-consuming in manual processing, increases processing cost, and the uniformity and accuracy of the processed data are difficult to guarantee due to different medical phrases of different medical institutions, thus increasing the difficulty and cost of the search in the later period.
Disclosure of Invention
In view of the above, an object of the present application is to provide a data query method and apparatus, which are used to solve the problem of low data query efficiency in the prior art.
In a first aspect, an embodiment of the present application provides a data query method, where the method includes:
determining a medical data field contained in a medical data demand and a medical code corresponding to the medical data field based on the medical data demand;
querying a field corresponding to the medical data field in a medical database, wherein the medical database comprises a corresponding relation between the field and medical content, the medical content comprises at least one medical standard term with codes, and the medical database is constructed based on the acquired historical medical heterogeneous source data;
if the medical content corresponding to the medical data field is inquired, determining whether the inquired medical content corresponding to the field corresponding to the medical data field contains medical standard terms of the medical code corresponding to the medical data field;
and if the queried medical content corresponding to the field corresponding to the medical data field and including at least one medical standard term with codes contains the medical code corresponding to the medical data field, generating a query result based on the medical content containing the medical code.
Optionally, the determining, based on the medical data requirement, a medical data field included in the medical data requirement, and a medical code corresponding to the medical data field, includes:
determining the medical data field and a medical data term corresponding to the medical data field based on the medical data requirement of the user;
and determining a code corresponding to the medical data term according to the determined medical data term and the corresponding relation between the preset medical term and the code, and taking the determined code as the medical code.
Optionally, the medical database is built based on the following method:
extracting fields for constructing the medical database from the medical related data;
and constructing the medical database based on the extracted fields, the historical medical heterogeneous source data, a preset medical comparison table and a preset mapping algorithm.
Optionally, the constructing the medical database based on the extracted fields, the historical medical heterogeneous source data, and a preset medical comparison table and a preset mapping algorithm includes:
extracting at least one medical vocabulary corresponding to the extracted field and corresponding structural information from the historical medical heterogeneous source data;
determining a medical standard term with codes corresponding to each medical vocabulary based on the extracted at least one medical vocabulary and the medical reference table, wherein the medical reference table comprises corresponding relations between the medical vocabularies and the medical standard terms with codes;
and taking the medical standard terms with codes and the corresponding structural information as medical contents, and mapping the medical contents to fields of the medical database by using the mapping algorithm to complete the construction of the medical database.
Optionally, the generating a query result based on the medical content containing the medical code includes:
selecting content meeting time requirements in the medical data requirements from medical content containing the medical codes as a query result; alternatively, the first and second electrodes may be,
sequencing the medical contents from far to near according to time, and taking a front preset number of contents in front of the sequencing as a query result; alternatively, the first and second electrodes may be,
and taking the medical content with the farthest characteristic time as a query result.
In a second aspect, an embodiment of the present application provides a data query apparatus, where the method includes:
the medical data processing system comprises a first determining module, a second determining module and a processing module, wherein the first determining module is used for determining a medical data field contained in a medical data demand and a medical code corresponding to the medical data field based on the medical data demand;
the query module is used for querying a field corresponding to the medical data field in a medical database, the medical database comprises a corresponding relation between the field and medical content, the medical content comprises at least one medical standard term with codes, and the medical database is constructed based on acquired historical medical heterogeneous source data;
the second determination module is used for determining whether the medical standard terms of the medical codes corresponding to the medical data fields are contained in the medical contents corresponding to the fields corresponding to the medical data fields if the medical contents corresponding to the medical data fields are inquired;
and the generating module is used for generating a query result based on the medical content containing the medical code if the medical code corresponding to the medical data field is contained in the queried medical content corresponding to the field corresponding to the medical data field and including at least one medical standard term with the code.
Optionally, the first determining module is specifically configured to:
determining the medical data field and a medical data term corresponding to the medical data field based on the medical data requirement of the user;
and determining a code corresponding to the medical data term according to the determined medical data term and the corresponding relation between the preset medical term and the code, and taking the determined code as the medical code.
Optionally, the method further comprises: a build module to:
extracting fields for constructing the medical database from the medical related data;
and constructing the medical database based on the extracted fields, the historical medical heterogeneous source data, a preset medical comparison table and a preset mapping algorithm.
In a third aspect, embodiments of the present application provide a computer device including a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor implements the steps of the method when executing the computer program.
In a fourth aspect, the present application provides a computer-readable storage medium, on which a computer program is stored, and the computer program, when executed by a processor, performs the steps of the above method.
According to the data query method and device provided by the embodiment of the application, according to medical data requirements, medical data fields contained in the medical data requirements and medical codes corresponding to the medical data fields are determined, the fields corresponding to the medical data fields are queried in a medical database, if medical contents corresponding to the medical data fields are queried, whether medical standard terms of the medical codes corresponding to the medical data fields are contained in the queried medical contents corresponding to the fields corresponding to the medical data fields, and if the medical codes corresponding to the medical data fields are contained in the queried medical contents including at least one medical standard term with codes, query results are generated based on the medical contents containing the medical codes. The medical database is constructed according to historical medical heterogeneous source data, so that a user can conveniently and rapidly inquire data, an inquiry result is easily obtained, the inquiry efficiency is improved, the research cost of research based on the inquiry result is reduced, and the research efficiency is improved.
In order to make the aforementioned objects, features and advantages of the present application more comprehensible, preferred embodiments accompanied with figures are described in detail below.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are required to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present application and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained from the drawings without inventive effort.
Fig. 1 is a schematic flowchart of a data query method provided in an embodiment of the present application;
FIG. 2 is a schematic diagram of a first structure of a data query device according to an embodiment of the present application;
fig. 3 is a schematic diagram of a second structure of a data query device according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of a computer device 400 according to an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all the embodiments. The components of the embodiments of the present application, generally described and illustrated in the figures herein, can be arranged and designed in a wide variety of different configurations. Thus, the following detailed description of the embodiments of the present application, presented in the accompanying drawings, is not intended to limit the scope of the claimed application, but is merely representative of selected embodiments of the application. All other embodiments, which can be derived by a person skilled in the art from the embodiments of the present application without making any creative effort, shall fall within the protection scope of the present application.
An embodiment of the present application provides a data query method, as shown in fig. 1, which is applied to a data query system, where the data query system includes a terminal device, such as: computers, notebook computers, tablet computers, mobile phones, portable devices, in-vehicle devices, etc., also include network systems, such as: an audiovisual service system, a large screen system, a client/server system (C/S), a browser/server system, a cloud computing system, and so forth. The type and architecture of the data query system is not limited herein. The method comprises the following steps: the method comprises the following steps:
s101, determining a medical data field contained in a medical data demand and a medical code corresponding to the medical data field based on the medical data demand;
here, the medical data requirement may be input by the user through a browser in the computer device, or may be obtained through a questionnaire reported by the user, which is not limited in the present application; the medical data field may be, but is not limited to, an outpatient service, a chief complaint, and the like, the medical code represents a number of the medical term, different medical terms correspond to different medical codes, that is, the code of each medical term is unique, the code of the medical term may be set for the medical term according to a preset rule, and the preset rule may be to code the medical term according to an initial letter of the medical term, which is not limited in this application.
When the medical data field contained in the medical data requirement and the medical code corresponding to the medical data field are determined based on the medical data requirement, the method comprises the following steps:
determining the medical data field and a medical data term corresponding to the medical data field based on the medical data requirement of the user;
and determining a code corresponding to the medical data term according to the determined medical data term and the corresponding relation between the preset medical term and the code, and taking the determined code as the medical code.
Here, the medical vocabulary may be a vocabulary commonly used by medical staff, and the medical data term may be a professional descriptor of the medical vocabulary in the medical field, for example, the medical vocabulary may be painful for the stomach, and the medical data term corresponding to the medical vocabulary may be abdominal pain; the medical data term may include medical data requirements, or may be derived from a medical data field included in the medical data requirements, which is not limited in this application; the code may be, but is not limited to, numbers, letters, etc., which are not limited in this application.
In a specific implementation, after receiving a medical data requirement of a user, a medical data field and a corresponding medical data term may be extracted from the medical data requirement, or after a medical data field and a corresponding medical data term are extracted from the medical data requirement, further, the extracted medical data term may be expanded based on medical data.
After determining the medical query term, the medical code may be determined by one or a combination of the following:
case (1): determining a code corresponding to the extracted medical data term according to the extracted medical data term and the corresponding relation between the preset medical term and the code, and taking the determined code as the medical code of the extracted medical data term;
case (2): and determining the code corresponding to the expanded medical data term according to the expanded medical data term and the corresponding relation between the preset medical term and the code, and taking the determined code as the medical code of the expanded medical data term.
When the query is performed, the query may be performed by combining only the extracted medical data field with the extracted medical data term, or may be performed by combining only the expanded medical data term with the extracted medical data field, or may be performed by combining the extracted medical data field with the extracted medical data term, or may be performed by combining the extracted medical data field with the expanded medical data term. In practical applications, in order to improve the accuracy of the query result, the extracted medical data field is generally combined with the extracted medical data term, and the extracted medical data field is combined with the expanded medical data term to perform the query.
For example, the medical data requirement input by the user may be "time of first anticoagulation treatment", the determined medical data field may be "time of first anticoagulation treatment", the medical data term corresponding to the medical data field may be "anticoagulation treatment", the medical data term after anticoagulation treatment is expanded may be a drug related to anticoagulation treatment, the drug related to anticoagulation treatment includes parenteral anticoagulant, coumarin anticoagulant, and the like, after the medical data field is obtained, the code of each medical data term may be determined from the table of the comparison of the terms and the codes, the finally obtained medical term code of anticoagulation treatment is a, the medical term code of parenteral anticoagulant is B, and the medical term code of coumarin anticoagulant is C. In making the query, the medical data field may be queried for the "time to first anticoagulation therapy" in combination with the medical term code A, B, C.
S102, inquiring fields corresponding to the medical data fields in a medical database, wherein the medical database comprises corresponding relations between the fields and medical contents, the medical contents comprise at least one medical standard term with codes, and the medical database is constructed based on acquired historical medical heterogeneous source data;
here, the historical medical heterogeneous source data may be acquired from a preset platform, and the preset platform may be a hospital database, a hospital case management platform, a hospital examination report management platform, or the like, which is not limited in the present application; the historical heterogeneous source data comprises a plurality of medical vocabularies, medical institution information and the like, the historical heterogeneous source data can be document data, result report data, record data and the like, the text can be outpatient medical records, emergency treatment records, admission records, medical record head pages, consultation records, transfer records, course records, informed consent forms, operation reports, operation records, discharge records and the like, the result report can comprise examination reports (comprising electrocardiograms, CTs, ultrasounds, nuclear magnetic resonances and the like), examination reports (blood test reports and the like), operation reports, nursing records and the like, and the record can comprise 120 records, an ambulance-mounted time node registration table, a time node management table, rescue records, death records and the like.
The medical database is pre-constructed and can be constructed according to the following method:
extracting fields for constructing the medical database from the medical related data;
and constructing the medical database based on the extracted fields, the historical medical heterogeneous source data, a preset medical comparison table and a preset mapping algorithm.
When the medical database is constructed based on the extracted fields, the historical medical heterogeneous source data, a preset medical comparison table and a preset mapping algorithm, the method comprises the following steps:
extracting at least one medical vocabulary corresponding to the extracted field and corresponding structural information from the historical medical heterogeneous source data;
determining a medical standard term with codes corresponding to each medical vocabulary based on the extracted at least one medical vocabulary and the medical reference table, wherein the medical reference table comprises corresponding relations between the medical vocabularies and the medical standard terms with codes;
and taking the medical standard terms with codes and the corresponding structural information as medical contents, and mapping the medical contents to fields of the medical database by using the mapping algorithm to complete the construction of the medical database.
Here, the medical related data may be, but is not limited to, the national standard "WST 500-2016 electronic medical record shared document specification", medical data obtained from various medical structures, and the like, which is not limited in this application; the method for extracting the field is described in detail in the prior art, and is not described more than fully here; since the recording forms or methods of the historical medical heterogeneous source data of each medical institution are different, the medical vocabulary in the historical medical heterogeneous source data needs to be normalized, that is, different medical vocabularies representing the same meaning are unified into standard medical data, based on which a medical vocabulary comparison table is preset, the medical terms in the medical vocabulary comparison table can be set according to the national standard WST500-2016 electronic medical record shared document specification, and the codes can be set according to the clinical medical term standard (SNOMED-CT).
In a specific implementation, after the historical medical heterogeneous source data is acquired, the content capable of corresponding to the determined field can be extracted from the historical medical heterogeneous source data, the determined content comprises at least one medical vocabulary and corresponding structural information, whether the medical vocabulary contained in each extracted content is a medical term or not is judged, and if the medical vocabulary contained in each extracted content is not a medical term, the medical vocabulary contained in the content of which the medical vocabulary is not a medical term is replaced by the medical standard term with the code according to the corresponding relationship between the medical vocabulary in the preset medical vocabulary comparison table and the medical standard term with the code. After one or more medical standard terms with codes are obtained, the obtained medical standard data with codes and corresponding structured information are used as medical contents and correspondingly added to the fields in the medical database, wherein the medical contents corresponding to each field can be numbered according to the adding time, the structured information in each content can include time information, and the time information can be the time larger than a preset time threshold value
For example, the fields in the medical database may be chief complaints, outpatients, etc., and the historical medical heterogeneous source data is "main problem in outpatient records: the three days of belly pain, the medical vocabulary contained in the historical medical heterogeneous source data is 'belly pain', the content in the outpatient service record corresponds to the main problem, so the medical vocabulary corresponds to the main complaint field in the medical database, the content corresponding to the main complaint field is 'three days of belly pain', the structured information is three days, the medical terminology corresponding to the 'belly pain' medical vocabulary is determined to be 'bellyache' including the code I of bellyache by referring to the medical vocabulary comparison table, and the medical content corresponding to the main complaint field of the medical institution in the generated medical database is 'three days I'.
After the historical medical heterogeneous source data is obtained, the historical medical heterogeneous source data can be filtered through a preset filtering rule, and the filtered historical heterogeneous source data is subjected to completion processing according to a preset data completion rule.
Specifically, since the historical medical heterogeneous source data includes a plurality of fields and a plurality of medical vocabularies, some of the fields or medical vocabularies belong to redundant fields and redundant medical vocabularies for the present application, a plurality of filtering keywords may be set in the filtering rule, each filtering keyword corresponds to one redundant field or redundant medical vocabulary, and data corresponding to each filtering keyword is filtered. The historical medical heterogeneous source data may have a data loss phenomenon in the acquisition process, so that the filtered historical medical heterogeneous source data is supplemented, and when the historical medical heterogeneous source data is supplemented, the historical medical heterogeneous source data can be supplemented according to experience recorded in medical related data, and the historical medical heterogeneous source data can also be supplemented through a preset value, which is not limited by the application.
S103, if the medical content corresponding to the medical data field is inquired, determining whether the inquired medical content corresponding to the field corresponding to the medical data field contains the medical standard term of the medical code corresponding to the medical data field;
and S104, if the medical code corresponding to the medical data field is contained in the queried medical content corresponding to the field corresponding to the medical data field and including at least one medical standard term with the code, generating a query result based on the medical content containing the medical code.
When generating the query result based on the medical content containing the medical code, the method comprises the following steps:
selecting content meeting the time requirement in the medical data query request from the content containing the medical term codes as a query result; alternatively, the first and second electrodes may be,
sequencing the inquired contents from far to near according to time, and taking the front preset number of contents before training as an inquiry result; alternatively, the first and second electrodes may be,
and taking the content of the query with the farthest characteristic time as a query result.
Here, since there is more than one medical content containing the medical code, in order to generate a query result in a targeted manner, the queried medical contents may be sorted in the order from far to near according to time, the top preset number of the sorted medical contents is used as a query result, and the queried content with the farthest time may also be used as a query result; the medical data requirements may carry time requirements, if the medical data requirements carry the time requirements, contents meeting the time requirements are selected from the inquired medical contents as inquiry results, if the medical data requirements do not have the time requirements, the inquired contents are sorted according to the time sequence, and selection is performed based on the sorting results.
For example, the medical data request issued by the user is "time to start anticoagulation therapy", and since the data query request includes "time to start … …", that is, the time request is the earliest anticoagulation therapy time, after obtaining a plurality of query contents, the medical contents meeting the time request are used as query results, that is, the earliest anticoagulation therapy time of the queried contents is determined as the query results and returned to the user.
An embodiment of the present application provides a data query apparatus, as shown in fig. 2, the apparatus includes:
the first determining module 21 is configured to determine, based on a medical data requirement, a medical data field included in the medical data requirement and a medical code corresponding to the medical data field;
the query module 22 is configured to query a field corresponding to the medical data field in a medical database, where the medical database includes a corresponding relationship between the field and medical content, the medical content includes at least one medical standard term with a code, and the medical database is constructed based on the acquired historical medical heterogeneous source data;
a second determining module 23, configured to determine, if the medical content corresponding to the medical data field is queried, whether the queried medical content corresponding to the field corresponding to the medical data field includes a medical standard term of the medical code corresponding to the medical data field;
and the generating module 24 is configured to generate a query result based on the medical content including the medical code if it is determined that the queried medical content including at least one medical standard term with the code, which corresponds to the field corresponding to the medical data field, includes the medical code corresponding to the medical data field.
Optionally, the first determining module 21 is specifically configured to:
determining the medical data field and a medical data term corresponding to the medical data field based on the medical data requirement of the user;
and determining a code corresponding to the medical data term according to the determined medical data term and the corresponding relation between the preset medical term and the code, and taking the determined code as the medical code.
Optionally, the generating module 24 is specifically configured to:
selecting content meeting time requirements in the medical data requirements from medical content containing the medical codes as a query result; alternatively, the first and second electrodes may be,
sequencing the medical contents from far to near according to time, and taking a front preset number of contents in front of the sequencing as a query result; alternatively, the first and second electrodes may be,
and taking the medical content with the farthest characteristic time as a query result.
An embodiment of the present application provides a data query apparatus, as shown in fig. 3, where the apparatus in the figure further includes, compared with the apparatus in fig. 2: a building module 25, the building module 25 being configured to:
extracting fields for constructing the medical database from the medical related data;
and constructing the medical database based on the extracted fields, the historical medical heterogeneous source data, a preset medical comparison table and a preset mapping algorithm.
Optionally, the building module 25 is specifically configured to:
extracting at least one medical vocabulary corresponding to the extracted field and corresponding structural information from the historical medical heterogeneous source data;
determining a medical standard term with codes corresponding to each medical vocabulary based on the extracted at least one medical vocabulary and the medical reference table, wherein the medical reference table comprises corresponding relations between the medical vocabularies and the medical standard terms with codes;
and taking the medical standard terms with codes and the corresponding structural information as medical contents, and mapping the medical contents to fields of the medical database by using the mapping algorithm to complete the construction of the medical database.
Corresponding to the data query method in fig. 1, an embodiment of the present application further provides a computer device 400, as shown in fig. 4, the device includes a memory 401, a processor 402, and a computer program stored on the memory 401 and executable on the processor 402, where the processor 402 implements the data query method when executing the computer program.
Specifically, the memory 401 and the processor 402 can be general memories and processors, which are not specifically limited herein, and when the processor 402 runs a computer program stored in the memory 401, the data query method can be executed, so as to solve the problem of low data query efficiency in the prior art, in the present application, according to a medical data requirement, a medical data field included in the medical data requirement and a medical code corresponding to the medical data field are determined, a field corresponding to the medical data field is queried in a medical database, if a medical content corresponding to the medical data field is queried, it is determined whether a medical standard term of the medical code corresponding to the medical data field is included in the queried medical content corresponding to the field corresponding to the medical data field, and if it is determined that the queried medical content corresponding to the field corresponding to the medical data field and including at least one medical standard term with a code includes the medical standard term included in the medical content corresponding to the medical data field And generating a query result based on the medical content containing the medical code by using the medical code corresponding to the medical data field. The medical database is constructed according to historical medical heterogeneous source data, so that a user can conveniently and rapidly inquire data, an inquiry result is easily obtained, the inquiry efficiency is improved, the research cost of research based on the inquiry result is reduced, and the research efficiency is improved.
Corresponding to the data query method in fig. 1, an embodiment of the present application further provides a computer-readable storage medium, on which a computer program is stored, and the computer program is executed by a processor to perform the steps of the data query method.
Specifically, the storage medium can be a general storage medium, such as a mobile disk, a hard disk, and the like, and when a computer program on the storage medium is executed, the data query method can be executed, so as to solve the problem of low data query efficiency in the prior art Then a query result is generated based on the medical content containing the medical code. The medical database is constructed according to historical medical heterogeneous source data, so that a user can conveniently and rapidly inquire data, an inquiry result is easily obtained, the inquiry efficiency is improved, the research cost of research based on the inquiry result is reduced, and the research efficiency is improved.
In the embodiments provided in the present application, it should be understood that the disclosed system and method may be implemented in other ways. The above-described system embodiments are merely illustrative, and for example, the division of the units is only one logical functional division, and there may be other divisions in actual implementation, and for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection of systems or units through some communication interfaces, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments provided in the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit.
The functions, if implemented in the form of software functional units and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application or portions thereof that substantially contribute to the prior art may be embodied in the form of a software product stored in a storage medium and including instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus once an item is defined in one figure, it need not be further defined and explained in subsequent figures, and moreover, the terms "first", "second", "third", etc. are used merely to distinguish one description from another and are not to be construed as indicating or implying relative importance.
Finally, it should be noted that: the above-mentioned embodiments are only specific embodiments of the present application, and are used for illustrating the technical solutions of the present application, but not limiting the same, and the scope of the present application is not limited thereto, and although the present application is described in detail with reference to the foregoing embodiments, those skilled in the art should understand that: any person skilled in the art can modify or easily conceive the technical solutions described in the foregoing embodiments or equivalent substitutes for some technical features within the technical scope disclosed in the present application; such modifications, changes or substitutions do not depart from the spirit and scope of the present disclosure, which should be construed in light of the above teachings. Are intended to be covered by the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.
Claims (8)
1. A method for querying data, the method comprising:
determining a medical data field contained in a medical data demand and a medical code corresponding to the medical data field based on the medical data demand;
extracting fields for constructing a medical database from the medical data; constructing the medical database based on the extracted fields, historical medical heterogeneous source data, a preset medical comparison table and a preset mapping algorithm;
querying a field corresponding to the medical data field in the medical database, wherein the medical database comprises a corresponding relation between the field and medical content, and the medical content comprises at least one medical standard term with codes;
if the medical content corresponding to the medical data field is inquired, determining whether the inquired medical content corresponding to the field corresponding to the medical data field contains medical standard terms of the medical code corresponding to the medical data field;
and if the queried medical content corresponding to the field corresponding to the medical data field and including at least one medical standard term with codes contains the medical code corresponding to the medical data field, generating a query result based on the medical content containing the medical code.
2. The method of claim 1, wherein the determining a medical data field included in the medical data requirement based on the medical data requirement, and the medical code corresponding to the medical data field comprises:
determining the medical data fields and medical data terms corresponding to the medical data fields based on medical data requirements of users;
and determining a code corresponding to the medical data term according to the determined medical data term and the corresponding relation between the preset medical term and the code, and taking the determined code as the medical code.
3. The method of claim 1, wherein the constructing the medical database based on the extracted fields, the historical medical heterogeneous source data, and a preset medical look-up table and a preset mapping algorithm comprises:
extracting at least one medical vocabulary corresponding to the extracted field and corresponding structural information from the historical medical heterogeneous source data;
determining a medical standard term with codes corresponding to each medical vocabulary based on the extracted at least one medical vocabulary and the medical reference table, wherein the medical reference table comprises corresponding relations between the medical vocabularies and the medical standard terms with codes;
and taking the medical standard terms with codes and the corresponding structural information as medical contents, and mapping the medical contents to fields of the medical database by using the mapping algorithm to complete the construction of the medical database.
4. The method of claim 1, wherein generating query results based on the medical content comprising the medical code comprises:
selecting content meeting time requirements in the medical data requirements from medical content containing the medical codes as a query result; alternatively, the first and second electrodes may be,
sequencing the medical contents from far to near according to time, and taking a front preset number of contents in front of the sequencing as a query result; alternatively, the first and second electrodes may be,
and taking the medical content with the farthest characteristic time as a query result.
5. A data query apparatus, comprising:
the medical data processing system comprises a first determining module, a second determining module and a processing module, wherein the first determining module is used for determining a medical data field contained in a medical data demand and a medical code corresponding to the medical data field based on the medical data demand;
a build module to: extracting fields for constructing a medical database from the medical related data; constructing the medical database based on the extracted fields, historical medical heterogeneous source data, a preset medical comparison table and a preset mapping algorithm
The query module is used for querying a field corresponding to the medical data field in a medical database, the medical database comprises a corresponding relation between the field and medical content, the medical content comprises at least one medical standard term with codes, and the medical database is constructed based on acquired historical medical heterogeneous source data;
the second determination module is used for determining whether the medical standard terms of the medical codes corresponding to the medical data fields are contained in the medical contents corresponding to the fields corresponding to the medical data fields if the medical contents corresponding to the medical data fields are inquired;
and the generating module is used for generating a query result based on the medical content containing the medical code if the medical code corresponding to the medical data field is contained in the queried medical content corresponding to the field corresponding to the medical data field and including at least one medical standard term with the code.
6. The apparatus of claim 5, wherein the first determining module is specifically configured to:
determining the medical data fields and medical data terms corresponding to the medical data fields based on medical data requirements of users;
and determining a code corresponding to the medical data term according to the determined medical data term and the corresponding relation between the preset medical term and the code, and taking the determined code as the medical code.
7. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the steps of the method of any of the preceding claims 1 to 4 are implemented by the processor when executing the computer program.
8. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method according to any one of the claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811134133.2A CN109299238B (en) | 2018-09-27 | 2018-09-27 | Data query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811134133.2A CN109299238B (en) | 2018-09-27 | 2018-09-27 | Data query method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109299238A CN109299238A (en) | 2019-02-01 |
| CN109299238B true CN109299238B (en) | 2020-12-08 |
Family
ID=65164420
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811134133.2A Active CN109299238B (en) | 2018-09-27 | 2018-09-27 | Data query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109299238B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111883224A (en) * | 2020-07-01 | 2020-11-03 | 金蝶医疗软件科技有限公司 | Electronic medical record processing method and device, computer equipment and storage medium |
| CN112052246B (en) * | 2020-09-29 | 2023-11-24 | 泰康保险集团股份有限公司 | Medical data processing apparatus and medical data processing method |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1987861A (en) * | 2005-12-22 | 2007-06-27 | 国际商业机器公司 | System and method for processing database query |
| CN102054032A (en) * | 2010-12-22 | 2011-05-11 | 广州市慧通计算机有限公司 | Medical data information processing method and system |
| CN105574103A (en) * | 2015-12-11 | 2016-05-11 | 浙江大学 | Method and system for automatically establishing medical term mapping relationship based on word segmentation and coding |
| CN105868539A (en) * | 2016-03-24 | 2016-08-17 | 苏州麦迪斯顿医疗科技股份有限公司 | A multimedia medical data indexing method and device |
| CN106845056A (en) * | 2015-12-04 | 2017-06-13 | 北大医疗信息技术有限公司 | The integration method and integrating apparatus of medical information |
| CN106919793A (en) * | 2017-02-24 | 2017-07-04 | 黑龙江特士信息技术有限公司 | A kind of data standardization processing method and device of medical big data |
| CN107766574A (en) * | 2017-11-13 | 2018-03-06 | 天津开心生活科技有限公司 | Data query method and device, date storage method and device |
| CN107798026A (en) * | 2016-09-05 | 2018-03-13 | 北京京东尚科信息技术有限公司 | Data query method and apparatus |
| CN108133756A (en) * | 2017-12-26 | 2018-06-08 | 医渡云（北京）技术有限公司 | Medical data searching method and device, storage medium, electronic equipment |
-
2018
- 2018-09-27 CN CN201811134133.2A patent/CN109299238B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1987861A (en) * | 2005-12-22 | 2007-06-27 | 国际商业机器公司 | System and method for processing database query |
| CN102054032A (en) * | 2010-12-22 | 2011-05-11 | 广州市慧通计算机有限公司 | Medical data information processing method and system |
| CN106845056A (en) * | 2015-12-04 | 2017-06-13 | 北大医疗信息技术有限公司 | The integration method and integrating apparatus of medical information |
| CN105574103A (en) * | 2015-12-11 | 2016-05-11 | 浙江大学 | Method and system for automatically establishing medical term mapping relationship based on word segmentation and coding |
| CN105868539A (en) * | 2016-03-24 | 2016-08-17 | 苏州麦迪斯顿医疗科技股份有限公司 | A multimedia medical data indexing method and device |
| CN107798026A (en) * | 2016-09-05 | 2018-03-13 | 北京京东尚科信息技术有限公司 | Data query method and apparatus |
| CN106919793A (en) * | 2017-02-24 | 2017-07-04 | 黑龙江特士信息技术有限公司 | A kind of data standardization processing method and device of medical big data |
| CN107766574A (en) * | 2017-11-13 | 2018-03-06 | 天津开心生活科技有限公司 | Data query method and device, date storage method and device |
| CN108133756A (en) * | 2017-12-26 | 2018-06-08 | 医渡云（北京）技术有限公司 | Medical data searching method and device, storage medium, electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109299238A (en) | 2019-02-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10902076B2 (en) | Ranking and recommending hashtags | |
| Pathak et al. | Mapping clinical phenotype data elements to standardized metadata repositories and controlled terminologies: the eMERGE Network experience | |
| US20190035506A1 (en) | Intelligent auxiliary diagnosis method, system and machine-readable medium thereof | |
| US10878010B2 (en) | System and method for clinical trial candidate matching | |
| Fatehi et al. | How to improve your PubMed/MEDLINE searches: 3. advanced searching, MeSH and My NCBI | |
| WO2009037615A1 (en) | System and method for analyzing electronic data records | |
| Jimeno-Yepes et al. | GeneRIF indexing: sentence selection based on machine learning | |
| US20150227714A1 (en) | Medical information analysis apparatus and medical information analysis method | |
| JP2011233162A (en) | System, method, and software for assessing ambiguity of medical terms | |
| Hersh | Information retrieval and digital libraries | |
| Kılınç | An accurate toponym-matching measure based on approximate string matching | |
| CN113409907A (en) | Intelligent pre-inquiry method and system based on Internet hospital | |
| Xu et al. | Healthcare data analytics: Using a metadata annotation approach for integrating electronic hospital records | |
| CN110752027B (en) | Electronic medical record data pushing method, device, computer equipment and storage medium | |
| CN109299238B (en) | Data query method and device | |
| CN112837772A (en) | Pre-inquiry case history generation method and device | |
| CN111785383A (en) | Data processing method and related equipment | |
| CN110245242B (en) | Medical knowledge graph construction method and device and terminal | |
| CN111052259A (en) | On-device search using medical term expressions | |
| CN111095239A (en) | Techniques for anonymous search of medical providers | |
| Hom et al. | Facilitating clinical research through automation: Combining optical character recognition with natural language processing | |
| CN111091883A (en) | Medical text processing method and device, storage medium and equipment | |
| Lin et al. | An exploratory study using an openEHR 2-level modeling approach to represent common data elements | |
| Fatehi et al. | How to improve your PubMed/MEDLINE searches: 1. background and basic searching | |
| CN107609017B (en) | Method and system for realizing intelligent search and consultation of medical industry through self-defined hot words |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |