Data interchange using i2b2

作者：Jeffrey G. Klann, Aaron Abend, Vijay A. Raghavan, Kenneth D. Mandl, Shawn N. Murphy · 发表于：Journal of the American Medical Informatics Association · 年份：2016 · DOI：10.1093/jamia/ocv188 · 被引用次数：106 · 研究领域：Electronic Health Records Systems、Biomedical Text Mining and Ontologies、Semantic Web and Ontologies

OBJECTIVE: Reinventing data extraction from electronic health records (EHRs) to meet new analytical needs is slow and expensive. However, each new data research network that wishes to support its own analytics tends to develop its own data model. Joining these different networks without new data extraction, transform, and load (ETL) processes can reduce the time and expense needed to participate. The Informatics for Integrating Biology and the Bedside (i2b2) project supports data network interoperability through an ontology-driven approach. We use i2b2 as a hub, to rapidly reconfigure data to meet new analytical requirements without new ETL programming. MATERIALS AND METHODS: Our 12-site National Patient-Centered Clinical Research Network (PCORnet) Clinical Data Research Network (CDRN) uses i2b2 to query data. We developed a process to generate a PCORnet Common Data Model (CDM) physical database directly from existing i2b2 systems, thereby supporting PCORnet analytic queries without new ETL programming. This involved: a formalized process for representing i2b2 information models (the specification of data types and formats); an information model that represents CDM Version 1.0; and a program that generates CDM tables, driven by this information model. This approach is generalizable to any logical information model. RESULTS: Eight PCORnet CDRN sites have implemented this approach and generated a CDM database without a new ETL process from the EHR. This enables federated queryi...