OHDSI Home | Forums | Wiki | Github

Is concept_hierarchy table mandatory

webapi
atlas

(Shrikant Kunte) #1
  • I am trying to setup Atlas for my OMOP CDM database.
  • The script for results schema setup is running for almost a week.
  • URL I used to get the script -
http://<server:port>/WebAPI/ddl/results?dialect=<your_cdm_database_dialect>&schema=<your_results_schema>&vocabSchema=<your_vocab_schema>&tempSchema=<your_temp_schema>&initConceptHierarchy=true
  • After some analysis I found that the creation of concept_hierarchy is the reason for script taking so much time to complete the run.
  • What will be the effect on functionality of Atals if I remove concept_hierarchy part by setting initConceptHierarchy = false?
  • Is there any way to find the progress %.

@Chris_Knoll @gregk


(Chris Knoll) #2

You won’t be able to use any of the data-sources functions because the concept_hiearchy is used to provide the hierarchy of concepts on the domain type reports.

Otherwise, if you don’t use DataSources you should be able to start WebAPI without those tables.

However, I have found that the achilles tables do need to be populated due to the ‘record count’ functionality that is provided in the vocabulary search functions, so you should try to at least create the achilles tables in the CDM source your WebAPI references.


t