Help! I Need To UnSQLize My Application
summary
Shows how to convert relational schemas into MongoDB documents, including concrete patterns: use embedding for co-accessed data, avoid unbounded arrays (16 MB limit), and use the extended reference pattern to include ID plus denormalized name. Demonstrates joins with aggregation pipeline stages like $lookup/$match/$group, and notes transactional or two-step updates to keep denormalized copies consistent. Describes a relational migrator (ODBC→Mongo) that syncs data and cites a real migration of 20 terabytes from Oracle to MongoDB.
AI-written summary · about
chapters (12)
- 0:00Introduction
- 1:15Agenda
- 1:50Whats a Nosql
- 2:23Whats a Document Database
- 4:07Traditional Data Model
- 4:53Document Database
- 13:07Aggregation Pipeline
- 14:10Joining Data
- 14:53Extended Reference Pattern
- 20:37Migration
- 22:52Recap
- 24:17Additional Resources
related talks
43mHelp! I Need To UnSQLize My Application
44mThe Developer's Guide to Data Modelling with Document Databases
29mSwitching to MongoDB: The challenges of translating database schemas
26mNoSQL Data Modeling for Front-end Developers
45mNoSQL Data Modeling for Front-end Developers
36mMongoDB Schema Design - best practices
41mFrom Tables to Documents - Changing Your Database Mindset
25mHybrid Applications with MongoDB and RDBMS
