Development of a medical informatics data warehouse.

Area of Science:

• Medical Informatics
• Database Management
• Health Data Analytics

Background:

• Baylor Family Medicine Clinic (FCM) collected medical information via the Logician application.
• Existing data systems lacked robust analytical capabilities for comprehensive patient information review.

Purpose of the Study:

• To develop a Medical Informatics Data Warehouse (MedInfo DDW) for analyzing FCM patient data.
• To implement a dimensional model (Star Schema) for efficient data retrieval and analysis.
• To leverage On-line Analytical Processing (OLAP) for patient information insights.

Main Methods:

• Built a MedInfo DDW using an Oracle database.
• Utilized FCM's operational data store (ODS) and the Star Schema dimensional model.
• Extracted data from On-line Transaction Processing (OLTP) using SQLLoad.
• Analyzed patient information via OLAP using Crystal Reports.

Main Results:

• Successfully established a functional MedInfo DDW.
• Enabled structured analysis of medical information collected through the Logician application.
• Facilitated patient data analysis using OLAP tools.

Conclusions:

• The MedInfo DDW provides a robust platform for analyzing medical informatics data.
• The implemented Star Schema and OLAP facilitate efficient patient information analysis.
• This data warehouse supports data-driven decision-making in a clinical setting.