Tagged articles
AnalyticDB
13 articles · Page 1 of 1
This guide explains how to overcome MySQL analytical performance bottlenecks by integrating AnalyticDB MySQL with Data Transmission Service (DTS), covering architecture, resource setup, test data creation, real‑time synchronization, and high‑performance SQL queries using window functions.
AnalyticDBCloud Data WarehouseDTS
0 likes · 18 min read

This article introduces the AnalyticDB Spark architecture, explains the need for Spark vectorization, surveys industry vectorized solutions, details ADB Spark's own vectorized implementation with Gluten and Velox, and presents performance test results showing a 6.98‑fold speedup over open‑source Spark.
AnalyticDBGlutenSpark
0 likes · 9 min read

This article presents a comprehensive technical overview of Alibaba Cloud AnalyticDB MySQL and its Serverless Spark integration, detailing architecture, core optimizations, security enhancements, and real‑world case studies that demonstrate how to achieve cost‑effective, high‑performance data lake analytics.
AnalyticDBCloud DatabaseSpark
0 likes · 19 min read

This article explains why combining large language models with vector databases enables enterprises to create specialized, up‑to‑date chatbots, outlines the underlying principles, describes the ADB‑PG vector‑search capabilities, and provides step‑by‑step implementation details including data processing, indexing, and query examples.
AnalyticDBLLMSQL
0 likes · 17 min read

This article details the common pitfalls encountered when synchronizing Oracle databases to AnalyticDB PostgreSQL, covering null versus empty string handling, data type conversion challenges, character set issues, special character processing, and comprehensive testing strategies to ensure data consistency and performance.
AnalyticDBDatabase TestingNULL handling
0 likes · 17 min read

By migrating a latency‑heavy MySQL query to AnalyticDB, employing binlog‑based real‑time sync, refining composite indexes, adding clustering and filter hints, and batching inserts, the team cut execution time from about two seconds to roughly one hundred milliseconds, achieving over 99 % of queries under one second.
AnalyticDBIndexingMySQL
0 likes · 12 min read

This article explains how AnalyticDB MySQL’s elastic mode separates compute and storage to improve scalability, describes industry trends, details its architecture layers, presents performance test results on TPCH Q1, and outlines future enhancements for cloud‑native data warehousing.
AnalyticDBElastic Scalingcompute-storage separation
0 likes · 14 min read


ITPUBMay 14, 2021 · Big Data
The article details how Alibaba’s Data Bank leverages AnalyticDB’s cold‑hot tiered storage, high‑throughput real‑time writes, and low‑latency OLAP capabilities to handle petabyte‑scale consumer data, support flexible AIPL analysis, crowd profiling, and rapid audience selection while cutting costs and ensuring elasticity during peak events.
AnalyticDBCold-Hot StorageOLAP
0 likes · 14 min read

This article explains the HTAP concept, describes AnalyticDB PostgreSQL’s shift from a single‑master to a Multi‑Master design, details the architecture, distributed transaction handling, global deadlock detection, DDL support, fault tolerance, and presents benchmark results that demonstrate linear scalability for real‑time data‑warehouse workloads.
AnalyticDBDatabase ArchitectureHTAP
0 likes · 23 min read

AnalyticDB, a cloud‑native MySQL‑compatible data warehouse, delivered extreme performance during Double 11 by handling billions of orders with ultra‑high write TPS, while introducing compute‑storage separation, hot‑cold tiering, resource groups, elastic scaling and intelligent optimization to meet demanding real‑time analytics workloads.
AnalyticDBResource Groupsbig data
0 likes · 17 min read

This article provides a comprehensive analysis of Alibaba Cloud's AnalyticDB MySQL 3.0, detailing its cloud‑native architecture, storage and query innovations, the record‑breaking TPC‑DS benchmark results, and future directions for large‑scale, cost‑effective data warehousing.
AnalyticDBDatabase ArchitectureTPC-DS
0 likes · 21 min read

This article examines the rapid rise of cloud‑native databases, detailing market trends, architectural innovations such as shared storage and shared‑nothing designs, and showcasing Alibaba Cloud's POLARDB, POLARDB‑X, AnalyticDB, and autonomous tuning platform iBTune, while highlighting security and high‑availability advancements.
AnalyticDBPolarDBautonomous tuning
0 likes · 19 min read

This article provides an in‑depth technical overview of Alibaba's AnalyticDB, covering the challenges of massive real‑time analytics, the cloud‑native multi‑tenant architecture, data model, import/export capabilities, high‑performance SQL parser, the Xuanwu storage engine, Xihe compute engine, optimizer, GPU acceleration, and elastic scaling features.
AnalyticDBGPU accelerationSQL Parser
0 likes · 38 min read
