Hologres is a real-time interactive analytics engine compatible with the PostgreSQL ecosystem and integrates seamlessly with the big data ecosystem. Hologres supports real-time analytics of large amounts of real-time and offline data. You can use third-party Business Intelligence (BI) tools to connect to Hologres and analyze data in a visualized manner. This topic describes typical scenarios where the core features of Hologres are used.

Real-time data warehouse construction

Business data is written to Realtime Compute in real time for extract, transform, load (ETL) operations. The data then can be queried in Hologres in real time and exported to a third-party analytics tool for real-time analytics. Typical applications in this scenario include:
  • Real-time data warehouse, real-time dashboard, and real-time reporting and analytics in data departments.
  • Real-time monitoring, real-time exception detection and alerts, and real-time debugging in operations and maintenance (O&M) and data applications.
  • Real-time risk control, real-time recommendation, real-time effect analytics, and real-time training in business departments.
Real-time scenarios

Accelerated query of offline MaxCompute data

After business data is written to the offline data warehouse MaxCompute, you can directly query data by using Hologres or import data to Hologres for queries. You can use BI tools to connect to Hologres and analyze offline data in real time. Typical applications in this scenario include:
  • Query offline MaxCompute data in real time.
  • Generate reports based on offline MaxCompute data for analytics.
  • Apply offline MaxCompute data for online use. For example, expose your table data over a RESTful API.
Offline scenarios

Federated analytics on offline and real-time data

Business data is divided into hot data and cold data based on their access frequency. Cold data is stored in the offline data warehouse MaxCompute, whereas hot data is stored in Hologres. You can use Hologres to perform federated analytics on offline and real-time data. Connected to BI tools, Hologres can respond to business requirements of simple and complex queries.Federated analytics