Medical data supplement method and device

Abstract

The present disclosure relates to a medical data supplement method and a medical data supplement device. This method supplements the medical data from the slave table. The medical data to be supplemented is the foreign key of the slave table and the primary key of the master table, and the master table and the slave table hold a common key, the master table holds the matching fields of the master table, and the slave table holds There is a matching field from the table; the medical data supplement method includes: extracting the public key, the primary key and the matching field of the main table from the main table to form a collection of distributed Row objects of the main table; the collection of distributed Row objects of the main table Convert to a collection of distributed Java objects, and use the public key as the key of the collection of distributed Java objects; aggregate the collection of distributed Java objects according to the public key, and fill in the required information corresponding to the primary key; The required information is linked through the public key, and the required information is supplemented to the medical data to be supplemented in the secondary table according to the matching field of the primary table and the matching field of the secondary table. Make the medical data recorded from the form available for the purpose.

Description

technical field [0001] The present disclosure relates to the field of computer technology, and in particular, to a medical data supplement method and a medical data supplement device. Background technique [0002] ETL is the abbreviation of Extract-Transform-Load in English, which is used to describe the process of extracting, transforming, and loading data from the source to the destination. In the process of data extraction by ETL, due to the system defects of the metadata itself, some data fields may be missing. If the missing data fields are very important, a large amount of data may not be effectively used. [0003] For example, in the actual medical system, inspection (including pathology, radiation, echocardiography, etc.) data and laboratory test (blood test, urine test, etc.) data only record the patient ID, not the visit ID, which will affect the medical data. Scientific research is very inconvenient, because medical data scientific research needs to take medical ...

AI Technical Summary

Problems solved by technology

In the process of extracting data by ETL, due to the system defects of metadata itself, some data fields may be missing. If the missing data fields are very important, a large amount of data may not be effectively utilized.

[0003] For example, in the actual medical system, inspection (including pathology, radiation, echocardiography, etc.) data and laboratory test (blood test, urine test, etc.) data only record the patient ID, not the visit ID, which will affect the medical data. Scientific research has caused great inconvenience, because medical data scientific research needs to take the visit as the granularity, and study the relationship between the inspection data and the diagnosis and treatment of admission and discharge during each visit

Images