IDRT - Integrated Data Repository Toolkit
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

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:

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.

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