Tagged articles
Global Index
11 articles · Page 1 of 1
This article explains how EMR Serverless StarRocks leverages Paimon Global Index, including BTree for high-selectivity scalar filters and vector indexes for approximate nearest neighbor search, detailing the two-phase query architecture, index creation, SQL usage, and combined scalar-vector query execution.
ANNBTree IndexGlobal Index
0 likes · 27 min read

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

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

StarRocks now fully supports Paimon 2.0, enabling multimodal lakehouse workloads where columnar scans, scalar/vector/full-text indexes, and BLOB fetches coexist in one SQL execution framework, backed by Row Tracking and Data Evolution for incremental feature backfill.
Data EvolutionGlobal IndexPaimon
0 likes · 25 min read

StarRocks now fully supports Paimon 2.0, integrating columnar analytics with vector, full-text, and scalar indexes into a single SQL execution framework for multimodal lakehouse workloads, enabling unified data management, retrieval, and relational analysis on object storage without data movement.
Data EvolutionGlobal IndexMultimodal Data
0 likes · 34 min read

This article explains a distributed‑computing approach for generating a globally unique integer index from massive string datasets, replacing single‑reducer sorting with hash‑bucket partitioning and parallel processing to cut runtime from 30 minutes to just 2 minutes.
Global IndexSQL Optimizationbig data
0 likes · 5 min read

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

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

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

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

This article explains how Apache Phoenix implements global secondary indexes using separate HBase tables, demonstrates index creation and data synchronization with example SQL, and provides design guidelines to optimize query latency and avoid full‑table scans in big‑data environments.
Global IndexHBasePhoenix
0 likes · 4 min read
