Document Enrichment and Schema Updates
Jesse HallPublished Jul 22, 2021 • Updated May 12, 2022
Rate this tutorial
So your business needs have changed and there’s additional data that needs to be stored within an existing dataset. Fear not! With MongoDB, this is no sweat.
In this article, I’ll show you how to quickly add and populate additional fields into an existing database collection.
Let’s say you have a “Netflix” type application and you want to allow users to see which movies they have watched. We’ll use the sample_mflix database from the sample datasets available in a MongoDB Atlas cluster.
Here is the existing schema for the user collection in the sample_mflix database:
There are a few ways we could go about this. Since MongoDB has a flexible data model, we can just add our new data into existing documents.
$addToSetoperator adds a value to an array avoiding duplicates. If the field referenced is not present in the document,
$addToSetwill create the array field and enter the specified value. If the value is already present in the field,
$addToSetwill do nothing.
$addToSetwill prevent us from duplicating movies when they are watched multiple times.
Now, when a user goes to their profile, they will see their watched movies.
But what if the user has not watched any movies? The user will simply not have that field in their document.
I’m using Next.js for this application. I simply need to check to see if a user has watched any movies and display the appropriate information accordingly.
Because of MongoDB’s flexible data model, we can have multiple schemas in one collection. This allows you to easily update data and fields in existing schemas.
If you would like to learn more about schema validation, take a look at the Schema Validation documentation.
I’d love to hear your feedback or questions. Let’s chat in the MongoDB Community.
User Group Meetup
PUNJAB, INDIA | IN-PERSON
Punjab MUG: MongoDB for Data Science
6/26/2023, 9:30:00 AM UTC
At the Intersection of AI/ML and HCI with Douglas Eck of Google (MongoDB Podcast)
Feb 27, 2023