{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,11,13]],"date-time":"2025-11-13T18:29:24Z","timestamp":1763058564322},"reference-count":0,"publisher":"IOS Press","license":[{"start":{"date-parts":[[2021,5,24]],"date-time":"2021-05-24T00:00:00Z","timestamp":1621814400000},"content-version":"unspecified","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by-nc\/4.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2021,5,24]]},"abstract":"<jats:p>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\u2019s 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.<\/jats:p>","DOI":"10.3233\/shti210077","type":"book-chapter","created":{"date-parts":[[2021,5,27]],"date-time":"2021-05-27T12:18:35Z","timestamp":1622117915000},"source":"Crossref","is-referenced-by-count":4,"title":["Accessing OMOP Common Data Model Repositories with the i2b2 Webclient \u2013 Algorithm for Automatic Query Translation"],"prefix":"10.3233","author":[{"given":"Raphael W.","family":"Majeed","sequence":"first","affiliation":[{"name":"Universities Giessen and Marburg Lung Center (UGMLC), German Centre For Lung Research (DZL), Justus-Liebig University Giessen, Germany"},{"name":"Institute of Medical Informatics, Medical Faculty of RWTH Aachen University, Germany"}]},{"given":"Patrick","family":"Fischer","sequence":"additional","affiliation":[{"name":"Institute for Medical Informatics, Justus-Liebig University Giessen, Germany"}]},{"given":"Andreas","family":"G\u00fcnther","sequence":"additional","affiliation":[{"name":"Universities Giessen and Marburg Lung Center (UGMLC), German Centre For Lung Research (DZL), Justus-Liebig University Giessen, Germany"}]}],"member":"7437","container-title":["Studies in Health Technology and Informatics","German Medical Data Sciences: Bringing Data to Life"],"original-title":[],"link":[{"URL":"https:\/\/ebooks.iospress.nl\/pdf\/doi\/10.3233\/SHTI210077","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2021,10,25]],"date-time":"2021-10-25T13:10:11Z","timestamp":1635167411000},"score":1,"resource":{"primary":{"URL":"https:\/\/ebooks.iospress.nl\/doi\/10.3233\/SHTI210077"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2021,5,24]]},"references-count":0,"URL":"https:\/\/doi.org\/10.3233\/shti210077","relation":{},"ISSN":["0926-9630","1879-8365"],"issn-type":[{"value":"0926-9630","type":"print"},{"value":"1879-8365","type":"electronic"}],"subject":[],"published":{"date-parts":[[2021,5,24]]}}}