Accessing OMOP Common Data Model Repositories with the i2b2 Webclient – Algorithm for Automatic Query Translation

Studies in health technology and informatics, vol. 278, pp. 251–259

Abstract

In the era of translational research, data integration and clinical data warehouses are important enabling technologies for clinical researchers. The OMOP common data model is a wide-spread choice as a target for data integration in medical informatics. It's portability of queries and analyses across different institutions and data are ideal also from the viewpoint of the FAIR principles. Yet, the OMOP CDM lacks a simple and intuitive user interface for untrained users to run simple queries for feasibility analysis. Aim of this study is to provide an algorithm to translate any given i2b2 query to an equivalent query which can then be run on the OMOP CDM database. The provided algorithm is able to convert queries created in the i2b2 webclient to SQL statements which can be executed on a standard OMOP CDM database programmatically.

Authors 3

1. Raphael W. Majeed corresponding Aachen Institute of Medical Informatics Medical Faculty

   RWTH Aachen University · German Center for Lung Research · Justus-Liebig-Universität Gießen · Universities of Giessen and Marburg Lung Center

   Affiliation as printed

   Institute of Medical Informatics, Medical Faculty of RWTH Aachen University, Germany

   Universities Giessen and Marburg Lung Center (UGMLC), German Centre For Lung Research (DZL), Justus-Liebig University Giessen, Germany

2. Patrick Fischer

   Justus-Liebig-Universität Gießen

   Affiliation as printed

   Institute for Medical Informatics, Justus-Liebig University Giessen, Germany

3. Andreas Günther

   German Center for Lung Research · Justus-Liebig-Universität Gießen · Universities of Giessen and Marburg Lung Center

   Affiliation as printed

   Universities Giessen and Marburg Lung Center (UGMLC), German Centre For Lung Research (DZL), Justus-Liebig University Giessen, Germany

   Universities Giessen and Marburg Lung Center (UGMLC),