Maintenance Notice

Due to necessary scheduled maintenance, the JMIR Publications website will be unavailable from Wednesday, July 01, 2020 at 8:00 PM to 10:00 PM EST. We apologize in advance for any inconvenience this may cause you.

Who will be affected?

Accepted for/Published in: JMIR Medical Informatics

Date Submitted: Mar 18, 2024
Date Accepted: Jun 23, 2024

The final, peer-reviewed published version of this preprint can be found here:

Bridging Data Models in Health Care With a Novel Intermediate Query Format for Feasibility Queries: Mixed Methods Study

Rosenau L, Gruendner J, Kiel A, Köhler T, Schaffer B, Majeed R

Bridging Data Models in Health Care With a Novel Intermediate Query Format for Feasibility Queries: Mixed Methods Study

JMIR Med Inform 2024;12:e58541

DOI: 10.2196/58541

PMID: 39401125

PMCID: 11493108

Warning: This is an author submission that is not peer-reviewed or edited. Preprints - unless they show as "accepted" - should not be relied on to guide clinical practice or health-related behavior and should not be reported in news media as established information.

Bridging Data Models in Healthcare: Introducing a novel intermediate query format for feasibility queries.

  • Lorenz Rosenau; 
  • Julian Gruendner; 
  • Alexander Kiel; 
  • Thomas Köhler; 
  • Bastian Schaffer; 
  • Raphael Majeed

ABSTRACT

Background:

To advance research with clinical data, it is essential to provide researchers with fast and easy access to the available data, which is especially challenging for data from different source systems within and across institutions. Over the years, many research repositories and data standards have been created. One of these is the FHIR standard, used by the German Medical Informatics Initiative (MII) to harmonize and standardize data across university hospitals in Germany. One of the first steps to make this data available is to allow researchers to create feasibility queries to determine the data availability for a specific study. Given the heterogeneity of different query languages to access different data across and even within standards such as FHIR (e.g., CQL and FHIR Search), creating an intermediate query syntax for feasibility queries reduces the complexity of query translation and improves interoperability across different research repositories and query languages.

Objective:

This study describes the creation and implementation of an intermediate query syntax for feasibility queries and how it integrates into the federated German health research portal (Forschungsdatenportal Gesundheit) and the German medical informatics initiative.

Methods:

We analyzed the requirements for feasibility queries, and the currently available feasibility tools that research repositories offer. Based on this analysis, we developed an intermediate query syntax that can be easily translated into different research repository-specific query languages.

Results:

The resulting Clinical Cohort Definition Language (CCDL) for feasibility queries combines inclusion criteria in a conjunctive normal form and exclusion criteria in a disjunctive normal form, allowing for additional filters like time or numerical restrictions. The inclusion and exclusion results are combined via an AND NOT expression to specify complex feasibility queries. We defined a JSON schema for the CCDL, generated an ontology, and demonstrated the use and translatability of the CCDL across multiple studies and real-world use cases.

Conclusions:

We developed and evaluated a structured query syntax for feasibility queries and demonstrated its use in a real-world example as part of a research platform across 39 German university hospitals.


 Citation

Please cite as:

Rosenau L, Gruendner J, Kiel A, Köhler T, Schaffer B, Majeed R

Bridging Data Models in Health Care With a Novel Intermediate Query Format for Feasibility Queries: Mixed Methods Study

JMIR Med Inform 2024;12:e58541

DOI: 10.2196/58541

PMID: 39401125

PMCID: 11493108

Download PDF


Request queued. Please wait while the file is being generated. It may take some time.

© The authors. All rights reserved. This is a privileged document currently under peer-review/community review (or an accepted/rejected manuscript). Authors have provided JMIR Publications with an exclusive license to publish this preprint on it's website for review and ahead-of-print citation purposes only. While the final peer-reviewed paper may be licensed under a cc-by license on publication, at this stage authors and publisher expressively prohibit redistribution of this draft paper other than for review purposes.