Notes on learning MongoDB database design

As I have done a quick refresh and slightly improved my SQL database design knowledge over past few days, I felt that I should also get some exposure to MongoDB database design. So far, I have used fairly simple MongoDB schemas in the tutorial projects I have gone through and perhaps some simple project variations that I did. I need to get more exposure. This post has related notes.

MongoDB Schema Design Best Practices, https://www.youtube.com/watch?v=QAqK-R9HUhc by MongoDB, around 10 mins, April 2021

community.mongodb.com

https://www.mongodb.com/resources/solutions/use-cases/mongodb-application-modernization-guide - Downloaded file: MongoDB_Modernization_Guide-ans0zbdf0i.zip has RDBMS to MongoDB Migration White Paper.pdf and other files including sample DB.

RDBMS to MongoDB Migration White Paper.pdf - 20 pages: Has examples of simple to medium complexity RDBMS design along with MongoDB schemas ('converted'); "The $lookup aggregation pipeline stage provides JOIN capabilities in MongoDB, supporting the equivalent of SQL subqueries and non-equijoins."; Embedding vs. Referencing; "The RDBMS optimizes data storage efficiency (as it was conceived at a time when storage was the most expensive component of the system.".."MongoDB’s document model is optimized for how the application accesses data (as performance, developer time, and speed to market are now more important than storage volumes)."; covers indexing options; "The MongoDB Compass GUI visualizes explain output, making it even easier for you to identify and resolve performance issues. The MongoDB Query Profiler helps expose performance issues by displaying slow-running queries (by default, queries that exceed 100ms) and their key performance statistics directly in the UI."

https://www.mongodb.com/docs/manual/data-modeling/ seems to be extensive. Perhaps it may be a must-read for me before doing a medium or higher complexity MongoDB database design.

Building with Patterns: A Summary, https://www.mongodb.com/blog/post/building-with-patterns-a-summary

MongoDB University Free courses: https://learn.mongodb.com/catalog?labels=%5B%22Free%2FPaid%22%5D&values=%5B%22Free%22%5D

MongoDB Data Modeling Path, https://learn.mongodb.com/learning-paths/data-modeling-for-mongodb?sessionFields=%5B%5B%22format%22%2C%22Free%22%5D%5D , 9 hours, free

MongoDB Node.js Developer Path, https://learn.mongodb.com/learning-paths/mongodb-nodejs-developer-path?sessionFields=%5B%5B%22format%22%2C%22Free%22%5D%5D , 15 hours, free

SQL to MongoDB Mapping Chart, https://www.mongodb.com/docs/manual/reference/sql-comparison/

SQL to Aggregation Mapping Chart, https://www.mongodb.com/docs/manual/reference/sql-aggregation-comparison/

Transactions, https://www.mongodb.com/docs/manual/core/transactions/

Quick intro. kind-of article: Data Modelling in MongoDB, https://www.geeksforgeeks.org/mongodb-data-modelling/ , LU May 2024.

Data Modeling with MongoDB, https://www.youtube.com/watch?v=3GHZd0zv170, by MongoDB, around 35 mins., Oct. 2020.