A conceptual framework to design a dimensional model based on the HL7 Clinical Document Architecture

Area of Science:

• Health Informatics
• Data Warehousing
• Information Systems

Background:

• Integrating heterogeneous clinical information systems is challenging.
• Clinical data warehouses require efficient data integration methods.
• Extract, Transform, Load (ETL) procedures are complex and costly.

Purpose of the Study:

• To propose a conceptual framework for designing dimensional models.
• To leverage the HL7 Clinical Document Architecture (CDA) standard.
• To facilitate the integration of clinical data into data warehouses.

Main Methods:

• Developing a conceptual framework for dimensional modeling.
• Applying the framework to the HL7 Clinical Document Architecture (CDA).
• Demonstrating feasibility through a case study for quality assessment.

Main Results:

• The proposed framework simplifies the design of dimensional models.
• Integration of heterogeneous information systems is facilitated.
• ETL procedures in clinical data warehousing are streamlined.

Conclusions:

• The framework offers a viable solution for clinical data warehousing.
• It reduces the complexity and cost of ETL processes.
• The approach is feasible for defining clinical indicators for quality assessment.