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
Query Responses on MaxCompute Data Obtained in Seconds
MaxCompute is the computing core of Alibaba data mid-platform and provides basic big data services. Hologres provides breakthroughs in analysis and exploration of data in MaxCompute. It allows you to query and analyze large volumes of data with high concurrency and low latency.
Customer Benefits
Real-Time Responses to Analysis Requests
- Hologres responds to interactive queries of MaxCompute data within seconds and converts cold data to analysis results that are easy to understand. No extra ETL workload is required.
Low Cost
- Hologres is interconnected with MaxCompute. You do not need to export data for analysis. This reduces the data storage and maintenance costs.
Ease of Use
- Hologres is compatible with PostgreSQL and seamlessly connected with analysis tools. You can easily get started with Hologres.
Real-Time User Operations Platform
The real-time user operations platform provides detailed insights into users. It monitors and analyzes user operations in real time from different perspectives and allows you to build appropriate policies to achieve refined user operations.
Challenges and Benefits
Technical Challenges
- Traditional real-time data warehouse solutions (stream computing + key-value/MySQL) are inflexible and incur high costs in terms of real-time user operations. Commonly used OLAP analysis engines cannot meet current performance requirements. A technical breakthrough is required.
Customer Benefits
- Hologres provides a real-time user dashboard. It supports user selection and targeted message delivery in real time. This allows you to provide accurate solutions for all users.
Refined Operations Platform for Alibaba Search and Recommendation Systems
Search, recommendation, and advertisement systems have accumulated huge amounts of user behavior and transaction data. To quickly respond to various operations requirements and cope with transaction peaks of e-commerce platforms in big promotion days, Alibaba integrates Realtime Compute (real-time computing), MaxCompute (offline data warehouse), and Hologres (interactive analysis). It builds a comprehensive, refined real-time operations solution based on a combination of users, products, and retail outlets.
Customer Benefits
Unified Real-Time Multidimensional Analysis Solution
- Alibaba Cloud big data services are integrated to form a unified real-time multidimensional analysis platform. It reduces resource consumption and improves data development efficiency.
Improvement of Business Insight Capability
- Hologres supports ad-hoc queries and analysis of PB-scale data in real time. It responds to unique visitor (UV) computing of 100 million records within seconds to facilitate user analysis and achieve traffic growth.
Quick Responses to Business Needs
- The refined operations platform allows you to integrate data from different sources, supports insight into data of different granularities, and offers various methods to process data. This improves the flexibility in data analysis.
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.
