Welcome to Percona Live Online 2021
Online Open Source Database Conference
Back To Schedule
Wednesday, May 12 • 10:30 - 11:00
Wide Rows NoSQL vs SQL Data Modeling

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.

Some NoSQL databases popularized the notion of “loose schema”, often misunderstood as “schemaless” - but there is always a data model, in the DB, the application or the mind of the developer. However, NoSQL schemas are designed with very different goals in mind than SQL schemas: where SQL normalizes, NoSQL denormalizes; Where SQL joins ad-hoc, NoSQL pre-joins; where SQL tries to push performance to the runtime, NoSQL bakes performance into the schema. Adding to the confusion, various NoSQL databases have different ideas on what schemas should enforce. This talk aims to introduce the core concepts of NoSQL schema design, using Scylla as an example explaining tradeoffs and rationale.

avatar for Tzach Livyatan

Tzach Livyatan

VP Product, Scylla
Tzach Livyatan has a B.A. and MSc in Computer Science (Technion, Summa Cum Laude), and has had a 15 year career in development, system engineering and product management. In the past he worked in the Telecom domain, focusing on carrier-grade systems, signalling, policy and charging... Read More →

Wednesday May 12, 2021 10:30 - 11:00 EDT
Room #5