Alexander Zaitsev (Altinity), Robert Hodges (Altinity LTD) deliver the talk, "ClickHouse Data Warehouse 101: The First Billion Rows", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.

Columnar stores like ClickHouse enable users to pull insights from big data in seconds, but only if you set things up correctly. This talk will walk through how to implement a data warehouse that contains 1.3 billion rows using the famous NY Yellow Cab ride data. We'll start with basic data implementation including clustering and table definitions, then show how to load efficiently. Next, we'll discuss important features like dictionaries and materialized views, and how they improve query efficiency. We'll end by demonstrating typical queries to illustrate the kind of inferences you can draw rapidly from a well-designed data warehouse. It should be enough to get you started--the next billion rows is up to you!


Related Videos: Percona Live Sessions, Business / Case Study, Open Source Database

Open Source Adoption for Financial and Banking Institutions
Kubernetes: The Path to Open Source DBaaS
How to Maximize the Benefits of Using Open Source MongoDB with Percona Distribution for MongoDB
Engineering Data Reliably Using SLO Theory - Emily Gorcenski - Percona Live ONLINE 2020
Revision Control for Structured Data - Gavin Mendel Gleason - Percona Live ONLINE 2020
What If We Could Use Machine Learning Models as Tables? - Jorge Torres - Percona Live ONLINE 2020
Mastering Open Source Data Governance - Elisha Chitsenga - Percona Live ONLINE 2020