Changes between Version 14 and Version 15 of i2b2 HowTo Create an Ontology

Timestamp:

12/14/15 12:16:05 (9 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 HowTo Create an Ontology

@@ -18 +18 @@
   - `@MetaDatabaseName` is the name of the i2b2 meta database where the ontology should be created, e.g., 'project_MetaData'
   - `@DataDatabaseName` is the name of the i2b2 data database where the ontology should be created, e.g., 'project_Data'
+4. Amend the stored procedure `[dbo].[LoadAllOntologiesIntoConceptDimension]` in the i2b2 data database to add the import of the codes into the `concept_dimension`.
+ - The line should be of the form: `EXEC dbo.LoadOntologyIntoConceptDimension {Ontology ID};`, where `OntologyID` is the ID of the ontology created above.
+5. Create a stored procedure to import the ontology codes into the i2b2 meta database.  The procedure should follow the form:
+{{{
+CREATE PROC [dbo].[Update{Ontology Name}] AS
+DELETE FROM dbo.{Ontology Table Name};
+
+INSERT INTO     dbo.{Ontology Table Name}
+SELECT [C_HLEVEL]
+      ,[C_FULLNAME]
+      ,[C_NAME]
+      ,[C_SYNONYM_CD]
+      ,[C_VISUALATTRIBUTES]
+      ,[C_TOTALNUM]
+      ,[C_BASECODE]
+      ,[C_METADATAXML]
+      ,[C_FACTTABLECOLUMN]
+      ,[C_TABLENAME]
+      ,[C_COLUMNNAME]
+      ,[C_COLUMNDATATYPE]
+      ,[C_OPERATOR]
+      ,[C_DIMCODE]
+      ,[C_COMMENT]
+      ,[C_TOOLTIP]
+      ,[UPDATE_DATE]
+      ,[DOWNLOAD_DATE]
+      ,[IMPORT_DATE]
+      ,[SOURCESYSTEM_CD]
+      ,[VALUETYPE_CD]
+          ,[m_applied_path]
+          ,[m_exclusive_cd]
+          ,[C_PATH]
+          ,[C_SYMBOL]
+  FROM [i2b2ClinDataIntegration].[dbo].[i2b2Ontology]
+  WHERE OntologyID = {Ontology ID}
+}}}
+ - Where:
+  - `Ontology Name` is the name used for the ontology above
+  - `Ontology Table Name` is the name of the ontology table created in the i2b2 meta database.
+  - `OntologyID` is the ID of the ontology created above
 
 [[BackLinks]]