Medical data supplementing method and device

Abstract

The invention relates to a medical data supplementing method and device. The method is used for supplementing medical data in a secondary list. To-be-supplemented medical data is an outer key of the secondary list and a primary key of a primary list. Additionally, the primary list and the secondary list share a public key. The primary list has a primary list matching field. The secondary list hasa secondary list matching field. The medical data supplementing method comprises the following steps: extracting the public key, the primary key, a collection for distributed Row objects of the primary list from the primary list, wherein the collection for distributed Row objects of the primary list is formed by the primary list matching field; converting the collection for distributed Row objectsof the primary list into a collection for distributed Java objects and representing the public key as a key for the collection for distributed Java objects; aggregating the collection for the distributed Java objects and correspondingly filling the primary key into information required; and supplementing to-be-supplemented medical data of the secondary list with information required through information required by a link of the public key and according to matching nature of the primary list matching field and the secondary list matching field. Therefore, the purpose of utilizing medical datarecorded by the secondary list is fulfilled.

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