Data mart based research in heart surgery: challenges and benefit.

Area of Science:

• Medical Informatics
• Cardiovascular Surgery Research
• Data Management

Background:

• Comprehensive data is essential for advancing heart surgery research.
• Integrating real-time and legacy data from multiple, unconnected hospital information systems (HIS) presents significant challenges.
• Autonomous hospital departments often modify their database structures, complicating data integration.

Purpose of the Study:

• To present a solution for integrating and consolidating research-relevant data from disparate HIS into a data mart.
• To address challenges of partial data consistency and redundancy.
• To simplify data preparation for comprehensive clinical studies.

Main Methods:

• Development of a data mart to integrate data from various hospital information systems (HIS).
• Strategies to handle partial data consistency and redundancy.
• Implementation without significant operational or maintenance liability for existing HIS.

Main Results:

• A consolidated data mart is created from multiple, unconnected hospital information systems (HIS).
• The system effectively integrates research-relevant data, simplifying data preparation for studies.
• Challenges of data consistency and redundancy are addressed within the data mart.

Conclusions:

• The proposed data mart solution facilitates heart surgery research by consolidating data from diverse HIS.
• This approach simplifies data management for clinical reporting, quality assessment, and large-scale studies.
• The solution minimizes risks associated with integrating legacy and real-time data from autonomous hospital systems.