Related Experiment Video
Updated: Jun 10, 2025

Executing Complexity-Increasing Queries in Relational MySQL and NoSQL MongoDB and EXist Size-Growing ISO/EN 13606 Standardized EHR Databases
Published on: March 19, 2018
Bridging Data Models in Health Care With a Novel Intermediate Query Format for Feasibility Queries: Mixed Methods
Lorenz Rosenau1, Julian Gruendner2, Alexander Kiel3
1IT Center for Clinical Research, University of Lübeck, Gebäude 64, 2.OG, Raum 05, Ratzeburger Allee 160, Lübeck, 23562, Germany, 49 451 3101 5636.
Researchers can now more easily query clinical data availability using the new Clinical Cohort Definition Language (CCDL). This standardized syntax simplifies data access across institutions, advancing health research.
Area of Science:
- Health Informatics
- Clinical Data Management
- Biomedical Research
Background:
- Advancing clinical research requires fast and easy access to diverse data sources.
- The German Medical Informatics Initiative (MII) uses the Fast Healthcare Interoperability Resources (FHIR) standard for data harmonization.
- Querying data across different systems and standards (e.g., CQL, FHIR Search) presents significant challenges.
Purpose of the Study:
- To develop and implement an intermediate query syntax for feasibility queries.
- To simplify data availability assessments for researchers.
- To enhance interoperability within the federated German health research portal (Forschungsdatenportal Gesundheit) and the MII.
Main Methods:
- Analysis of requirements for feasibility queries and existing tools.
- Development of an intermediate query syntax translatable to various repository-specific languages.
- Definition of a JSON schema and ontology for the new syntax.
Main Results:
- The Clinical Cohort Definition Language (CCDL) was created for feasibility queries.
- CCDL combines inclusion/exclusion criteria with filters for time and numerical restrictions.
- Demonstrated CCDL's translatability and usability across multiple studies and real-world use cases.
Conclusions:
- A structured query syntax (CCDL) for feasibility queries was developed and evaluated.
- CCDL was successfully integrated into a research platform across 39 German university hospitals.
- The new syntax simplifies data access and improves interoperability for clinical research.
Related Concept Videos
Health Information Technology and Healthcare Information System
Health Information Technology, commonly called HIT, integrates advanced information systems and technology in healthcare settings. Its primary functions include:
Issues And Trends In Healthcare Delivery System
Cost Containment
Payment for healthcare services has historically promoted adoption of costly and often unnecessary or inefficient...
Methods of Documentation VI: Case Management Model
For example, a patient with a chronic...
Models of Health Promotion and Illness Prevention I
The health belief model (HBM) attempts to predict health-related behavior in specific belief patterns. According to the HBM, a person's...
Data Validation
Nursing assessment guides are generally based on holistic models rather than medical...
Formats for Nursing Documentation
Nursing Assessment Form:
• A nursing assessment form is a foundational document that captures detailed patient data from physical assessments and nursing histories.
• It includes patient demographics, medical history,...

