Loading…
Attending this event?
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!

Log in to leave feedback.


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.

Speakers
avatar for Robert Hodges

Robert Hodges

CEO, Altinity
Robert Hodges has worked with database systems since 1983, including 20 different DBMS types ranging from pre-relational systems like M204 to MySQL to analytic databases like ClickHouse. He is currently CEO of Altinity.

Hosts
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
Online
  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