Tagged articles
Columnar Database
44 articles · Page 1 of 1
This article explains how ClickHouse’s columnar storage, compression, and bitmap functions enable fast, scalable processing of billions of user tags and groups in a CDP, covering data storage design, bitmap generation, and distributed query optimization.
BitmapCDPClickHouse
0 likes · 11 min read

This article introduces ClickHouse, an open‑source column‑oriented distributed database, explaining its columnar storage model, key performance and scalability features, rich analytical capabilities, and the scenarios where it excels or falls short in big‑data processing.
ClickHouseColumnar Databasebig data
0 likes · 6 min read

ClickHouse, an open‑source column‑oriented distributed database from Yandex, offers high performance, efficient compression, vectorized execution, and scalable architecture, making it ideal for large‑scale analytics, log processing, monitoring, and data warehousing, while noting its limitations in transactions and strong consistency.
ClickHouseColumnar Databasedata analytics
0 likes · 5 min read

This article explains ClickHouse’s columnar, MPP‑based design, block compression, LSM pre‑sorting, sparse and skip‑list indexing, and vectorized execution, while also discussing its high‑frequency write challenges, concurrency limits, and production‑grade issues such as Zookeeper load and resource management.
ClickHouseColumnar DatabaseLSM
0 likes · 11 min read

This article introduces a comprehensive ClickHouse training program that covers fundamental concepts, architecture, installation, distributed cluster design, data import, performance tuning, and includes a detailed list of 33 video modules and additional recommended reading resources for large‑scale data analytics.
ClickHouseColumnar DatabaseDatabase Training
0 likes · 4 min read

This article introduces ClickHouse, an open‑source columnar OLAP database, explains its architecture—including columnar storage, block processing, LSM, indexing and vectorized execution—highlights its performance advantages over other engines, and discusses its limitations such as write‑amplification, concurrency constraints, and ZooKeeper dependency.
ClickHouseColumnar DatabaseOLAP
0 likes · 12 min read

This article introduces ClickHouse, an open‑source columnar OLAP database, outlines its architecture, advantages, self‑hosted and cloud deployment models, highlights recent product features such as async inserts, JSON support, Parquet acceleration, query caching, and summarizes a Q&A covering semi‑structured data, MPP, virtual columns, and future roadmap.
ClickHouseColumnar DatabaseOLAP
0 likes · 12 min read

This article examines the massive data storage and real‑time analysis needs of an activity platform, evaluates MySQL, sharded MySQL, Elasticsearch and HBase, and explains why ClickHouse—with its columnar storage, MergeTree engine, vectorized execution, and distributed architecture—offers the best balance of write performance, query speed, and scalability for billions of records.
ClickHouseColumnar DatabaseData Compression
0 likes · 31 min read

This article examines the massive‑scale data requirements of an activity‑tracking platform, compares MySQL, Elasticsearch and HBase, and explains why ClickHouse—with its columnar storage, MergeTree engine, vectorized execution, and distributed architecture—offers the best combination of storage capacity, write performance, real‑time analysis, and query speed for billions of records.
ClickHouseColumnar DatabaseMergeTree
0 likes · 31 min read

This article explains what ClickHouse is, why a large MySQL table caused multi‑minute queries, and how migrating the data to ClickHouse using Docker, CREATE TABLE AS SELECT, and a lightweight sync tool reduced query time to under one second, while highlighting pitfalls and performance reasons.
ClickHouseColumnar DatabaseMySQL
0 likes · 6 min read

This article presents the background and challenges of large‑scale keyword hit statistics, explains why traditional MySQL solutions struggle, and details how ClickHouse’s columnar storage, vectorized execution, and distributed architecture provide fast, scalable analytics, including cluster setup, table schema, queries, and migration lessons.
ClickHouseColumnar DatabaseKeyword Statistics
0 likes · 20 min read

This article examines ClickHouse’s lack of native upsert and delete operations, explains how ByteHouse’s UniqueMergeTree engine introduces a Mark‑Delete + Insert approach to provide real‑time upsert/delete capabilities, and presents benchmark results showing dramatically faster queries with only modest write overhead.
ByteHouseClickHouseColumnar Database
0 likes · 10 min read

This article explains ClickHouse’s MPP columnar design, complete DBMS capabilities, columnar storage, vectorized execution, multi‑master architecture, real‑time queries, sharding, and performance‑focused hardware and algorithm choices that together deliver its superior speed.
ClickHouseColumnar DatabaseDatabase Architecture
0 likes · 17 min read

The article explains how ClickHouse uses block‑based batch processing combined with LSM‑style pre‑sorting and columnar compression to accelerate range queries on massive datasets, while also discussing the trade‑offs such as write latency and limitations for transactional workloads.
BlockClickHouseColumnar Database
0 likes · 14 min read

This article introduces ClickHouse, a high‑performance open‑source columnar database, explains its architecture versus row‑based systems, details migration from MySQL, showcases installation, performance benchmarks, data‑sync strategies, common pitfalls, and summarizes its benefits for large‑scale analytical workloads.
ClickHouseColumnar DatabaseSQL
0 likes · 7 min read

This article introduces ClickHouse as a column‑oriented OLAP database, compares it with traditional row‑based databases, and details a real‑world migration from MySQL that reduced query time from minutes to under one second, along with performance testing, sync strategies, and common pitfalls.
ClickHouseColumnar DatabaseSQL
0 likes · 7 min read

This article compares Elasticsearch and ClickHouse for log analytics, detailing their architectures, node roles, query capabilities, and performance through Docker‑Compose stacks and synthetic syslog data, concluding that ClickHouse generally outperforms Elasticsearch in speed and aggregation efficiency.
ClickHouseColumnar DatabaseElasticsearch
0 likes · 11 min read

This article provides a comprehensive overview of ClickHouse, covering its columnar OLAP architecture, key features such as data compression, vectorized processing, distributed query handling, and SQL support, followed by detailed step‑by‑step instructions for deploying a multi‑node ClickHouse cluster with MergeTree and ReplicatedMergeTree engines, configuration files, and Java MyBatis integration.
ClickHouseCluster DeploymentColumnar Database
0 likes · 10 min read

This article provides an in‑depth technical overview of HBase, covering its Bigtable origins, distributed column‑store design, core components such as ZooKeeper, HMaster and RegionServer, data flow, storage formats, row‑key design, bulk loading, SQL integration, indexing, coprocessors, and performance tuning for big‑data environments.
Columnar DatabaseHBaseHDFS
0 likes · 30 min read

ClickHouse, born from Yandex’s Metrica and now a top‑50 open‑source analytics engine, achieves exceptional speed through a vectorized compute engine, column‑store architecture, and an active community, powering real‑time workloads at companies like Tencent Music, Sina, Bilibili, and Suning while introducing features such as column merging, projections, and storage‑compute separation for future scalability.
ClickHouseColumnar DatabaseData Engineering
0 likes · 17 min read

This article introduces ClickHouse, explains its column‑oriented architecture versus row‑oriented databases, details a MySQL‑to‑ClickHouse migration, shows a performance benchmark that reduces query time from minutes to seconds, and shares practical deployment tips and common pitfalls.
ClickHouseColumnar DatabaseMySQL
0 likes · 8 min read

This article provides a comprehensive overview of ClickHouse, covering its background, core features, columnar storage, vectorized execution engine, table engines, distributed architecture, performance benchmarks, real‑world deployment at TAL Education, monitoring practices, encountered challenges, and future planning.
ClickHouseColumnar DatabaseOLAP
0 likes · 18 min read

This article provides a comprehensive introduction to HBase, covering its origins, column‑oriented NoSQL design, storage on HDFS, logical and physical structures, read/write workflows, performance optimizations, and common interview questions for big‑data engineers.
Columnar DatabaseHBaseNoSQL
0 likes · 24 min read

ClickHouse is an open‑source column‑oriented OLAP database developed by Yandex that offers real‑time queries, high performance compared to many traditional databases, a rich set of features, and a modular architecture including columns, data types, blocks, parsers, functions, and various table engines.
ClickHouseColumnar DatabaseOLAP
0 likes · 9 min read

This article provides a comprehensive introduction to ClickHouse, an open‑source column‑oriented OLAP database, covering its high‑performance benchmarks, core architectural components, query processing model, deployment patterns, Java client usage, and real‑world implementations at large enterprises.
ClickHouseColumnar DatabaseOLAP
0 likes · 28 min read


21CTONov 9, 2020 · Databases
This article introduces ClickHouse, compares column‑store and row‑store databases, shows how migrating a 50‑million‑row MySQL table to ClickHouse reduced query time from minutes to under one second, and shares practical installation, migration, performance testing, and synchronization tips.
ClickHouseColumnar DatabaseMySQL
0 likes · 6 min read


ITPUBNov 5, 2020 · Databases
This article introduces ClickHouse, compares column‑ and row‑oriented storage, explains a real‑world migration from MySQL to ClickHouse that reduced a 3‑minute query to under one second, details installation, migration methods, performance results, synchronization options, and common pitfalls.
ClickHouseColumnar DatabaseMySQL
0 likes · 7 min read


ITPUBOct 12, 2020 · Databases
This article explains how ClickHouse’s column‑oriented storage, vectorized execution engine, rich DBMS capabilities, flexible table engines, and carefully designed distributed architecture enable it to handle massive workloads with sub‑second query latency, making it a standout OLAP solution.
ClickHouseColumnar DatabaseData Compression
0 likes · 29 min read

This article introduces ClickHouse as an OLAP columnar database, explains the differences between row‑ and column‑oriented storage, details a real‑world migration from MySQL using a CREATE TABLE AS SELECT approach, presents performance comparisons, discusses synchronization methods, and shares common pitfalls and solutions.
ClickHouseColumnar DatabaseDatabase Migration
0 likes · 6 min read

This article explains why ClickHouse, the high‑performance columnar OLAP database, can return results on billions of rows within seconds, detailing its columnar storage, MergeTree engine, and how JD Cloud deploys and optimizes it on Kubernetes for scalability and reliability.
ClickHouseColumnar DatabaseData Storage
0 likes · 14 min read

This article introduces ClickHouse, a column‑store OLAP database, explains its advantages over row‑store systems, guides installation on macOS, details migration strategies from MySQL, presents performance benchmarks showing 200‑fold speedups, and discusses synchronization methods, pitfalls, and practical tips.
ClickHouseColumnar DatabaseDatabase Synchronization
0 likes · 6 min read

This article introduces ClickHouse as a high‑performance columnar OLAP database, compares it with row‑based systems, details migration methods from MySQL, presents performance benchmarks showing dramatic speed gains, discusses data synchronization strategies, explains why ClickHouse is fast, and shares common pitfalls and solutions.
ClickHouseColumnar DatabaseMySQL
0 likes · 5 min read

This article introduces ClickHouse as an OLAP columnar database, compares its storage model with row‑based databases, details migration from MySQL, presents performance benchmarks showing query speeds under one second for 50 million rows, and shares practical deployment tips and pitfalls.
ClickHouseColumnar DatabaseMySQL Migration
0 likes · 7 min read

This article introduces ClickHouse, an open‑source column‑oriented OLAP database, detailing its key features, appropriate use cases, installation steps, performance benchmark queries, and how it compares with other columnar storage solutions while highlighting its adoption by major internet companies.
ClickHouseColumnar DatabaseOLAP
0 likes · 10 min read

ClickHouse, the high‑performance columnar OLAP DBMS behind Yandex.Metrica, combines complete DBMS capabilities, column‑oriented storage with compression, vectorized execution, flexible table engines, multi‑master clustering, and extensive SQL support, offering fast online queries and scalable distributed processing for massive data workloads.
ClickHouseColumnar DatabaseOLAP
0 likes · 28 min read

This article provides a comprehensive technical overview of ClickHouse, covering its complete DBMS capabilities, column‑oriented storage and compression, vectorized execution engine, relational SQL support, diverse table engines, multi‑master clustering, sharding, and the design philosophies that make it exceptionally fast for large‑scale analytical workloads.
ClickHouseColumnar DatabaseData Compression
0 likes · 29 min read

This article provides an in‑depth analysis of Apache Druid V1's column‑oriented storage format, covering dimension structures, dictionaries, variable‑length integer encoding, inverted indexes, array handling, and how these components are used during query execution.
Apache DruidColumnar DatabaseData Storage
0 likes · 9 min read

ClickHouse is a column‑oriented, open‑source OLAP database developed by Yandex that offers high‑compression columnar storage, vectorized execution, and massive read/write throughput, making it ideal for large‑scale analytics while having specific usage scenarios and notable limitations such as lack of true transactions and secondary indexes.
ClickHouseColumnar DatabaseOLAP
0 likes · 7 min read

This article provides a comprehensive overview of MonetDB, covering its origins at CWI, column‑oriented storage with BATs, memory‑mapped and vectorized execution, three‑layer system architecture, cache‑aware optimizations such as vector operations and radix‑partitioned hash joins, as well as its limitations and reference sources.
Columnar DatabaseMonetDBcache optimization
0 likes · 10 min read

This article introduces ClickHouse as a high‑performance, column‑oriented database designed for real‑time big‑data analytics, outlines its key features, performance characteristics, supported interfaces, differences from Hadoop, and explains its main storage engines—MergeTree and Distributed—while also noting its current limitations.
ClickHouseColumnar DatabaseHadoop
0 likes · 11 min read

Alibaba's HiStore columnar database, deployed for e‑commerce historical data, processes over 6 trillion records and 5 PB of data daily, offering high compression, low cost, linear scalability, MySQL compatibility, and superior OLAP performance for massive multi‑dimensional queries.
AlibabaColumnar DatabaseData Compression
0 likes · 7 min read

Alibaba’s HiStore column‑store database handles over 6 trillion records and 5 PB of data daily, delivering ultra‑high compression, low hardware cost, and millisecond‑level multidimensional queries for massive e‑commerce and cloud workloads.
AlibabaColumnar DatabaseData Compression
0 likes · 7 min read

HiStore is a columnar database developed by Alibaba's middleware team, designed for massive OLAP workloads with high compression ratios, low storage and maintenance costs, supporting ad‑hoc multi‑dimensional queries, knowledge‑grid optimization, efficient data loading, and offering features such as approximate queries and high‑availability clustering.
Columnar DatabaseData CompressionOLAP
0 likes · 19 min read


21CTOJun 18, 2016 · Databases
HiStore, Alibaba’s columnar database built on a patented Knowledge‑Grid, delivers ultra‑high compression (over 10:1, up to 40:1), low‑cost storage, rapid query performance, linear scalability, and seamless MySQL compatibility, making it ideal for massive OLAP workloads and real‑time analytics across diverse industries.
Columnar DatabaseData CompressionOLAP
0 likes · 8 min read
