Relational or Non-Relational? Choosing the Best Database for the Task
summary
Compares relational rules (normal forms, ACID) against NoSQL tradeoffs with concrete guidance: avoid storing logs, images or huge free text in RDBMS; avoid NoSQL when strict ACID transactions or financial integrity are required. Demonstrates Azure Cosmos DB: 20 GB per physical partition limit, choose partition key to avoid fan‑out, and its five consistency levels. Shows document JSON example for URL redirects, explains when to denormalize for scale and when to keep normalized schemas for correctness and easy joins.
AI-written summary · about
chapters (10)
- 0:00Introduction
- 0:28Relational vs non-relational
- 1:31Data models and constraints
- 2:34Normal forms
- 6:27NoSQL document design
- 8:52NoSQL partitioning
- 12:43ACID vs BASE
- 14:08CAP and PACELC theorems
- 16:10Avoid relational databases
- 17:58Choose NoSQL databases
related talks
19mRelational or Non-Relational? Choosing the Best Database for the Task
19mRelational or Non-Relational? Choosing the Best Database for the Task- 19mRelational or Non-Relational? Choosing the Best Database for the Task
- 19mRelational or Non-Relational? Choosing the Best Database for the Task
01h 00mFrom Relational Databases to NoSQL
42mSay YES! to NoSQL: A Guide on When to Ditch Relational Databases
45mSay YES! to NoSQL: A Guide on When to Ditch Relational Databases
45mSay YES! to NoSQL: A Guide on When to Ditch Relational Databases