Handling Large Volumes of Immutable Structured Data With ClickHouse

Explore the power of ClickHouse for handling large volumes of immutable structured data in this ACCU 2021 conference talk. Learn about the open-source column-oriented database management system with SQL querying capabilities, written in C++. Discover how ClickHouse can be used to analyze massive datasets, such as 12 billion daily DNS transaction records, on a small cluster of servers. Gain insights into table definitions, table engines, materialized views, and data distribution across clusters. Follow along as the speaker demonstrates ClickHouse's capabilities using a large dataset on a laptop, showcasing its efficiency in online analytical processing. Understand the benefits of ClickHouse for developers working with high-volume, structured data and looking to perform SQL queries for analysis.

Introduction
ClickHouse Background
What is ClickHouse
Online Analytical Processing
Open Source
C
What I Like
Table Definition
Table Engine
Summing Merge Tree
Creating a materialized view
Distributing data across a cluster
rand
command line
aggregated data
query count
query on raw data