Abstract:Background The harmonization and standardization of digital medical information for research purposes is a challenging and ongoing collaborative effort. Current research data repositories typically require extensive efforts in harmonizing and transforming original clinical data. The Fast Healthcare Interoperability Resources (FHIR) format was designed primarily to represent clinical processes; therefore, it closely resembles the clinical data model and is more widely available across modern electronic health records. However, no common standardized data format is directly suitable for statistical analyses, and data need to be preprocessed before statistical analysis. Objective This study aimed to elucidate how FHIR data can be queried directly with a preprocessing service and be used for statistical analyses. Methods We propose that the binary JavaScript Object Notation format of the PostgreSQL (PSQL) open source database is suitable for not only storing FHIR data, but also extending it with preprocessing and filtering services, which directly transform data stored in FHIR format into prepared data subsets for statistical analysis. We specified an interface for this preprocessor, implemented and deployed it at University Hospital Erlangen-Nürnberg, generated 3 sample data sets, and analyzed the available data. Results We imported real-world patient data from 2016 to 2018 into a standard PSQL database, generating a dataset of approximately 35.5 million FHIR resources, including “Patient,” “Encounter,” “Condition” (diagnoses specified using International Classification of Diseases codes), “Procedure,” and “Observation” (laboratory test results). We then integrated the developed preprocessing service with the PSQL database and the locally installed web-based KETOS analysis platform. Advanced statistical analyses were feasible using the developed framework using 3 clinically relevant scenarios (data-driven establishment of hemoglobin reference intervals, assessment of anemia prevalence in patients with cancer, and investigation of the adverse effects of drugs). Conclusions This study shows how the standard open source database PSQL can be used to store FHIR data and be integrated with a specifically developed preprocessing and analysis framework. This enables dataset generation with advanced medical criteria and the integration of subsequent statistical analysis. The web-based preprocessing service can be deployed locally at the hospital level, protecting patients’ privacy while being integrated with existing open source data analysis tools currently being developed across Germany.

Towards a FHIR-Based Framework for Analyzing Nursing-Related Data in Smaller Sized Care Facilities

A Framework for Criteria-Based Selection and Processing of Fast Healthcare Interoperability Resources (FHIR) Data for Statistical Analysis: Design and Implementation Study

"fhircrackr": An R Package Unlocking Fast Healthcare Interoperability Resources for Statistical Analysis

A scalable approach for critical care data extraction and analysis in an academic medical center

FAIRness through automation: development of an automated medical data integration infrastructure for FAIR health data in a maximum care university hospital

Exploratory Electronic Health Record Analysis with Ehrapy

A Standardized Clinical Data Harmonization Pipeline for Scalable AI Application Deployment (FHIR-DHP): Validation and Usability Study

Advancing Healthcare Research Through Live-Data Integration: Implementing IEEE 11073 and FHIR in Clinical Environment

Automated Population of an i2b2 Clinical Data Warehouse using FHIR

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

Quality Assessment Framework of Clinical Routine Data for Secondary Use

Enabling Data-Driven Nursing Innovations: User-centered Development of a Nursing Data Module

Establishing Medical Intelligence - Leveraging FHIR to Improve Clinical Management: a retrospective cohort and clinical implementation study

Unlocking Real-World Health Data from Non-University Locations Through Effective Provision of Tools and Knowledge

Streamlining intersectoral provision of real-world health data: a service platform for improved clinical research and patient care

Germany's Approach for the Secondary Use of Federated Real-World Data in the German Portal for Medical Research Data

Estimation and Monitoring of Operating Room Utilization by a Distributed Streaming and Analytics Architecture Deployed at Heidelberg University Hospital's Medical Data Integration Center

Integrating Laboratory Testing Results at Point-of-Care in Hospital@Home Care Settings: A FHIR-Based Approach

An open-source framework for end-to-end analysis of electronic health record data

Advancing Healthcare Through Interoperability: Implementing Scalable Solutions for Patient Data Integration

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