Using Denodo and Google Pub/Sub for Unified Data Access Across Distributed Healthcare Systems

Healthcare organizations increasingly operate across distributed environments with disparate data sources, creating challenges for unified data access and real-time analytics. This paper presents a comprehensive architectural framework leveraging Denodo’s data virtualization platform and Google Cloud Pub/Sub messaging service to achieve seamless data integration across distributed healthcare systems. Through a systematic analysis of implementation strategies, performance characteristics, and security considerations, we demonstrate how this hybrid approach addresses challenges in healthcare data management while maintaining compliance with regulatory requirements such as HIPAA and GDPR. Prototype results suggest the architecture may reduce data integration complexity by up to 65% while improving real-time data availability by 78% compared to traditional extract-transform-load (ETL) approaches. Initial testing showed query latency improved by up to 40%, with data freshness reduced from 5 minutes to under 1 second through event-driven synchronization. The framework supports both batch and streaming data processing patterns, enabling healthcare organizations to achieve unified data access without compromising on security, performance, or regulatory compliance.