How StarRocks Enables Real-Time Updates in Analytical Databases

The article explains why analytical databases struggle with real‑time data changes due to columnar storage, complex indexes and distributed processing, and then details StarRocks' primary‑key model, adaptive update mode, bitmap indexes, row/column partial updates, and practical SQL upsert techniques to achieve low‑latency updates without sacrificing query performance.

Analytical DatabasePartial UpdateReal-Time Update

0 likes · 15 min read

How StarRocks Enables Real-Time Updates in Analytical Databases

58 Tech

Mar 8, 2021 · Fundamentals

Real‑Time Inverted Index Update Techniques in the 58 Search Engine

This article explains how the 58 search engine achieves millisecond‑level real‑time inverted‑index updates by redesigning the underlying data structures, combining static and dynamic indexing, using a chain‑array hybrid, segment merging strategies, and lock‑free read‑write concurrency while maintaining search performance.

Data StructuresReal-Time UpdateSegment Merging

0 likes · 18 min read