Semantic Interoperability

Selecting a Common Data Model

Recognizing that syntactic and semantic interoperability is necessary for data sharing and consistent, comparable analyses across SCANNER’s distributed network sites, we have selected the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM) version 4.0 as the common data model for SCANNER.  OMOP CDM v4.0 enables modeling and capturing information in the same way at different network sites, e.g., patients, providers, drugs, and procedures.  In addition, OMOP has a useful and growing public library of analytical methods for performance measurements.  Researchers from a variety of institutions in the United States and Europe contribute to this public library.

 

 

Mapping Data to OMOP Common Data Model

omop_v3_schema

The figure above depicts the OMOP schema implemented for the Medication Surveillance and Medication Therapy Management CER
studies within SCANNER.  In collaboration with members from another AHRQ-funded project, Scalable Architecture for Federated Therapeutic Inquiries Network (SAFTINet), and members from the Foundation for the National Institutes of Health (FNIH), some changes were incorporated into the OMOP CDM v4.0 that are useful for data exchanged in SCANNER CER studies.  The new tables found in OMOP CDM v4.0 are color coded green, while the modified tables (from the previous version) are color coded blue. Tables used in SCANNER are highlighted with a red box.

 

 

An example: Mapping data from UCSD to OMOP CDM

CDWR_schema

The figure above depicts the tables within the UCSD data warehouse, which were added or modified to map the data needed for the CER studies within SCANNER to OMOP CDM v4.0.  The new tables created for SCANNER studies are color coded green, while modified tables are color coded blue.