Hologres

Announcements and Updates

• Release notes
• Default behavior changes

Product Introduction

• What is Hologres?
• Benefits
• Scenarios
• Core technical capabilities
• Terms

Pricing

• Billing overview
• Subscription
• Pay-as-you-go
• Change the billing method
• Expiration and arrears alerts and suspension policies
• Manage renewals

Getting Started

• Procedure to use Hologres
• Create an Alibaba Cloud account
• Purchase a Hologres instance
• Create a database
• HoloWeb quick start
• Query data in Hologres
• Grant permissions to a RAM user

Manage Instances

• Endpoints for connecting to Hologres
• Instance types
• Hologres Console
• Use resource groups to manage instances

Common Development Tools

• Overview
• DataWorks
• HoloWeb
• Use the PostgreSQL client to connect to Hologres
• Use JDBC to connect to Hologres
• Use Holo Client to read and write data
• Use Python to connect to Hologres
• DataGrip
• Navicat
• Apache Nifi
• SQL Workbench/J

User Authorization

• Permission management overview
• Overview
• Grant permissions on Hologres to RAM users
• RAM authorization mode
• Hologres permission models
• Authorization operations

Data Synchronization

• Batch synchronization
• Real-time data writing

Developer Guide

• Hologres development standards
• Data types
• DDL
• DML and DQL
• Advanced features
• Functions
• Extension functions
• System parameter setting
• OTHER SQL

Common BI Tools

• Overview
• Apache Superset
• Apache Zeppelin
• Dataiku
• DataV
• DataWorks DataService Studio
• Grafana
• IBM Cognos Analytics
• Metabase
• Power BI
• Qlik
• Quick BI
• Redash
• SAP BusinessObjects
• Tableau

Monitoring And Alerting

• Instance updates
• Resource isolation and high availability
• Monitoring and alert
• Connection and SQL
• Backup and Recovery (Beta)
• Storage optimization

Data Migration

• Replace Lightning with Hologres
• Migrate data from MySQL to Hologres
• Migrate data from ClickHouse to Hologres
• Migrate data from HBase to Hologres
• Use Holo Shipper

Security Management

• Security white paper
• Data masking
• Configure an IP address whitelist
• Query event logs
• Data encryption
• Data Map (Beta)
• SSL-encrypted transmission (Beta)

Shared Cluster (BI-based MaxCompute Acceleration Edition)

• Overview
• Billing
• Usage notes
• Manage instances in the console
• Migrate services from Lightning to Shared Cluster (BI-based MaxCompute Acceleration Edition)

Performance Optimization

• Optimize the performance of internal table queries
• Query key-value pairs
• Clustering key
• Optimize the performance of querying MaxCompute tables in Hologres
• FAQ about OOM

Performance Testing

• TPC-H test
• Performance comparison testing between Hologres and ClickHouse

Best Practices

• Data warehouse construction
• Authorization
• Scenario Scheme

FAQ

• Limits
• FAQ about SQL statements
• Common errors and troubleshooting of integration with MaxCompute
• Troubleshoot Blink and Flink issues
• Metric FAQ
• FAQ about DataWorks Data Integration
• Permissions

Agreements

• Runtime Lifecycle Policy and Hologres versions