Skip to content
Tagged articles

Global Index

11 articles · Page 1 of 1
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Nov 6, 2026 · Big Data

EMR Serverless StarRocks + DLF Paimon: Multimodal Data Lake Retrieval for Autonomous Driving

This article details Alibaba Cloud's architecture for multimodal data lake retrieval using EMR Serverless StarRocks and DLF Paimon, covering design principles like early filtering and on-demand reading, Global Index mechanics, format selection between Paimon and Lance, real-world deployments in Alibaba's A Lake and AI Data platforms, and a complete autonomous driving loop from bad case detection to model validation.

Autonomous DrivingDLF PaimonData Lake Architecture
0 likes · 28 min read
EMR Serverless StarRocks + DLF Paimon: Multimodal Data Lake Retrieval for Autonomous Driving
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Nov 4, 2026 · Big Data

EMR Serverless StarRocks Supports Paimon 2.0 for Multimodal Analytics & Retrieval

Alibaba Cloud's EMR Serverless StarRocks now fully supports Apache Paimon 2.0, enabling unified multimodal analytics and retrieval by integrating vector search, full-text search, scalar filtering, and BLOB handling within a single lakehouse architecture, with best practices for data management and query optimization.

Data EvolutionEMR ServerlessGlobal Index
0 likes · 29 min read
EMR Serverless StarRocks Supports Paimon 2.0 for Multimodal Analytics & Retrieval
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 22, 2024 · Databases

Understanding Global vs Local Indexes in OceanBase and Their Impact on Query Performance

This article explains the differences between global and local indexes in OceanBase, analyzes why queries using global unique indexes run significantly faster than those using local indexes during Oracle migration, and provides detailed SQL examples, execution plans, and performance testing results to guide database optimization.

Database MigrationGlobal IndexLocal Index
0 likes · 32 min read
Understanding Global vs Local Indexes in OceanBase and Their Impact on Query Performance
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 25, 2023 · Databases

Understanding and Optimizing Indexes in OceanBase

This article explains the concepts of local and global indexes in OceanBase, demonstrates how to create tables and indexes, compares six practical scenarios—including no index, local index, partitioned queries, unique and global indexes—and provides performance metrics to guide database optimization.

Global IndexLocal IndexOceanBase
0 likes · 8 min read
Understanding and Optimizing Indexes in OceanBase
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 29, 2023 · Databases

Understanding Local and Global Indexes in OceanBase

The article explains the concepts, differences, and practical usage scenarios of local (partition‑aligned) and global indexes in OceanBase, providing SQL examples for queries with and without partition keys and guidance on creating unique indexes using either index type.

Global IndexLocal IndexOceanBase
0 likes · 7 min read
Understanding Local and Global Indexes in OceanBase
dbaplus Community
dbaplus Community
Jul 20, 2022 · Databases

From Middleware to Distributed Database: The Evolution of PolarDB‑X

PolarDB‑X evolved from Alibaba’s internal sharding middleware TDDL to the DRDS cloud service and finally to a fully distributed MySQL‑compatible database, introducing a full SQL optimizer, MPP engine, global secondary indexes, strong‑consistent distributed transactions via TSO + 2PC, and full binlog compatibility.

Global IndexMySQL CompatibilityOptimizer
0 likes · 26 min read
From Middleware to Distributed Database: The Evolution of PolarDB‑X