HybridDB for MySQL for Online and Offline Data Separation

You may choose to opt for online and offline data separation to ensure the capacity of the operational database.

Use Kettle to Import Data to AnalyticDB for PostgreSQL

In this blog, you will learn about Kettle and how you can use Kettle to migrate data to AnalyticDB for PostgreSQL

Using HybridDB/PostgreSQL to Find the Best Product Combination for Marketing

In this blog, we look at how statistical analysis can help enterprises determine the perfect product combination for marketing.

GIS-based Grid Operations of New Retail Merchants

In today's retail industry, data must be used to its greatest value if online and offline business are to be integrated and inventories optimized.

Pan-Chinese Electricity Grid System: Real-Time OLTP and OLAP Database Design

This article discusses the pan-Chinese electricity grid system and its database design for real-time computation of massive amounts of data.

PostgreSQL Database Design for Pivot Data Analysis

This article discusses database design for audio/video/picture (pan-content) website data pivot analysis with ApsaraDB RDS for PostgreSQL and HybridDB for PostgreSQL.

Principles and Optimization of 5 PostgreSQL Indexes (btree,hash,gin,gist,and brin)

What are the different indexes of PostgreSQL for? How can we optimize our database with these indexes?