Hologres

A real-time data warehouse for serving and analytics which is compatible with PostgreSQL.

In public beta (free of charge)
Please contact the email for more information: heyi.lym@alibaba-inc.com

High-Performance Multidimensional Analysis and Query in Real Time

Hologres is a cloud-native Hybrid Serving & Analytical Processing (HSAP) system that is seamlessly integrated with the big data ecosystem. You can use Hologres to analyze and process PB-scale data with high concurrency and low latency. With Hologres, you can use your business intelligence (BI) tools to analyze data in multiple dimensions and explore your business in real time.

Hologres eliminates the disadvantages of traditional real-time data warehousing solutions, such as data silos and data redundancy. It meets your requirements for data migration and real-time analysis of large volumes of data.

Benefits

  • Quick Response

    Responds to queries on PB-scale data at sub-second speeds. This response speed allows you to analyze data in multiple dimensions and explore your business in real time.

  • High Performance

    Supports highly concurrent writes and queries at a speed of up to 100 million transactions per second (TPS). Data can be queried immediately after it is written.

  • Low Cost

    Uses the compute-storage separation architecture. It allows you to dynamically upgrade or downgrade configurations and resize the storage capacity based on your business requirements.
    Reads data from offline data warehouses of MaxCompute for analysis.

  • High Reliability

    Stores multiple replicas of data by default based on the distributed high-availability architecture. The SLA level reaches 99.99%.

Features

Support for Various Query Modes

Stores data in column- or row-oriented mode. It also allows you to conduct simple, complex, or ad-hoc queries. Hologres can process a large volume of SQL statements concurrently in distributed mode. It returns query responses on large volumes of data at sub-second speeds. The resource utilization is high.

Complex Query on Big Data

Supports parallel computing and responds to federated analytics of PB-scale data at sub-second speeds.

Point Query on Big Data

Stores PB-scale data and writes or queries 100 million records per second. This is more than 10 times the performance of open source components.

Federated Computing

Seamlessly connects to MaxCompute. You can use Hologres to perform interactive analysis without the need to migrate data. Query results are quickly generated. You can use Hologres to query MaxCompute data or implement federated computing based on MaxCompute data and real-time data.

High Compatibility and Ease of Development

Compatible with the PostgreSQL ecosystem and seamlessly integrated with DataWorks. DataWorks is the big data computing engine and big data development platform of Alibaba Cloud. You can get started with Hologres without additional learning.

Compatibility with PostgreSQL

Compatible with the PostgreSQL ecosystem. Hologres provides the JDBC or ODBC API to interconnect with third-party extract, transform, and load (ETL) and BI tools, such as Tableau, QuickBI, and FineBI.

Integration with DataWorks

Seamlessly integrated with DataWorks to provide graphic, intelligent, and unified data warehousing and interactive analysis.

Writes and Updates Data in Real Time

Supports highly-concurrent writes and updates at a speed of up to 100 million TPS. Data can be queried immediately after it is written.

Procedure

1

Create Instance

Log on to the Hologres console and follow the purchase wizard to create a Hologres instance.


Learn More

2

Create Database

The system generates a database named Postgres for trial use.
Create a database for official use based on your business requirements.

Learn More

3

Connect to Development Tool

Connect to a terminal tool, open source tool, or Alibaba Cloud tool based on your data development requirements.

Learn More

4

Grant Permissions

Hologres is compatible with PostgreSQL 11. Use standard PostgreSQL statements to grant permissions.


Learn More

5

Develop Data

You can use standard PostgreSQL statements to perform interactive analysis and development or use open source or commercial management tools to design and manage databases.

Learn More

Typical Scenarios

Billing Methods

Pay-as-you-go

Pay-as-you-go applies to scenarios when computing or storage resources are unspecified.
You are billed based on the running durations of your instances, the size of stored data, and storage durations.

Subscription

Subscription applies to scenarios when Hologres is used for real-time analysis in the long term.
You need to estimate the required computing and storage resources based on your actual business scenario and purchase this service in subscription mode.

Explore More About Hologres?

Ready to Use Hologres?

Free Beta > Go to Hologres Console >