Skip to content

Advertisement

You're viewing the new version of our site. Please leave us feedback.

Learn more

Journal of Clinical Bioinformatics

Open Access

TRANSFoRm Query Workbench

Journal of Clinical Bioinformatics20155(Suppl 1):S16

https://doi.org/10.1186/2043-9113-5-S1-S16

Published: 22 May 2015

Characterisation

Tool, open source, data management, research query generation, database research.

Description

The Query Workbench is a tool of the TRANSFoRm project to support clinical studies and database research. It provides an interface to author, store and deploy queries of clinical data to identify potential subjects for clinical studies and can thus support the clinical study feasibility evaluation. The development of the Query Workbench system is driven by the TRANSFoRm Clinical Research Information Model (CRIM) [1], enabling the creation of a semantically aware software tool for easy authoring of distributed searches to EHR (electronic health record) and other clinical data sources (e.g. primary care databases). The use of the TRANSFoRm terminology services, in conjunction with the Clinical Data Integration Model (CDIM) [2] allows the capturing of eligibility criteria in a computable representation, based on the CDIM ontology, so the criteria can be translated into executable query statements at the individual EHR data source (Figure 1). In this way the workbench is able to automatically identify “prevalent cases” for research purposes; the queries report back counts of eligible subjects in the EHRs or the corresponding databases. Results can be broken down by eligibility criteria to give the most detailed information about the distribution of patients and to enable users to update study protocols accordingly. Flagging the subjects for recruitment and obtaining consent is done by the local clinical care team, in full compliance with data protection legislation and best practices.
Figure 1

Query Workbench user interface. Display of definition of eligibility criteria.

Integration with other TRANSFoRm components, such as the security framework, has provided a successful working functionality of the query formulation tool within the TRANSFoRm distributed infrastructure. In this way, users can work together on study and protocol design.

In summary, the Query Workbench supports the creation and conduct of Europe-wide studies, and supports searches in multiple heterogeneous data sources, such as GPRD and NIVEL primary care databases, without the need of processing the data into a common format.

Status of development

Query Workbench is used and evaluated with different databases (e.g. NIVEL); employed in a Diabetes cohort study use case.

Users

Investigators to improve clinical study feasibility and recruitment rate; researchers interested in epidemiological and database research.

Link

Authors’ Affiliations

(1)
University of Warwick
(2)
Heinrich-Heine University Düsseldorf, University Hospital

References

  1. Kuchinke W, Karakoyun T, Ohmann C, Arvanitis TN, Taweel A, Delaney BC, Speedie SM: Extension of the primary care research object model (PCROM) as clinical research information model (CRIM) for the learning healthcare system. BMC Med Inform Decis Mak. 2014, 14 (1): 118-128.PubMed CentralView ArticlePubMedGoogle Scholar
  2. Ethier JF, Dameron O, Curcin V, McGilchrist MM, Verheij RA, Arvanitis TN, Taweel A, Delaney BC, Burgun A: A unified structural/terminological interoperability framework based on LexEVS: application to TRANSFoRm. J Am Med Inform Assoc. 2013, 20 (5): 986-994. 10.1136/amiajnl-2012-001312.PubMed CentralView ArticlePubMedGoogle Scholar

Copyright

© Arvanitis and Kuchinke; licensee BioMed Central Ltd. 2015

This article is published under license to BioMed Central Ltd. This is an Open Access article distributed under the terms of the Creative Commons Attribution License (http://creativecommons.org/licenses/by/4.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited. The Creative Commons Public Domain Dedication waiver (http://creativecommons.org/publicdomain/zero/1.0/) applies to the data made available in this article, unless otherwise stated.

Advertisement