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 DataClickHouseOLAP

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.

ClickHouseSQLTag Platform

0 likes · 13 min read

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