Ontology scripts
ontology_create_user.sql - Creates the shrine_ont user, for loading the SHRINE ontology
ontology_create_tables.sql - Creates shrine_ont, creates SHRINE, TABLE_ACCESS, and SCHEMES tables, and sets up schemas within tables.
DB_Lookups script to add ontology to i2b2hive
- ontology_create_user.sql
- ontology_create_tables.sql
- db_lookups.sql
ontology table access
INSERT into {{ shrine_i2b2_ont.schema }}.TABLE_ACCESS
( C_TABLE_CD,
C_TABLE_NAME,
C_PROTECTED_ACCESS,
C_HLEVEL,
C_NAME,
C_FULLNAME,
C_SYNONYM_CD,
C_VISUALATTRIBUTES,
C_TOOLTIP,
C_FACTTABLECOLUMN,
C_DIMTABLENAME,
C_COLUMNNAME,
C_COLUMNDATATYPE,
C_DIMCODE,
C_OPERATOR)
values
( 'SHRINE',
'SHRINE',
'N',
0,
'SHRINE Ontology',
'\SHRINE\',
'N',
'CA',
'SHRINE Ontology',
'concept_cd',
'concept_dimension',
'concept_path',
'T',
'\SHRINE\',
'LIKE')
;
Overview
Content Tools