Real-time OLAP | BestHub

DataFunSummit

Mar 1, 2025 · Databases

Innovations and Breakthroughs of ClickHouse in Real‑Time OLAP

This article introduces ClickHouse as an open‑source column‑store OLAP database, outlines its core features, explains its distributed and cloud‑native architectures—including SharedMergeTree for serverless operation—presents benchmark results, compares community and enterprise editions, and answers common questions about its future direction.

ClickHouseCloud NativeReal-time OLAP

0 likes · 15 min read

Innovations and Breakthroughs of ClickHouse in Real‑Time OLAP

DataFunTalk

Jun 10, 2024 · Big Data

Data Lake Development Trends, Architecture, Integration, and Lakehouse Core Capabilities

This article reviews the latest developments in data lakes, including trend analysis, overall architecture, data integration methods, Lakehouse core capabilities, open design principles, stream‑batch unified processing, real‑time OLAP, and lake‑internal warehousing, highlighting how these advances reduce complexity and cost while improving data sharing and performance.

Real-time OLAPStream-Batch Integrationbig data architecture

0 likes · 14 min read

Data Lake Development Trends, Architecture, Integration, and Lakehouse Core Capabilities

DataFunSummit

Apr 25, 2024 · Big Data

Paimon Project Overview: Recent Developments, Core Capabilities, and Future Roadmap

This article presents a comprehensive overview of the Apache‑incubated Paimon project, covering its evolution from Flink Table Store, the current features of primary‑key and log tables, management tools such as snapshots, tags and branches, performance optimizations for Flink and Spark, and a detailed roadmap of upcoming functionalities.

FlinkPaimonReal-time OLAP

0 likes · 23 min read

Paimon Project Overview: Recent Developments, Core Capabilities, and Future Roadmap

DataFunTalk

Sep 17, 2023 · Cloud Native

REDck: A Cloud‑Native Real‑Time Data Warehouse Built on ClickHouse

REDck is a cloud‑native, storage‑compute separated real‑time OLAP data warehouse derived from ClickHouse that addresses scalability, operational cost, and reliability challenges through a unified metadata service, object‑storage optimizations, multi‑level caching, distributed task scheduling, and two‑phase commit transactions.

ClickHouseCloud NativeReal-time OLAP

0 likes · 18 min read

REDck: A Cloud‑Native Real‑Time Data Warehouse Built on ClickHouse

DataFunSummit

Sep 8, 2023 · Big Data

Tianqiong OLAP Real‑time Lakehouse Fusion Platform Architecture Practice

This article explains why lake‑warehouse fusion is needed, describes the challenges of integrating real‑time data warehouses with data lakes, introduces a new StarRocks‑based architecture that supports real‑time ingestion, cooling, offline loading, and adaptive hot‑cold query rewriting, and outlines future plans and Q&A.

Real-time OLAPStarRocksbig data

0 likes · 21 min read

Tianqiong OLAP Real‑time Lakehouse Fusion Platform Architecture Practice

Xiaohongshu Tech REDtech

Sep 6, 2023 · Databases

REDck: A Cloud‑Native Real‑Time OLAP Data Warehouse Built on ClickHouse

REDck is a cloud‑native, real‑time OLAP data warehouse built on ClickHouse that adds elastic compute and storage scaling, object‑storage optimizations, multi‑level caching, and exactly‑once ingestion, delivering petabyte‑scale interactive analytics with ten‑fold CPU efficiency, ten‑fold cost reduction, and 99.9% availability.

ClickHouseCloud NativeReal-time OLAP

0 likes · 21 min read

REDck: A Cloud‑Native Real‑Time OLAP Data Warehouse Built on ClickHouse

Xueersi Online School Tech Team

Sep 10, 2021 · Big Data

Real‑time OLAP with Flink and Hologres: Replacing Lambda/Kappa Architectures

This article analyzes the limitations of traditional Lambda and Kappa big‑data architectures for online‑school behavior‑feature pipelines and presents a Flink + Hologres solution that provides unified real‑time OLAP and high‑concurrency point‑query services, including design choices, implementation details, and performance results.

FlinkHologresKappa architecture

0 likes · 12 min read

Real‑time OLAP with Flink and Hologres: Replacing Lambda/Kappa Architectures

Big Data Technology Architecture

May 13, 2021 · Big Data

Real-Time OLAP Evolution and Production Optimization at BTC.com

This article details BTC.com’s journey from a legacy batch‑oriented analytics stack to a modern real‑time OLAP architecture using Flink, ClickHouse, Kafka, and Kubernetes, highlighting the business drivers, technical choices, architectural evolution, optimizations, and future directions.

ClickHouseFlinkKafka

0 likes · 9 min read

Real-Time OLAP Evolution and Production Optimization at BTC.com

DataFunTalk

Apr 15, 2021 · Big Data

Technical Evolution and Production Optimization of Real‑Time OLAP at BTC.com

This article details BTC.com’s journey in building a real‑time OLAP platform for blockchain data, covering business background, challenges, architectural evolution, technology choices such as Flink and ClickHouse, optimization techniques, monitoring, and future directions.

ClickHouseFlinkReal-time OLAP

0 likes · 10 min read

Technical Evolution and Production Optimization of Real‑Time OLAP at BTC.com

HomeTech

Jun 17, 2020 · Big Data

Apache Kylin at AutoHome: Development History, Architecture, Optimizations, and Future Plans

This article details AutoHome's use of Apache Kylin as its core OLAP engine, covering its development timeline, architecture, large‑scale cube deployment, performance optimizations, cluster upgrade experiences, and future directions such as real‑time OLAP and cloud‑native deployment.

Apache KylinCloud NativeOLAP

0 likes · 23 min read

Apache Kylin at AutoHome: Development History, Architecture, Optimizations, and Future Plans

DataFunTalk

Jun 14, 2020 · Big Data

Practical Experience and Optimization of Apache Druid for Real‑Time OLAP at iQIYI

This article describes how iQIYI evaluated various OLAP engines, selected Apache Druid for real‑time analytics, detailed its architecture, identified performance bottlene‑cks in Coordinator, Overlord and indexing, applied configuration and resource‑allocation optimizations, and built a user‑friendly RAP platform to democratize real‑time data analysis.

Apache DruidPerformance OptimizationReal-time OLAP

0 likes · 15 min read

Practical Experience and Optimization of Apache Druid for Real‑Time OLAP at iQIYI

Big Data Technology Architecture

Jun 11, 2020 · Big Data

Kylin at Autohome: Development History, Deployment Practices, Optimizations, and Future Roadmap

This article details Autohome's use of Apache Kylin as its core OLAP engine, covering its architecture, large‑scale Cube deployment, real‑world business applications, a series of performance and operational optimizations, cluster upgrade experiences, and upcoming plans for real‑time OLAP and cloud‑native evolution.

Cloud NativeKylinOLAP

0 likes · 24 min read

Kylin at Autohome: Development History, Deployment Practices, Optimizations, and Future Roadmap

iQIYI Technical Product Team

May 29, 2020 · Big Data

Real-Time OLAP with Apache Druid at iQiyi: Architecture, Optimizations, and Platform Practices

iQiyi replaced its offline OLAP stack with Apache Druid, leveraging its real‑time, multi‑dimensional engine and a five‑component architecture, while solving coordinator and overlord bottlenecks, optimizing indexing resources, adopting KIS mode, and building the self‑service RAP platform that now powers thousands of low‑latency dashboards.

Apache DruidKISPerformance Optimization

0 likes · 17 min read

Real-Time OLAP with Apache Druid at iQiyi: Architecture, Optimizations, and Platform Practices