Medical data acquisition method

Abstract

The embodiment of the invention relates to a medical data collection method, and the method comprises the steps: obtaining the in-table field information of each medical data table in a to-be-collected medical database, and generating a corresponding library information set; according to each table information set and the table association relationship of all the medical data tables, constructing an entity-relation diagram to generate a corresponding data table relation diagram; obtaining a group of field names to be collected; taking the in-table field names which have the same category with the to-be-collected field names and have the highest similarity with the to-be-collected field names as corresponding similar field names; selecting a node path which covers all similar field names and is shortest in length as an optimal full-field node path; constructing a corresponding database query instruction according to the optimal full-field node path; and returning an execution result of the database query instruction in the to-be-collected medical database as a medical data collection result corresponding to the group of to-be-collected field names. According to the invention, the data preprocessing efficiency can be improved, and the medical data query efficiency can also be improved.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method for collecting medical data. Background technique [0002] A large number of medical data tables are stored in the medical databases of various medical institutions. Each medical data table includes multiple fields in the table. The definition of the fields in each table is mainly customized by the hospital, which leads to The definitions of the medical databases, medical data tables, and even the fields in each table of various medical institutions are not standardized, and the associations between various medical data tables are not standardized. [0003] In this case, when a third-party data collection agency (such as a medical insurance agency) collects medical data in the medical database of each medical institution according to the name of the field to be collected, it requires the staff of each medical institution Or the medical database service provider ...

AI Technical Summary

Problems solved by technology

[0004] In the process of processing the above data, we found the following problems: 1) Staff or medical database service providers lacked more effective data comparison and form positioning tools when matching field names to be collected and locating medical data tables, resulting in query The previous data preprocessing efficiency is low; 2) Some collected data can be obtained through different association combinations of medical data tables, which may lead to a decrease in the overall query efficiency of the database due to the use of more complex data table association combinations for query The problem

Images