Methods Inf Med 2016; 55(04): 381-386
DOI: 10.3414/ME15-02-0015
Focus Theme – Original Articles
Schattauer GmbH

Data Linkage from Clinical to Study Databases via an R Data Warehouse User Interface

Experiences from a Large Clinical Follow-up Study
Mathias Kaspar
1   Comprehensive Heart Failure Center (CHFC), University Hospital of Würzburg, Würzburg, Germany
,
Maximilian Ertl
2   Service Center Medical Informatics, University Hospital of Würzburg, Würzburg, Germany
,
Georg Fette
1   Comprehensive Heart Failure Center (CHFC), University Hospital of Würzburg, Würzburg, Germany
3   Chair of Computer Science VI, University of Würzburg, Würzburg, Germany
,
Georg Dietrich
3   Chair of Computer Science VI, University of Würzburg, Würzburg, Germany
,
Martin Toepfer
3   Chair of Computer Science VI, University of Würzburg, Würzburg, Germany
,
Christiane Angermann
1   Comprehensive Heart Failure Center (CHFC), University Hospital of Würzburg, Würzburg, Germany
,
Stefan Störk*
1   Comprehensive Heart Failure Center (CHFC), University Hospital of Würzburg, Würzburg, Germany
,
Frank Puppe*
3   Chair of Computer Science VI, University of Würzburg, Würzburg, Germany
› Author Affiliations

Fundings This research was funded by grant of German Federal Ministry of Education and Research (Comprehensive Heart Failure Center Würzburg, grants #01EO1004 and #01EO1504).
Further Information

Publication History

received: 15 December 2015

accepted in revised form: 15 June 2016

Publication Date:
08 January 2018 (online)

Preview

Summary

Background: Data that needs to be documented for clinical studies has often been acquired and documented in clinical routine. Usually this data is manually transferred to Case Report Forms (CRF) and/or directly into an electronic data capture (EDC) system.

Objectives: To enhance the documentation process of a large clinical follow-up study targeting patients admitted for acutely decompensated heart failure by accessing the data created during routine and study visits from a hospital information system (HIS) and by transferring it via a data warehouse (DWH) into the study‘s EDC system.

Methods: This project is based on the clinical DWH developed at the University of Würzburg. The DWH was extended by several new data domains including data created by the study team itself. An R user interface was developed for the DWH that allows to access its source data in all its detail, to transform data as comprehensively as possible by R into study-specific variables and to support the creation of data and catalog tables.

Results: A data flow was established that starts with labeling patients as study patients within the HIS and proceeds with updating the DWH with this label and further data domains at a daily rate. Several study-specific variables were defined using the implemented R user interface of the DWH. This system was then used to export these variables as data tables ready for import into our EDC system. The data tables were then used to initialize the first 296 patients within the EDC system by pseudonym, visit and data values. Afterwards, these records were filled with clinical data on heart failure, vital parameters and time spent on selected wards.

Conclusions: This solution focuses on the comprehensive access and transformation of data for a DWH-EDC system linkage. Using this system in a large clinical study has demonstrated the feasibility of this approach for a study with a complex visit schedule.

* These authors contributed equally to this work