Open Source SoftwareTranslational ResearchRegular ExpressionBiomaterial DataMedical Terminology
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 .
This project was supported by BMBF grant 01GI1003.
Department of Medical Informatics, University Medical Center Göttingen, Göttingen, Germany
Medical Center for Information and Communication Technology, Erlangen University Hospital, Erlangen, Germany
Chair of Medical Informatics, Friedrich-Alexander-University of Erlangen-Nuremberg, Erlangen, Germany
Institute for Medical Informatics, Statistics and Epidemiology (IMISE), University Leipzig, Leipzig, Germany
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.PubMed CentralView ArticlePubMedGoogle Scholar
This article is published under license to BioMed Central Ltd. This is an Open Access article distributed under the terms of the Creative Commons Attribution License (http://creativecommons.org/licenses/by/4.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited. The Creative Commons Public Domain Dedication waiver (http://creativecommons.org/publicdomain/zero/1.0/) applies to the data made available in this article, unless otherwise stated.