You are designing a user database. Each user can have up to 3 addresses (e.g., home, work, mailing), and your application very frequently needs to retrieve a user profile along with all their addresses. What is the most efficient way to model this in MongoDB?

Question

Answer

Store addresses in a separate  addresses  collection and reference the user ID in each address document. Query the two collections when needed.

Answer

It makes no difference – either embedding or referencing will perform the same for this use case.

Answer

Embed the address documents inside each user document (e.g., an  addresses  array of subdocuments within the user).

Answer

Store an array of user IDs inside each address document.

Crowdly

You are designing a user database. Each user can have up to 3 addresses (e.g., h...

Want instant access to all verified answers on learning.monash.edu?