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
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.