IDRT - Integrated Data Repository Toolkit
Space shortcuts
Space Tools

Versions Compared

Key

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

Background

In most projects, the i2b2 ontology resides in a default database table called I2B2. If you have a large ontology, maybe consisting of concepts from different sources, it might be a good idea to split the ontology into multiple tables. That will simply maintenance as you need to update only the table where the ontology has changed.

Methods

The table TABLE_ACCESS contains references to all other tables that are part of the ontology. See the example Boston demo database:

Image Added

The column C_TABLE_NAME contains the names of tables (BIRN, ICD10_ICD9) in the i2b2 database schema that comprises the ontology. C_TABLE_CD contains a key which is used as a prefix for the path (C_FULLNAME) when i2b2 cells communicate.

Image Added

Info
This mechanism also allows for creating additional root nodes for the ontology (from additional tables as well as from second level nodes in I2B2).