Data Modeling: Master This Critical Step to Adopting a Distributed Database

on YouTube ↗27m

" summary

Explains concrete rules for YugabyteDB data placement and tradeoffs: pick primary key partition columns to co-locate rows (example: store_id partitioning vs product_id), use secondary and covering index to make reads finish in one RPC (demo: index including in_store_count returns stores for a product in a single network round trip), avoid global sequences and prefer uuid over sequences for uniqueness, accept extra update cost for cross-node indexes, and denormalize bounded children or enums to eliminate joins; YCQL offers static objects, YSQL is regular SQL.

AI-written summary · about

" chapters (8)

1. 0:00Start
2. 0:35Data Model and Your Application Use Patterns
3. 3:51Rules of Thumb
4. 7:06Primary Key Selection
5. 7:43Sequence Numbers
6. 13:07Gigabyte Indexes
7. 15:58Denormalization
8. 18:29Data Duplication

" related talks

• 29mData Modeling for Distributed SQLARISA IZUNO · Distributed SQL Summit Asia 2024
• 33mMigrating from Oracle toAlan Caldera · Distributed SQL Summit Asia 2021
• 27mIntroduction to YugabyteDB – Design and ArchitectureKarthik Ranganathan · Distributed SQL Summit Asia 2021
• 27mIntroduction to YugabyteDB: Design and ArchitectureKarthik Ranganathan · Distributed SQL Summit 2020
• 29mScalable Product MappingsDivya Goel, Aashish Kapoor · Distributed SQL Summit Asia 2021
• 47mAnatomy of a Distributed SQL Database - YugabyteDBFranck Pachot · Devoxx France 2022
• 30mBuilding Cloud Native Applications on Distributed SQL PlatformSHIGERU URUSHIBARA · Distributed SQL Summit Asia 2023
• 26mIntroducing YugabyteDB for PostgreSQL UsersBo Peng · Distributed SQL Summit Asia 2023