Query Separation: Optimizing Large Table Reads by Decoupling Query Data

The article explains query separation as a technique to improve performance of massive business tables by storing write‑optimized data and query‑optimized data separately, discusses when to apply it, various implementation methods, storage options, and operational considerations such as MQ handling and consistency.

Asynchronous ReplicationElasticsearchcold hot data

0 likes · 10 min read

Query Separation: Optimizing Large Table Reads by Decoupling Query Data

Full-Stack Internet Architecture

Jun 24, 2021 · Databases

Common Solutions for Massive Data Storage and High‑Performance Access

The article outlines a range of techniques—including caching, read‑write splitting, vertical partitioning, sharding, cold‑hot data separation, Elasticsearch, NoSQL and NewSQL—to store and retrieve billions of user‑generated records efficiently while maintaining high throughput and low latency.

NoSQLcold hot datadatabases

0 likes · 17 min read

Common Solutions for Massive Data Storage and High‑Performance Access

Alibaba Cloud Developer

Apr 6, 2021 · Databases

How Tiered Storage Cuts Data Warehouse Costs: Strategies and Best Practices

This article explains how tiered storage in cloud‑native data warehouses like AnalyticDB MySQL reduces storage costs while maintaining performance by separating hot and cold data, automating migration, and optimizing cold‑data access through caching and archiving techniques.

AnalyticDB MySQLCost Optimizationcold hot data

0 likes · 15 min read

How Tiered Storage Cuts Data Warehouse Costs: Strategies and Best Practices