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

Area of Science:

• Medical Informatics
• Health Data Management
• Clinical Research Infrastructure

Background:

• Medical research increasingly relies on data warehouses for consolidated views from diverse sources.
• Existing solutions like the i2b2 framework lack robust support for clinical data and metadata integration.
• There is a need for flexible, center-independent infrastructure for medical research data.

Purpose of the Study:

• To develop a platform for seamless integration and administration of heterogeneous data sources.
• To enable linking of diverse data to medical terminologies for standardized analysis.
• To provide capabilities for transforming and mapping data streams into user-specific views.

Main Methods:

• Developed a suite of three tools: i2b2 Wizard, IDRT Import and Mapping Tool, and IDRT i2b2 Web Client Plugin.
• The Import and Mapping Tool facilitates data loading from various formats (CSV, SQL, CDISC ODM) and includes an ontology editor.
• Tools support annotation with German medical terminologies (ICD-10-GM, OPS, ICD-O) and offer advanced export options.

Main Results:

• New i2b2-based research projects can be established and customized within hours.
• Efficient amalgamation of data and metadata from disparate databases is achieved.
• Integration of a pseudonymization service ensures data privacy; use of common ontologies enhances data semantic consistency.

Conclusions:

• The developed platform empowers clinical researchers to formulate and test hypotheses with limited programming knowledge.
• Tested on large datasets (millions of observations, tens of thousands of patients), enabling researchers to conduct analyses independently.
• Improved data access and quality checking are key benefits, lowering barriers for complex research tasks.