Back To Schedule
Tuesday, October 20 • 21:00 - 21:30
SQL Row Store vs Data Warehouse: Which Is Right for Your Application?

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.

MySQL and PostgreSQL are the goto SQL databases for a huge number of services. But what if your service generates billions or even trillions of records? This talk helps listeners decide when applications work better with a SQL data warehouse.

Using MySQL and ClickHouse as examples, we'll work through use cases like transaction processing and computation of aggregates to see where each shines. Along the way we'll explore key technical differences:
  • row vs. column storage
  • query parallelization
  • sharding and replication
  • concurrency support
  • transaction models
Finally, we'll discuss how to handle use cases that require the capabilities of both. Listeners will leave with clear criteria and a deeper understanding of database internals that enable them to make the right choice(s) for their own use cases.

avatar for Robert  Hodges

Robert Hodges

CEO, Altinity
Robert Hodges is a data geek who has worked on or with 20 different DBMS types since 1983. He currently works on ClickHouse, a popular open source data warehouse. Besides databases, his technical interests including distributed systems, Kubernetes, and security. In his day job he... Read More →

avatar for Travis Futas

Travis Futas

Senior Compliance Manager, Percona
Travis is an in-house attorney that manages Percona's privacy and compliance practices. His background is in technology and commercial law, with an emphasis on information security, privacy, and healthcare compliance. Outside of Percona, Travis sits on the board of a private organization... Read More →

Tuesday October 20, 2020 21:00 - 21:30 EDT
  MySQL, Application Development
  • Difficulty Entry Level
  • Why this level of difficulty? It's important to have introductory materials that help application developers make sane choices about technology. Hope this is successful.
  • Speaker Location USA