Changes between Version 20 and Version 21 of i2b2 HowTo Create an Ontology
- Timestamp:
- 06/12/19 11:08:12 (5 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
i2b2 HowTo Create an Ontology
v20 v21 14 14 - `@OntologyDescription` is a short description of the ontology, e.g., 'EMIS Primary Care Data from GEM' 15 15 3. Create records in the table `OntologyUsage` in the `i2b2ClinDataIntegration` database for each study that will use the ontology. The `StudyName` is the unique portion of the i2b2 database names, for example `i2b2_app03_{studyName}_data`. 16 4. Run the command `EXECUTE [i2b2ClinDataIntegration].[dbo].[UpdateOntologyConceptCodes];`17 5. and finally and very importantly add the ontology to the **!OntologyUsage** table (''you mean, like what step 3 tells you to do?'') 16 4. Run the command `EXECUTE [i2b2ClinDataIntegration].[dbo].[dbo.UpdateOntologyConceptCodesInStudy] @StudyName='GENVASC', @Ontology=##;`[[BR]] Or update the whole lot however that take around 20 minute, which can be done with `EXECUTE [i2b2ClinDataIntegration].[dbo].[UpdateOntologyConceptCodes];` 17 18 18 19 19 [[BackLinks]]