Loading…
Attending this event?
Welcome to Percona Live Online 2021
Online Open Source Database Conference
REGISTER HERE!
Back To Schedule
Wednesday, May 12 • 10:30 - 11:00
Wide Rows NoSQL vs SQL Data Modeling

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Video will become available 10 minutes before session start


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.

Speakers
AI

Avishai Ish-Shalom

Developer Advocate, ScyllaDB
"In a world where anything has an API, everything is a software problem" this insight has guided Avishai Ish-Shalom throughout his diverse career working on improving the complex socio-technical systems that create and operate modern software and promoting the use of Mathematics in... Read More →


Wednesday May 12, 2021 10:30 - 11:00 EDT
Room #5
Feedback form isn't open yet.