Data import method of clinical data integration technology based on translational medicine analysis platform

Abstract

The invention relates to a data importing method of a clinical data integrating technology based on a translational medicine analysis platform, and belongs to the technical field of data integration. The method is used for importing of text type data and data in a source database, and comprises the following steps: preparing a data file, a column mapping file, a text replacing file and a file used for building a concept tree; building the concept tree, verifying whether data in the column mapping file meets a preset rule or not, reading and processing the data for the first time, building the concept tree again after adding markers of self-defined variables; importing a patient ID (identification), visiting ID data and patient information data into a platform database, carrying out related processing on data exception, network anomaly or platform database system exception. The method has the characteristics that the concept tree is built in a memory on the basis of tranSMART Batch, the self-defined variables are added, and the read-in of the data directly from the database is realized; an exception processing mechanism is added, so that the characteristics of high automation degree and strong adaptive capacity are realized.

Description

technical field [0001] The invention belongs to the technical field of data integration, and particularly relates to the realization of a tranSMART clinical data integration tool with high degree of automation and strong adaptability. Background technique [0002] In recent years, with the introduction of the concept of precision medicine and the vigorous development of related industries, clinical data and genetic data generated in the medical process have been gradually accumulated, and effective analysis of the medical information contained in these data has begun to appear in the medical field. more important. [0003] tranSMART (translational medicine analysis platform) initially provides a data collaborative management platform for pharmaceutical companies and drug research and development organizations. Subsequently, tranSMART was gradually converted to open source software. And the tranSMART Foundation organization will take over for continuous development and main...

AI Technical Summary

Problems solved by technology

cumbersome and error prone

[0023] 2. The data organization form that supports import can only be in the form of the same concept for each column of data

Inability to integrate data organization situations where concepts and values ​​exist in the same row

[0024] 3. The data source supports a single

This method cannot directly extract data from the hospital database

[0025] 4. The exception handling mechanism is missing in the second traversal of the data in the step

Some exceptions that can be skipped will not be skipped, but will directly cause the program to crash

Images