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.
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
Authors: Kavishwar B Wagholikar; Layne Ainsworth; David Zelle; Kira Chaney; Michael Mendis; Jeffery Klann; Alexander J Blood; Angela Miller; Rupendra Chulyadyo; Michael Oates; William J Gordon; Samuel J Aronson; Benjamin M Scirica; Shawn N Murphy Journal: Bioinformatics Date: 2022-10-14 Impact factor: 6.931