Tag Platform — 2 Technical Articles

Nov 24, 2020 · Databases

How ClickHouse Enables Millisecond‑Scale User Profiling for Hundreds of Millions

This article explains how Suning built a high‑performance user‑tag platform on ClickHouse, replacing Elasticsearch with bitmap‑based storage and a new architecture that delivers sub‑second profiling queries for over 600 million users, detailing the design, implementation, and future enhancements.

Big DataBitmapClickHouse

0 likes · 14 min read

How ClickHouse Enables Millisecond‑Scale User Profiling for Hundreds of Millions

Suning Technology

Nov 16, 2020 · Databases

How ClickHouse Powers Real-Time User Profiling for Millions of Users

This article explains how Suning built a massive user‑tag platform using ClickHouse and RoaringBitmap to enable second‑level user profiling for over 600 million users, covering tag generation, storage, query architecture, and performance optimizations for marketing campaigns.

BitmapClickHouseSQL

0 likes · 13 min read

How ClickHouse Powers Real-Time User Profiling for Millions of Users