Tagged articles
19 articles
Page 1 of 1
Architect's Journey
Architect's Journey
Aug 15, 2025 · Backend Development

Designing the Evolution of an Order Middle Platform: From Pain Points to a Big‑Platform + Small‑Chimney Architecture

The article analyzes the current pain points of an order middle platform, proposes standardized core field storage, evaluates four extension storage schemes (vertical tables, wide table, JSON, KV table), and presents a two‑stage implementation roadmap that combines a large middle platform with a small‑chimney architecture for unified ordering, querying, and operational workflows.

DDDJSON extensionKV table
0 likes · 12 min read
Designing the Evolution of an Order Middle Platform: From Pain Points to a Big‑Platform + Small‑Chimney Architecture
Alibaba Cloud Developer
Alibaba Cloud Developer
Aug 5, 2025 · Databases

How PolarDB IMCI Unifies Vector Search and Embedding in One SQL Engine

This article explains how PolarDB IMCI integrates vector indexing and embedding directly into the database kernel, offering a unified, transactional, and real‑time vector lifecycle management service that lets developers build RAG knowledge bases and AI applications using only standard SQL, dramatically reducing development and operational complexity.

AIPolardbRAG
0 likes · 11 min read
How PolarDB IMCI Unifies Vector Search and Embedding in One SQL Engine
Alibaba Cloud Developer
Alibaba Cloud Developer
Jun 5, 2025 · Databases

Enable Native Multimodal AI Search with SQL on PolarDB

This article explains how to use standard SQL on PolarDB PostgreSQL to directly invoke multimodal AI services for image feature extraction and vectorization, eliminating data migration and complex toolchains while providing low‑threshold integration, flexible scenario adaptation, full‑link security, and serverless, pay‑as‑you‑go deployment.

Multimodal AIPolardbSQL
0 likes · 6 min read
Enable Native Multimodal AI Search with SQL on PolarDB
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 24, 2025 · Databases

Migrating from PolarDB PostgreSQL to OceanBase (ob_oracle): A Comprehensive Guide

This article presents a step‑by‑step migration plan for moving a PolarDB PostgreSQL 11.9 tenant to an OceanBase 4.2.1.10 Oracle‑compatible tenant, covering background, scope, task distribution, user and permission conversion, table‑structure transformation, DataX data transfer, performance tuning, error handling, monitoring, and final recommendations.

DataXOceanBasePolardb
0 likes · 14 min read
Migrating from PolarDB PostgreSQL to OceanBase (ob_oracle): A Comprehensive Guide
Inke Technology
Inke Technology
Apr 23, 2024 · Databases

How We Scaled a High‑Traffic Messaging Service by Migrating MySQL to PolarDB

This article details the migration of a popular social app's private‑message service from a saturated MySQL cluster to PolarDB, covering business challenges, evaluation of storage‑optimization, vertical and horizontal scaling, the chosen distributed database solution, step‑by‑step offline and online migration procedures, and the resulting performance and cost benefits.

PolardbScalabilitydatabase migration
0 likes · 12 min read
How We Scaled a High‑Traffic Messaging Service by Migrating MySQL to PolarDB
ITPUB
ITPUB
Sep 11, 2023 · Databases

Inside Alibaba Cloud’s Yaochi Database: Market Outlook, AI Fusion, and Open‑Source Strategy

In this interview, Alibaba Cloud’s database product leader Wang Yuan shares his market‑size calculations for China’s database sector, discusses the challenges facing dozens of domestic vendors, outlines Yaochi’s cloud‑native vision, AI‑driven features, PolarDB innovations, and the company’s open‑source approach.

AIMarket analysisPolardb
0 likes · 21 min read
Inside Alibaba Cloud’s Yaochi Database: Market Outlook, AI Fusion, and Open‑Source Strategy
Alibaba Cloud Developer
Alibaba Cloud Developer
Nov 9, 2022 · Databases

Why Alibaba’s PolarDB Open‑Source Strategy Is a Game‑Changer for Cloud‑Native Databases

The October 25th PolarDB open‑source summit in Hangzhou gathered Alibaba Cloud executives, ecosystem partners and developers to discuss the daring decision to open‑source the flagship cloud‑native database, its compatibility and openness principles, real‑world case studies, and future trends shaping the next generation of distributed databases.

Alibaba CloudCloud NativeDistributed
0 likes · 20 min read
Why Alibaba’s PolarDB Open‑Source Strategy Is a Game‑Changer for Cloud‑Native Databases
Alibaba Cloud Developer
Alibaba Cloud Developer
Sep 21, 2022 · Databases

How Elastic Multi‑Node Parallel Query Supercharges PolarDB MySQL Performance

This article explains the background, concept, advantages, applicable scenarios, technical implementation, and performance evaluation of Elastic Parallel Query (ePQ) in PolarDB MySQL, showing how multi‑node parallelism leverages idle CPU resources, adaptive scheduling, and cloud‑native architecture to accelerate large‑scale analytical workloads while maintaining HTAP capabilities.

Distributed ExecutionElastic Parallel QueryPolardb
0 likes · 29 min read
How Elastic Multi‑Node Parallel Query Supercharges PolarDB MySQL Performance
Alibaba Cloud Developer
Alibaba Cloud Developer
Nov 5, 2021 · Databases

How PolarDB MySQL’s In‑Memory Column Index Supercharges HTAP Performance

This article explains how PolarDB MySQL introduces an In‑Memory Column Index (IMCI) to combine row‑store OLTP strength with column‑store analytical speed, detailing the architectural innovations, optimizer decisions, data organization, resource isolation strategies, and benchmark results that show IMCI achieving tens to hundreds of times faster query execution than native MySQL and matching ClickHouse performance.

Column StoreDatabase OptimizationHTAP
0 likes · 32 min read
How PolarDB MySQL’s In‑Memory Column Index Supercharges HTAP Performance
Alibaba Cloud Developer
Alibaba Cloud Developer
Oct 25, 2021 · Databases

How PolarDB’s In-Memory Column Index Turns MySQL into a High‑Performance HTAP Engine

This article explores PolarDB MySQL’s In‑Memory Column Index (IMCI) technology, detailing its hybrid row‑column storage architecture, optimizer enhancements, parallel execution engine, and performance gains that enable real‑time analytical queries alongside OLTP workloads, and compares its benchmarks against MySQL and ClickHouse.

Column StoreDatabase OptimizationHTAP
0 likes · 32 min read
How PolarDB’s In-Memory Column Index Turns MySQL into a High‑Performance HTAP Engine
Alibaba Cloud Developer
Alibaba Cloud Developer
Jun 2, 2021 · Databases

How PolarDB Guarantees Transaction Atomicity: From WAL to Visibility

This article explains how PolarDB ensures transaction atomicity by analyzing ACID principles, detailing the shortcomings of simple Direct‑IO and Buffer‑IO, introducing write‑ahead logging, full‑page backup, checkpointing, visibility mechanisms, and distinguishing durability and atomicity points to achieve reliable crash recovery and consistent data visibility.

PolardbWALatomicity
0 likes · 30 min read
How PolarDB Guarantees Transaction Atomicity: From WAL to Visibility
Fulu Network R&D Team
Fulu Network R&D Team
Nov 2, 2020 · Databases

Optimizing Large MySQL Tables on Alibaba Cloud: Design, Indexing, PolarDB Migration, X‑Engine Partitioning, and Parallel Query

This article details how to improve performance of massive MySQL tables on Alibaba Cloud by redesigning schemas and indexes, migrating to PolarDB with read‑write separation, partitioning historical data using the X‑Engine storage engine, and leveraging PolarDB's parallel query capabilities for faster analytics.

Database OptimizationParallel QueryPartitioning
0 likes · 12 min read
Optimizing Large MySQL Tables on Alibaba Cloud: Design, Indexing, PolarDB Migration, X‑Engine Partitioning, and Parallel Query
IT Architects Alliance
IT Architects Alliance
Aug 11, 2020 · Industry Insights

How Alibaba and Tencent Cloud Databases Compete in the Chinese Market

This article analyzes the features, performance benchmarks, market share growth, and use‑case scenarios of Alibaba Cloud's PolarDB, OceanBase and other services alongside Tencent Cloud's MySQL, CynosDB and related offerings, highlighting how each provider positions its cloud database portfolio in China’s fast‑growing market.

Alibaba CloudCloud DatabasesCynosDB
0 likes · 11 min read
How Alibaba and Tencent Cloud Databases Compete in the Chinese Market
Alibaba Cloud Developer
Alibaba Cloud Developer
May 28, 2019 · Databases

How Cloud‑Native Databases Are Redefining the Future of Data Management

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.

AnalyticDBDistributed SystemsPolardb
0 likes · 19 min read
How Cloud‑Native Databases Are Redefining the Future of Data Management