Hologres is a real-time data warehouse compatible with PostgreSQL. It integrates with the Alibaba Cloud big data ecosystem and supports connections to third-party Business Intelligence (BI) tools for real-time and offline data analytics.
Real-time data warehouse
Stream business data through Realtime Compute for Apache Flink for extract, transform, load (ETL) processing, then query the results in Hologres with sub-second latency. Connect Hologres to BI tools for live dashboards and reports.
Typical applications:
Real-time dashboards and reports -- Display up-to-date business metrics without batch delays.
Real-time monitoring and alerting -- Detect anomalies in O&M and application data as they occur, trigger alerts, and support real-time debugging.
Real-time business decisions -- Power risk control, recommendation, effect analytics, and training with current data.
MaxCompute query acceleration
Query data stored in MaxCompute directly from Hologres without moving it, or import MaxCompute data into Hologres for faster access. Connect BI tools to Hologres for interactive analysis of offline datasets.
Typical applications:
Interactive queries on offline data -- Run ad hoc queries against MaxCompute tables at interactive speeds.
Offline reporting -- Analyze offline MaxCompute data and generate reports.
Data serving -- Expose MaxCompute table data through a RESTful API for online applications.
Federated analytics on real-time and offline data
Split data by access frequency: store hot data (frequently accessed) in Hologres and cold data (infrequently accessed) in MaxCompute. Hologres runs federated queries across both stores. Connect BI tools to run queries that range from simple lookups to cross-dataset analysis.
