This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
documentation:software:atlas:achilles_v_1_5 [2017/10/12 02:38] anthonysena [TL;DR] |
documentation:software:atlas:achilles_v_1_5 [2018/03/12 14:36] (current) anthonysena [Concept Hierarchy] |
||
---|---|---|---|
Line 23: | Line 23: | ||
Achilles will now construct a new table in the results schema labeled ''concept_hierarchy'' using the OMOP vocabulary found in the CDM. This one-time operation is used to optimize query performance when by WebAPI against the ''ACHILLES_results'' table. | Achilles will now construct a new table in the results schema labeled ''concept_hierarchy'' using the OMOP vocabulary found in the CDM. This one-time operation is used to optimize query performance when by WebAPI against the ''ACHILLES_results'' table. | ||
+ | **Please Note**: If you update the vocabulary in your CDM, you should re-create (and re-index) the concept_hierarchy table. | ||
==== Creating the Concept Hierarchy ==== | ==== Creating the Concept Hierarchy ==== | ||
Line 71: | Line 72: | ||
resultsDatabaseSchema <- "my_results_schema_goes_here" | resultsDatabaseSchema <- "my_results_schema_goes_here" | ||
vocabDatabaseSchema <- "my_vocabulary_schema_goes_here" | vocabDatabaseSchema <- "my_vocabulary_schema_goes_here" | ||
+ | db <- "my_cdm_database_name" | ||
achillesResults <- Achilles::achilles(connectionDetails, | achillesResults <- Achilles::achilles(connectionDetails, | ||
cdmDatabaseSchema = cdmDatabaseSchema, | cdmDatabaseSchema = cdmDatabaseSchema, | ||
Line 101: | Line 103: | ||
resultsDatabaseSchema <- "my_results_schema_goes_here" | resultsDatabaseSchema <- "my_results_schema_goes_here" | ||
vocabDatabaseSchema <- "my_vocabulary_schema_goes_here" | vocabDatabaseSchema <- "my_vocabulary_schema_goes_here" | ||
+ | db <- "my_cdm_database_name" | ||
achillesResults <- Achilles::achilles(connectionDetails, | achillesResults <- Achilles::achilles(connectionDetails, | ||
cdmDatabaseSchema = cdmDatabaseSchema, | cdmDatabaseSchema = cdmDatabaseSchema, |