A Clinical Data Warehouse Based on OMOP and i2b2 for Austrian Health Claims Data

Stud Health Technol Inform. 2018:248:94-99.

Abstract

Background: To develop simulation models for healthcare related questions clinical data can be reused.

Objectives: Develop a clinical data warehouse to harmonize different data sources in a standardized manner and get a reproducible interface for clinical data reuse.

Methods: The Kimball life cycle for the development of data warehouse was used. The development is split into the technical, the data and the business intelligence pathway.

Results: Sample data was persisted in the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM). The i2b2 clinical data warehouse tools were used to query the OMOP CDM by applying the new i2b2 multi-fact table feature.

Conclusion: A clinical data warehouse was set up and sample data, data dimensions and ontologies for Austrian health claims data were created. The ability of the standardized data access layer to create and apply simulation models will be evaluated next.

Keywords: Secondary use; clinical data warehousing; standardized health data.

MeSH terms

  • Austria
  • Data Warehousing*
  • Databases, Factual*
  • Delivery of Health Care
  • Humans
  • Information Storage and Retrieval*