When should we embed one document within another in MongoDB?

// patron document
{
   _id: "joe",
   name: "Joe Bookreader"
}
// address documents
{
   patron_id: "joe", // reference to patron document
   street: "123 Fake Street",
   city: "Faketon",
   state: "MA",
   zip: "12345"
}
{
   patron_id: "joe",
   street: "1 Some Other Street",
   city: "Boston",
   state: "MA",
   zip: "12345"
}

If you need to retrieve the address data with the name information frequently, then you need to issue multiple queries to resolve the references. In this case you can embed the address document in the patron document.

{
   "_id": "joe",
   "name": "Joe Bookreader",
   "addresses": [
                {
                  "street": "123 Fake Street",
                  "city": "Faketon",
                  "state": "MA",
                  "zip": "12345"
                },
                {
                  "street": "1 Some Other Street",
                  "city": "Boston",
                  "state": "MA",
                  "zip": "12345"
                }
              ]
 }

Sources:

Model One-to-Many Relationships With Embedded Documents — MongoDB Manual. www.mongodb.com/docs/manual/tutorial/model-embedded-one-to-many-relationships-between-documents.

When should we embed one document within another in MongoDB?

Comments

MongoDB

How can you achieve primary key - foreign key relationships in MongoDB?

More from this blog

Improve Laravel development experience

Add Calendly to Nextjs 13

DbGate - The Smartest SQL+noSQL Database Client

Add responsive video to Nextjs using Bootstrap5

How to create a middleware in Laravel?

Command Palette

Comments

MongoDB

How can you achieve primary key - foreign key relationships in MongoDB?

More from this blog