Kylin | BestHub

Youzan Coder

Aug 8, 2023 · Big Data

Kylin4 Deployment and Performance Optimizations at Youzan

Since 2018 Youzan has migrated all online services to Kylin4, addressing long cube rebuilds, single‑point cache, CPU spikes, and throttling gaps by adding batch segment builds, low‑priority concurrency controls, Redis‑based query caching, parquet skew mitigation, range‑query acceleration, and class‑loader optimizations, which together doubled query‑per‑second capacity to 150, cut latency by up to 50 % and reduced CPU usage.

Big DataCubeKylin

0 likes · 17 min read

Kylin4 Deployment and Performance Optimizations at Youzan

HomeTech

Sep 13, 2022 · Big Data

Integrating Heterogeneous Data Sources with openLooKeng and Upgrading the Apache Kylin Connector at AutoHome

This article describes how AutoHome tackled the complexity of managing multiple relational, NoSQL, and Hive data stores by adopting openLooKeng for unified, cross‑source SQL queries, outlines its key features such as ANSI‑SQL support, diverse connectors, and query optimizations, and details the custom enhancements made to the Apache Kylin connector to better serve their commercial data analysis workloads.

Big DataKylinSQL

0 likes · 13 min read

Integrating Heterogeneous Data Sources with openLooKeng and Upgrading the Apache Kylin Connector at AutoHome

Ops Development Stories

Mar 24, 2022 · Operations

Step‑by‑Step Guide to Install a Ceph Cluster on Kylin v10

This article walks through the complete process of setting up a Ceph storage cluster on the domestically‑produced Kylin v10 operating system, covering hardware preparation, host configuration, manual installation of Ceph packages, monitor, OSD, and manager deployment with all necessary command‑line examples.

CephKylincluster

0 likes · 14 min read

Step‑by‑Step Guide to Install a Ceph Cluster on Kylin v10

DataFunTalk

Nov 6, 2021 · Big Data

Evolution and Practices of OLAP at Vipshop: Presto, ClickHouse, and Kylin

This article details Vipshop's OLAP evolution, covering the deployment, optimization, and containerization of Presto, ClickHouse, and Kylin, the challenges faced, self‑developed tooling, and future directions for intelligent scaling and resource management.

Big DataClickHouseFlink

0 likes · 27 min read

Evolution and Practices of OLAP at Vipshop: Presto, ClickHouse, and Kylin

DataFunTalk

Apr 17, 2021 · Big Data

Evolution of Beike's OLAP Platform Architecture: From Hive‑MySQL to Multi‑Engine Support

This article reviews the evolution of Beike's OLAP platform—from the early Hive‑to‑MySQL stage, through a Kylin‑based architecture, to a flexible multi‑engine solution—detailing the design choices, metric system, engine selection criteria, encountered challenges, and future development plans.

Big DataData WarehouseDruid

0 likes · 24 min read

Evolution of Beike's OLAP Platform Architecture: From Hive‑MySQL to Multi‑Engine Support

Big Data Technology Architecture

Mar 23, 2021 · Big Data

Integrating Apache Kylin with MLSQL for In‑Place ETL and Analytics

The article explains how Apache Kylin and MLSQL complement each other, detailing Kylin's OLAP strengths, MLSQL's data‑processing and AI capabilities, and demonstrates a low‑code integration that enables users to perform ETL directly within Kylin’s interface while outlining future deep‑link scenarios.

Big DataETLKylin

0 likes · 10 min read

Integrating Apache Kylin with MLSQL for In‑Place ETL and Analytics

DataFunSummit

Dec 11, 2020 · Big Data

58.com Big Data Application Practice: Architecture, Challenges, and Solutions

This article presents 58.com’s large‑scale big data platform, detailing its business scope, the WMDA one‑stop analytics system, the Wanxiang user‑portrait service, the technical challenges of massive daily data ingestion, multi‑dimensional analysis, OLAP engine selection (Kylin, Druid), bitmap‑based user‑group processing, scheduling, and overall data service architecture.

Big DataDruidKylin

0 likes · 13 min read

58.com Big Data Application Practice: Architecture, Challenges, and Solutions

Big Data Technology Architecture

Nov 21, 2020 · Big Data

Kylin 4.0 Performance Tuning Guide: Optimizing Cube Build and Query

The article introduces Kylin 4.0's major architectural upgrades, explains why previous tuning practices no longer apply, and provides a detailed performance‑tuning guide and video covering Cube build and query optimizations, along with additional reference resources.

Cube OptimizationKylinPerformance Tuning

0 likes · 4 min read

Kylin 4.0 Performance Tuning Guide: Optimizing Cube Build and Query

Beike Product & Technology

Nov 18, 2020 · Big Data

Evolution and Practice of BEIKE OLAP Platform Architecture and Engine Selection

This article details the three‑stage evolution of BEIKE's OLAP platform—from the early Hive‑to‑MySQL phase, through a Kylin‑based architecture, to a flexible multi‑engine design—explaining metric modeling, engine selection, performance trade‑offs, and future roadmap for supporting Druid, ClickHouse, Doris and real‑time analytics.

Big DataData WarehouseDruid

0 likes · 18 min read

Evolution and Practice of BEIKE OLAP Platform Architecture and Engine Selection

DataFunTalk

Aug 17, 2020 · Databases

Comparative Analysis of Kylin, Druid, and ClickHouse Data Models and Index Structures

This article compares the data modeling and indexing techniques of three mainstream OLAP engines—Kylin, Druid, and ClickHouse—explaining their conversion processes, storage formats, query execution paths, and summarizing their strengths and limitations for aggregation and detail query scenarios.

Big DataClickHouseDruid

0 likes · 8 min read

Comparative Analysis of Kylin, Druid, and ClickHouse Data Models and Index Structures

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.

Big DataKylinOLAP

0 likes · 24 min read

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

58 Tech

Dec 28, 2018 · Big Data

Kylin OLAP Platform Architecture, Optimizations, and 58.com Case Study

This article introduces Kylin, a HBase‑based multidimensional analysis platform, explains its architecture and various performance optimizations—including multi‑tenant support, dimension dictionary handling, and cube size estimation—while showcasing a real‑world deployment and case study at 58.com.

Big DataCube OptimizationData Warehouse

0 likes · 14 min read

Kylin OLAP Platform Architecture, Optimizations, and 58.com Case Study

Beike Product & Technology

Dec 27, 2018 · Cloud Computing

HBase Ecosystem Introduction

This article introduces HBase's ecosystem, including its components like OpenTSDB for time-series data, Kylin for cube analysis, Phoenix for SQL operations, and GeoMesa for spatial data, along with the author's experience in deploying these in a production environment.

GeoMesaHBaseHBase 2.0

0 likes · 9 min read

58 Tech

Nov 26, 2018 · Big Data

Big Data OLAP Applications and Practices: Insights from Xiaomi and 58.com

The article reviews the 2018 58 Group technology salon on big‑data OLAP, summarizing Xiaomi’s one‑stop OLAP architecture, 58.com’s challenges and solutions using Kylin, Druid, and UnionSQL, and the practical implementations and optimizations that illustrate modern OLAP practices.

Big DataData WarehouseDruid

0 likes · 12 min read

Big Data OLAP Applications and Practices: Insights from Xiaomi and 58.com

Beike Product & Technology

Jun 1, 2018 · Big Data

Design and Evolution of Lianjia's Big Data Platform: Architecture, Challenges, and Solutions

This article details Lianjia's journey from a Hadoop‑based 0.0 data platform to a sophisticated 2.0 architecture, describing the three‑layer design, OLAP engine choices, transparent compression techniques, operational challenges, and practical recommendations for building and maintaining large‑scale big data systems.

Big DataCompressionHadoop

0 likes · 15 min read

Design and Evolution of Lianjia's Big Data Platform: Architecture, Challenges, and Solutions

DataFunTalk

May 29, 2018 · Big Data

Design, Challenges, and Evolution of Lianjia's Big Data Platform Architecture (0 → 1.0 → 2.0)

This article details the evolution of Lianjia's massive‑data platform from its initial 0 version through 1.0 and 2.0, describing architectural challenges, a three‑layer redesign, data‑engine selection (ROLAP, MOLAP, Kylin), transparent compression techniques, and practical lessons for large‑scale data systems.

Big DataHadoopKylin

0 likes · 14 min read

Design, Challenges, and Evolution of Lianjia's Big Data Platform Architecture (0 → 1.0 → 2.0)

Beike Product & Technology

Apr 26, 2018 · Big Data

Chain Home's OLAP Platform and Kylin Usage

This article details Chain Home's OLAP platform architecture and Kylin usage, covering the evolution from early ROLAP to MOLAP multi-dimensional engine, Kylin's basic principles, platform structure, application scenarios, usage specifications, capability extensions, and middleware development.

Apache KylinChain HomeCube

0 likes · 11 min read

Chain Home's OLAP Platform and Kylin Usage

Qunar Tech Salon

Apr 10, 2018 · Big Data

Design and Implementation of Meituan's Traffic Compass Data Warehouse for Hotel‑Travel Business

The article presents Meituan's Traffic Compass—a data‑warehouse‑driven traffic analysis platform for the hotel‑travel business—detailing its background, challenges, architectural layers, dimensional modeling, Kylin‑based query engine, configuration mechanisms, performance metrics, and future optimization plans.

Big DataData WarehouseKylin

0 likes · 14 min read

Design and Implementation of Meituan's Traffic Compass Data Warehouse for Hotel‑Travel Business

Architect

May 6, 2016 · Big Data

Integrating Kylin, Mondrian, and Saiku to Build an OLAP Analysis Tool

This article describes how the Youzan data team combined Apache Kylin, Mondrian, and Saiku into a three‑layer OLAP system, covering background, component overviews, technical architecture, schema integration challenges, count‑distinct handling, Kylin‑specific SQL quirks, and practical solutions.

Big DataHBaseHive

0 likes · 12 min read

Integrating Kylin, Mondrian, and Saiku to Build an OLAP Analysis Tool