Bridging Data Models in Health Care With a Novel Intermediate Query Format for Feasibility Queries: Mixed Methods Study
Abstract BackgroundTo advance research with clinical data, it is essential to make access to the available data as fast and easy as possible for researchers, which is especially challenging for data from different source systems within and across institutions. Over the years,...
Saved in:
| Main Authors: | , , , , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
JMIR Publications
2024-10-01
|
| Series: | JMIR Medical Informatics |
| Online Access: | https://medinform.jmir.org/2024/1/e58541 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1850268100752048128 |
|---|---|
| author | Lorenz Rosenau Julian Gruendner Alexander Kiel Thomas Köhler Bastian Schaffer Raphael W Majeed |
| author_facet | Lorenz Rosenau Julian Gruendner Alexander Kiel Thomas Köhler Bastian Schaffer Raphael W Majeed |
| author_sort | Lorenz Rosenau |
| collection | DOAJ |
| description |
Abstract
BackgroundTo advance research with clinical data, it is essential to make access to the available data as fast and easy as possible for researchers, 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 Fast Healthcare Interoperability Resources (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 these data available is to allow researchers to create feasibility queries to determine the data availability for a specific research question. Given the heterogeneity of different query languages to access different data across and even within standards such as FHIR (eg, 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.
ObjectiveThis 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 MII.
MethodsWe analyzed the requirements for feasibility queries and the feasibility tools that are currently available in research repositories. Based on this analysis, we developed an intermediate query syntax that can be easily translated into different research repository–specific query languages.
ResultsThe 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 expression to specify 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.
ConclusionsWe 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. |
| format | Article |
| id | doaj-art-aee3cfa65d1a40c5bec952e13a0d8b53 |
| institution | OA Journals |
| issn | 2291-9694 |
| language | English |
| publishDate | 2024-10-01 |
| publisher | JMIR Publications |
| record_format | Article |
| series | JMIR Medical Informatics |
| spelling | doaj-art-aee3cfa65d1a40c5bec952e13a0d8b532025-08-20T01:53:33ZengJMIR PublicationsJMIR Medical Informatics2291-96942024-10-0112e58541e5854110.2196/58541Bridging Data Models in Health Care With a Novel Intermediate Query Format for Feasibility Queries: Mixed Methods StudyLorenz Rosenauhttp://orcid.org/0000-0002-8614-2792Julian Gruendnerhttp://orcid.org/0000-0001-7204-5329Alexander Kielhttp://orcid.org/0000-0003-0461-8185Thomas Köhlerhttp://orcid.org/0000-0002-8993-0794Bastian Schafferhttp://orcid.org/0009-0007-9472-0293Raphael W Majeedhttp://orcid.org/0000-0002-8260-8815 Abstract BackgroundTo advance research with clinical data, it is essential to make access to the available data as fast and easy as possible for researchers, 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 Fast Healthcare Interoperability Resources (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 these data available is to allow researchers to create feasibility queries to determine the data availability for a specific research question. Given the heterogeneity of different query languages to access different data across and even within standards such as FHIR (eg, 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. ObjectiveThis 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 MII. MethodsWe analyzed the requirements for feasibility queries and the feasibility tools that are currently available in research repositories. Based on this analysis, we developed an intermediate query syntax that can be easily translated into different research repository–specific query languages. ResultsThe 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 expression to specify 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. ConclusionsWe 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.https://medinform.jmir.org/2024/1/e58541 |
| spellingShingle | Lorenz Rosenau Julian Gruendner Alexander Kiel Thomas Köhler Bastian Schaffer Raphael W Majeed Bridging Data Models in Health Care With a Novel Intermediate Query Format for Feasibility Queries: Mixed Methods Study JMIR Medical Informatics |
| title | Bridging Data Models in Health Care With a Novel Intermediate Query Format for Feasibility Queries: Mixed Methods Study |
| title_full | Bridging Data Models in Health Care With a Novel Intermediate Query Format for Feasibility Queries: Mixed Methods Study |
| title_fullStr | Bridging Data Models in Health Care With a Novel Intermediate Query Format for Feasibility Queries: Mixed Methods Study |
| title_full_unstemmed | Bridging Data Models in Health Care With a Novel Intermediate Query Format for Feasibility Queries: Mixed Methods Study |
| title_short | Bridging Data Models in Health Care With a Novel Intermediate Query Format for Feasibility Queries: Mixed Methods Study |
| title_sort | bridging data models in health care with a novel intermediate query format for feasibility queries mixed methods study |
| url | https://medinform.jmir.org/2024/1/e58541 |
| work_keys_str_mv | AT lorenzrosenau bridgingdatamodelsinhealthcarewithanovelintermediatequeryformatforfeasibilityqueriesmixedmethodsstudy AT juliangruendner bridgingdatamodelsinhealthcarewithanovelintermediatequeryformatforfeasibilityqueriesmixedmethodsstudy AT alexanderkiel bridgingdatamodelsinhealthcarewithanovelintermediatequeryformatforfeasibilityqueriesmixedmethodsstudy AT thomaskohler bridgingdatamodelsinhealthcarewithanovelintermediatequeryformatforfeasibilityqueriesmixedmethodsstudy AT bastianschaffer bridgingdatamodelsinhealthcarewithanovelintermediatequeryformatforfeasibilityqueriesmixedmethodsstudy AT raphaelwmajeed bridgingdatamodelsinhealthcarewithanovelintermediatequeryformatforfeasibilityqueriesmixedmethodsstudy |