Abstract:Background: In recent years, research data warehouses moved increasingly into the focus of interest of medical research. Nevertheless, there are only a few center-independent infrastructure solutions available. They aim to provide a consolidated view on medical data from various sources such as clinical trials, electronic health records, epidemiological registries or longitudinal cohorts. The i2b2 framework is a well-established solution for such repositories, but it lacks support for importing and integrating clinical data and metadata. Objectives: The goal of this project was to develop a platform for easy integration and administration of data from heterogeneous sources, to provide capabilities for linking them to medical terminologies and to allow for transforming and mapping of data streams for user-specific views. Methods: A suite of three tools has been developed: the i2b2 Wizard for simplifying administration of i2b2, the IDRT Import and Mapping Tool for loading clinical data from various formats like CSV, SQL, CDISC ODM or biobanks and the IDRT i2b2 Web Client Plugin for advanced export options. The Import and Mapping Tool also includes an ontology editor for rearranging and mapping patient data and structures as well as annotating clinical data with medical terminologies, primarily those used in Germany (ICD-10-GM, OPS, ICD-O, etc.). Results: With the three tools functional, new i2b2-based research projects can be created, populated and customized to researcher's needs in a few hours. Amalgamating data and metadata from different databases can be managed easily. With regards to data privacy a pseudonymization service can be plugged in. Using common ontologies and reference terminologies rather than project-specific ones leads to a consistent understanding of the data semantics. Conclusions: i2b2's promise is to enable clinical researchers to devise and test new hypothesis even without a deep knowledge in statistical programing. The approach presented here has been tested in a number of scenarios with millions of observations and tens of thousands of patients. Initially mostly observant, trained researchers were able to construct new analyses on their own. Early feedback indicates that timely and extensive access to their "own" data is appreciated most, but it is also lowering the barrier for other tasks, for instance checking data quality and completeness (missing data, wrong coding).

Offset voltage control scheme for modular multilevel converter operated in nearest level control

Ontology-Based Medical Data Integration for Regional Healthcare Application

Integrating HL7 RIM and Ontology for Unified Knowledge and Data Representation in Clinical Decision Support Systems

Modeling Of Clinical Pathways Based On Ontology

Interactions between visual and motor areas during the recognition of plausible actions as revealed by magnetoencephalography

An ETL-process design for data harmonization to participate in international research with German real-world data based on FHIR and OMOP CDM

Aggregation and Visualization of Laboratory Data by Using Ontological Tools Based on LOINC and SNOMED CT

Extraperitoneal pelvioscopy: a new aid in staging of lower urinary tract tumors. A preliminary report.

Data integration between clinical research and patient care: A framework for context-depending data sharing and in silico predictions

An architecture of open-source tools to combine textual information extraction, faceted search and information visualisation

Integration of decentralized clinical data in a data warehouse: a service-oriented design and realization

Detailed clinical modelling approach to data extraction from heterogeneous data sources for clinical research.

An ontology-guided semantic data integration framework to support integrative data analysis of cancer survival

Integrated Data Repository Toolkit (IDRT). A Suite of Programs to Facilitate Health Analytics on Heterogeneous Medical Data

Ontologizing health systems data at scale: making translational discovery a reality

Collaborative Semantic Annotation Tooling (CoAT) to Improve Efficiency and Plug-and-Play Semantic Interoperability in the Secondary Use of Medical Data: Concept, Implementation, and First Cross-Institutional Experiences

Building ontology-based temporal databases for data reuse: An applied example on hospital organizational structures

Adherence events in the pathogenesis of infective endocarditis.

Mapping the Oncological Basis Dataset to the Standardized Vocabularies of a Common Data Model: A Feasibility Study

Development of a SNOMED CT Mapping Process and Tool at a Data Integration Centre - Lessons Learned

Mentor‐mentee interaction and laboratory social environment: Do they matter in doctoral students' publication productivity?