Designing a Data Warehouse Dimensional Model based on the HL7 Clinical Document Architecture

This paper proposes a conceptual framework to map the data warehouse dimensional model primitives with HL7 Clinical Document Architecture (CDA) elements. To accomplish this purpose features both schemas are defined based on a first-order logic. Based on this formalism the mapping steps have been performed following the dimensional model lifecycle. This approach facilitates the integration of heterogeneous information systems in a clinical data warehouse simplifying the transformation procedures as well as improving the quality and consistency of data.