Versions Compared

Old Version 13

changes.mady.by.user Sam Tsoi

Saved on

compared with

New Version 14

changes.mady.by.user Sam Tsoi

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
themerdark
$ psql "dbname=i2b2 options=--search_path=shrine_ont" -a -f SCHEMES.sql

 

Next, you will need to point i2b2 to create the tables that will contain look at the newly created schemas in its database for the SHRINE ontology. Please refer to this file for the script: ontologydb_create_tableslookups.sql

You can run this script by running:

Code Block
languagesql
themerdark
$ psql "dbname=i2b2 options=--search_path=shrine_onti2b2hive" -a -f ontology_create_tables.sql

 

db_lookups.sql

 

ontology Lastly, you will need to configure the table access

 

within the shrine_ont schema:

Code Block
languagesql
themerdark

...

$ psql -U postgres i2b2
 
i2b2=# set search_path = shrine_ont;
 
i2b2=# INSERT into shrine_ont

...

.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');