From Tables to Documents - Changing Your Database Mindset

Explore the shift from SQL to document-based databases in this 46-minute conference talk from NDC Oslo 2020. Learn key terminology differences, understand the advantages of document-based systems, and discover three essential mindset changes for successful implementation. Dive into practical examples, including user dictionaries and hobby tables, to grasp concepts like document diversity, data normalization, and embedding. Gain insights on scaling, query optimization, and adapting to changing requirements. Examine the trade-offs between storage costs and development efficiency. Conclude with a summary of document database benefits and additional resources, including an introduction to MongoDB Atlas.

Intro
Overview
Example
Term Mapping
Changing Your Database Mindset
Scaling
Faster Queries
Requirements Change
Program Faster
MongoDB
User Dictionaries
Updating User Dictionaries
Updating Users Table
Updating Hobbies Table
Change Your Mindset
Embrace Document Diversity
Normalize Data
Price of Storage
Cost of Software Development
Embedding
Transactions
Summary
Advantages of documents
Conclusion
Additional Resources
MongoDB Atlas