~/talk

Data warehouse or conventional database: Which is right for you?

on YouTube 40m
Talkat Data Con LA 2020 · 2020-10-23..10-25· [databases, data-engineering]

speaker

name:Robert Hodges
x:dbcicero

resources

video:https://youtu.be/N7BKfMLF7jY
slides:none on file

summary

Compares MySQL row store vs ClickHouse column store with concrete tradeoffs: MySQL uses a clustered B‑tree index, runs on a single server and easily supports millions of queries per second, but struggles with very wide or very long tables. ClickHouse stores each column as compressed arrays (example airline dataset: 173 million rows, 109 columns), uses MPP/sharding for near‑linear scaling, achieves compression often ~20× to 300× and materialized views that give 100x–10,000x speedup for aggregates. Use MySQL for high concurrency transactions, ClickHouse for analytics.

AI-written summary · about

chapters (20)

  1. 0:00Intro
  2. 1:39Presenter Bio
  3. 2:26What kind of database do you need?
  4. 4:30Key Features of MySQL
  5. 6:25Airline flight management in MySQL
  6. 8:26How row data is organized
  7. 10:46Strengths and weaknesses of MySQL OLTP Online Transaction Processing
  8. 15:55Airline ontime table definition CREATE TABLE airline.ontime
  9. 21:26We make data even smaller by compres
  10. 23:08Data reductions from real data Effects of Codecs and Compression
  11. 24:43We can speed up queries using more CE
  12. 25:55Materialized views reduce data still mor
  13. 26:40Materialized views restructure/reduced
  14. 27:22Still not fast enough? Add more servers Replicas
  15. 28:04ClickHouse distributes queries automat
  16. 29:23Strengths and weaknesses of ClickHou OLTP ("Online Transaction Processing") (-) Lots of lookups (+) Very long tables
  17. 30:45Where MySQL shines - transaction proc
  18. 31:49Where ClickHouse shines - analytic app
  19. 32:37A parting question...
  20. 33:54Conclusions Row stores like MySQL are great for transaction processing o Lots of updates and small queries

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.