Clinical Data Warehouse
A database optimized for analytics and reporting that aggregates clinical data from EHRs, labs, claims, and other healthcare sources.
Clinical data warehouses (CDWs) aggregate data from multiple source systems into a queryable analytical store. They typically use a dimensional model or a common data model (OMOP, PCORnet, i2b2). Data pipelines extract from HL7v2 feeds, FHIR APIs, flat files, and EHR databases, then transform and load into the warehouse. CDWs support quality reporting, population health analytics, clinical research, and operational dashboards.
FAQ
- What is the OMOP Common Data Model?
- OMOP CDM is a standardized schema for clinical data maintained by OHDSI. It maps source data to standard vocabularies (SNOMED, LOINC, RxNorm) and enables consistent analytics across institutions using the same data model.