{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,4,4]],"date-time":"2026-04-04T19:19:37Z","timestamp":1775330377350,"version":"3.50.1"},"reference-count":26,"publisher":"Oxford University Press (OUP)","issue":"10","license":[{"start":{"date-parts":[[2018,7,31]],"date-time":"2018-07-31T00:00:00Z","timestamp":1532995200000},"content-version":"vor","delay-in-days":1,"URL":"http:\/\/creativecommons.org\/licenses\/by-nc\/4.0\/"}],"funder":[{"DOI":"10.13039\/100006093","name":"Patient-Centered Outcomes Research Institute","doi-asserted-by":"publisher","award":["CDRN-1306-04608"],"award-info":[{"award-number":["CDRN-1306-04608"]}],"id":[{"id":"10.13039\/100006093","id-type":"DOI","asserted-by":"publisher"}]},{"name":"NIH NHGRI","award":["U54 HG007963"],"award-info":[{"award-number":["U54 HG007963"]}]},{"name":"NIH NHGRI","award":["RO1 HG009174"],"award-info":[{"award-number":["RO1 HG009174"]}]},{"DOI":"10.13039\/100000092","name":"National Library of Medicine","doi-asserted-by":"crossref","award":["5R00LM011575"],"award-info":[{"award-number":["5R00LM011575"]}],"id":[{"id":"10.13039\/100000092","id-type":"DOI","asserted-by":"crossref"}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2018,10,1]]},"abstract":"<jats:title>Abstract<\/jats:title><jats:sec><jats:title>Objective<\/jats:title><jats:p>Healthcare organizations use research data models supported by projects and tools that interest them, which often means organizations must support the same data in multiple models. The healthcare research ecosystem would benefit if tools and projects could be adopted independently from the underlying data model. Here, we introduce the concept of a reusable application programming interface (API) for healthcare and show that the i2b2 API can be adapted to support diverse patient-centric data models.<\/jats:p><\/jats:sec><jats:sec><jats:title>Materials and Methods<\/jats:title><jats:p>We develop methodology for extending i2b2\u2019s pre-existing API to query additional data models, using i2b2\u2019s recent \u201cmulti-fact-table querying\u201d feature. Our method involves developing data-model-specific i2b2 ontologies and mapping these to query non-standard table structure.<\/jats:p><\/jats:sec><jats:sec><jats:title>Results<\/jats:title><jats:p>We implement this methodology to query OMOP and PCORnet models, which we validate with the i2b2 query tool. We implement the entire PCORnet data model and a five-domain subset of the OMOP model. We also demonstrate that additional, ancillary data model columns can be modeled and queried as i2b2 \u201cmodifiers.\u201d<\/jats:p><\/jats:sec><jats:sec><jats:title>Discussion<\/jats:title><jats:p>i2b2\u2019s REST API can be used to query multiple healthcare data models, enabling shared tooling to have a choice of backend data stores. This enables separation between data model and software tooling for some of the more popular open analytic data models in healthcare.<\/jats:p><\/jats:sec><jats:sec><jats:title>Conclusion<\/jats:title><jats:p>This methodology immediately allows querying OMOP and PCORnet using the i2b2 API. It is released as an open-source set of Docker images, and also on the i2b2 community wiki.<\/jats:p><\/jats:sec>","DOI":"10.1093\/jamia\/ocy093","type":"journal-article","created":{"date-parts":[[2018,6,28]],"date-time":"2018-06-28T11:52:19Z","timestamp":1530186739000},"page":"1331-1338","source":"Crossref","is-referenced-by-count":33,"title":["Web services for data warehouses: OMOP and PCORnet on i2b2"],"prefix":"10.1093","volume":"25","author":[{"given":"Jeffrey G","family":"Klann","sequence":"first","affiliation":[{"name":"Research Information Science and Computing, Partners Healthcare, Boston, Massachusetts, USA"},{"name":"Harvard Medical School, Boston, Massachusetts, USA"},{"name":"Department of Medicine, Massachusetts General Hospital, Boston, Massachusetts, USA"}]},{"given":"Lori C","family":"Phillips","sequence":"additional","affiliation":[{"name":"Research Information Science and Computing, Partners Healthcare, Boston, Massachusetts, USA"}]},{"given":"Christopher","family":"Herrick","sequence":"additional","affiliation":[{"name":"Research Information Science and Computing, Partners Healthcare, Boston, Massachusetts, USA"}]},{"given":"Matthew A H","family":"Joss","sequence":"additional","affiliation":[{"name":"Research Information Science and Computing, Partners Healthcare, Boston, Massachusetts, USA"}]},{"given":"Kavishwar B","family":"Wagholikar","sequence":"additional","affiliation":[{"name":"Research Information Science and Computing, Partners Healthcare, Boston, Massachusetts, USA"},{"name":"Department of Medicine, Massachusetts General Hospital, Boston, Massachusetts, USA"}]},{"given":"Shawn N","family":"Murphy","sequence":"additional","affiliation":[{"name":"Research Information Science and Computing, Partners Healthcare, Boston, Massachusetts, USA"},{"name":"Harvard Medical School, Boston, Massachusetts, USA"},{"name":"Department of Neurology, Massachusetts General Hospital, Boston, Massachusetts, USA"}]}],"member":"286","published-online":{"date-parts":[[2018,7,30]]},"reference":[{"key":"2020110612231116700_ocy093-B1"},{"key":"2020110612231116700_ocy093-B2","first-page":"574","article-title":"Observational Health Data Sciences and Informatics (OHDSI): opportunities for observational researchers","volume":"216","author":"Hripcsak","year":"2015","journal-title":"Stud Health Technol Inform"},{"key":"2020110612231116700_ocy093-B3","author":"OHDSI"},{"key":"2020110612231116700_ocy093-B4","author":"All of Us Research Program"},{"issue":"4","key":"2020110612231116700_ocy093-B5","doi-asserted-by":"crossref","first-page":"576","DOI":"10.1136\/amiajnl-2014-002864","article-title":"PCORnet: turning a dream into reality","volume":"21","author":"Collins","year":"2014","journal-title":"J Am Med Inform Assoc"},{"key":"2020110612231116700_ocy093-B6"},{"issue":"2","key":"2020110612231116700_ocy093-B7","doi-asserted-by":"crossref","first-page":"124","DOI":"10.1136\/jamia.2009.000893","article-title":"Serving the enterprise and beyond with Informatics for Integrating Biology and the Bedside (i2b2)","volume":"17","author":"Murphy","year":"2010","journal-title":"J Am Med Inform Assoc"},{"issue":"3","key":"2020110612231116700_ocy093-B8","doi-asserted-by":"crossref","first-page":"e55811","DOI":"10.1371\/journal.pone.0055811","article-title":"SHRINE: enabling nationally scalable multi-site disease studies","volume":"8","author":"McMurry","year":"2013","journal-title":"PLoS One"},{"key":"2020110612231116700_ocy093-B9"},{"key":"2020110612231116700_ocy093-B10"},{"issue":"5","key":"2020110612231116700_ocy093-B11","doi-asserted-by":"crossref","first-page":"909","DOI":"10.1093\/jamia\/ocv188","article-title":"Data interchange using i2b2","volume":"23","author":"Klann","year":"2016","journal-title":"J Am Med Inform Assoc"},{"key":"2020110612231116700_ocy093-B12","first-page":"548","article-title":"Architecture of the Open-source Clinical Research Chart from Informatics for Integrating Biology and the Bedside","volume":"2007","author":"Murphy","year":"2007","journal-title":"AMIA Annu Symp Proc"},{"issue":"2","key":"2020110612231116700_ocy093-B13","doi-asserted-by":"crossref","first-page":"398","DOI":"10.1093\/jamia\/ocw079","article-title":"SMART-on-FHIR implemented over i2b2","volume":"24","author":"Wagholikar","year":"2017","journal-title":"J Am Med Inform Assoc"},{"issue":"4","key":"2020110612231116700_ocy093-B14","doi-asserted-by":"crossref","first-page":"e75","DOI":"10.2196\/jmir.2493","article-title":"Computing health quality measures using Informatics for Integrating Biology and the Bedside","volume":"15","author":"Klann","year":"2013","journal-title":"J Med Internet Res"},{"key":"2020110612231116700_ocy093-B15"},{"key":"2020110612231116700_ocy093-B16"},{"key":"2020110612231116700_ocy093-B17","year":"2013"},{"key":"2020110612231116700_ocy093-B18"},{"key":"2020110612231116700_ocy093-B19"},{"key":"2020110612231116700_ocy093-B20","author":"Phillips","year":"2014"},{"key":"2020110612231116700_ocy093-B21"},{"key":"2020110612231116700_ocy093-B22"},{"key":"2020110612231116700_ocy093-B23","author":"Klann","year":"2017"},{"key":"2020110612231116700_ocy093-B24","year":"2017"},{"key":"2020110612231116700_ocy093-B25","author":"pcori\/omop i2b2 demo"},{"key":"2020110612231116700_ocy093-B26","author":"Install dockerized i2b2 on PCORnet\/OMOP"}],"container-title":["Journal of the American Medical Informatics Association"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/academic.oup.com\/jamia\/article-pdf\/25\/10\/1331\/34151073\/ocy093.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"syndication"},{"URL":"http:\/\/academic.oup.com\/jamia\/article-pdf\/25\/10\/1331\/34151073\/ocy093.pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,8,26]],"date-time":"2022-08-26T16:53:25Z","timestamp":1661532805000},"score":1,"resource":{"primary":{"URL":"https:\/\/academic.oup.com\/jamia\/article\/25\/10\/1331\/5061849"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2018,7,30]]},"references-count":26,"journal-issue":{"issue":"10","published-online":{"date-parts":[[2018,7,30]]},"published-print":{"date-parts":[[2018,10,1]]}},"URL":"https:\/\/doi.org\/10.1093\/jamia\/ocy093","relation":{},"ISSN":["1067-5027","1527-974X"],"issn-type":[{"value":"1067-5027","type":"print"},{"value":"1527-974X","type":"electronic"}],"subject":[],"published-other":{"date-parts":[[2018,10]]},"published":{"date-parts":[[2018,7,30]]}}}