sidataplus / omop-core

Part of OMOP NHSO TCELS project
0 stars 0 forks source link

Create transferable `concept_hierarchy` from Vocab DB to ATLAS DB #41

Open ThanePi opened 1 year ago

ThanePi commented 1 year ago

There is vocab population process which required to complete on vocab DB side as below:

https://github.com/OHDSI/WebAPI/blob/fe070e527abe61a59c42c23e69121f82dff5b4f1/src/main/resources/ddl/results/init_concept_hierarchy.sql

But as purposed ATLAS' backend DB should operate separately from vocab (also CDM) side. It's not possible to inserting data cross database. According to official instruction, this process require human intervention, we may need to create a loader tool for this when concept_hierarchy table was required.

Related discussion: https://forums.ohdsi.org/t/how-to-create-concept-hierarchy/15090