Relational or Non-Relational? Choosing the Best Database for the Task

on YouTube ↗19m

" summary

Compares relational versus non-relational with concrete examples: a URL redirection system built on Cosmos DB using the document model and userID as partition key, showing dynamic repartitioning and the practical 20 GB partition limit that forces key design; warns against storing logs, images or huge free text in SQL and recommends file systems or document stores instead; highlights five Cosmos consistency modes and advises ACID for strict transactional needs like finance.

AI-written summary · about

" chapters (8)

1. 0:00Introduction
2. 1:00Database models defined
3. 3:15Relational normal forms
4. 5:58NoSQL database design
5. 7:53Partitioning in Cosmos DB
6. 10:15Consistency and CAP theorem
7. 14:01Choosing the right database
8. 18:17Conclusion

" related talks

• 19mRelational or Non-Relational? Choosing the Best Database for the TaskBob Pusateri · SQLBits 2019
• 19mRelational or Non-Relational? Choosing the Best Database for the TaskBob Pusateri · SQLBits 2022
• 19mRelational or Non-Relational? Choosing the Best Database for the TaskBob Pusateri · SQLBits 2022
• 19mRelational or Non-Relational? Choosing the Best Database for the TaskBob Pusateri · SQLBits 2019
• 42mChoosing the right databaseSébastien Keller, Alexandre BUDZKO · Devoxx France 2023
• 01h 00mFrom Relational Databases to NoSQLScott Davis · Great Indian Developer Summit 2015
• 11mRationale for RelationalAndrew Gregovic · Voxxed Days Singapore 2018
• 42mSay YES! to NoSQL: A Guide on When to Ditch Relational DatabasesAdrienne Braganza Tacke · AzConf 2020