The Integrated Data Repository Toolkit (IDRT): accelerating translational research infrastructures
Journal of Clinical Bioinformatics volume 5, Article number: S6 (2015)
i2b2 tool/plugin, patient recruitment, feasibility, translational research, ETL, data integration, open source, data warehouse.
The Open Source software i2b2  provides a translational research platform for storing biomedical data and querying these data with a user-friendly interface for researchers (Figure 1). Despite its powerful features, it is lacking user-friendly tools for installation and configuration, the import of source data and the creation of a comprehensive navigational structure (i2b2 ontology). To close these gaps, the Integrated Data Repository Toolkit (IDRT), consisting of three software tools, has been created. The i2b2 Wizard provides a shell GUI for the installation and configuration of i2b2 instances, projects and users. The i2b2 Import Tool offers a GUI for browsing i2b2 projects and importing data in various standard data formats into i2b2 (e.g., textual (CSV), relational (SQL) or structured data (CDISC ODM/XML)), as well as a dedicated extractor for biomaterial data. During import, i2b2 ontologies are automatically created from metadata included in the source data. The i2b2 Ontology Editor (IOE), being part of the i2b2 Import Tool, can be used for enhancing these i2b2 ontologies. Besides standard functions like rearranging, adding, deleting and renaming folders and items, the IOE is capable of augmenting i2b2 ontologies with more advanced i2b2 functions. By utilizing the two windows of the IOE (one showing the unaltered source i2b2 ontology and the other the manually created target i2b2 ontology), mappings can be achieved by simple drag-and-drop operations. For example, start and end dates can be added to items by dragging a date item onto a fact item. Medical terminologies can easily be imported with the IDRT (e. g. ICD-10, LOINC) and can also be mapped via the same drag-and-drop operations to data elements (expandable beyond the supplied terminologies via a regular expression editor in the IOE). The IDRT tools support the more advanced i2b2 functionalities for “fact nesting”, called “modifiers”. Since the i2b2 web browser query application (i2b2 Web Client) does not support simple access and visualization of modifiers, an IDRT plugin was created that is able to display, combine and export related facts. Additional documentation for enhanced i2b2 usage is provided on the IDRT website .
Status of development
In development (November 2014).
University Medical Center Göttingen.
Kohane IS, Churchill SE, Murphy SN: A translational engine at the national scale: informatics for integrating biology and the bedside. J Am Med Inform Assoc. 2012, 19 (2): 181-185. 10.1136/amiajnl-2011-000492.
i2b2 website. [https://www.i2b2.org]
This project was supported by BMBF grant 01GI1003.
About this article
Cite this article
Bauer, C., Ganslandt, T., Baum, B. et al. The Integrated Data Repository Toolkit (IDRT): accelerating translational research infrastructures. J Clin Bioinform 5 (Suppl 1), S6 (2015). https://doi.org/10.1186/2043-9113-5-S1-S6
- Open Source Software
- Translational Research
- Regular Expression
- Biomaterial Data
- Medical Terminology