How to organise a many to many relationship in MongoDB

by

What I’ve seen done, and what I currently use are embedded arrays with node id’s in each document.

So document user1 has property groups: [id1,id2]

And document group1 has property users: [user1]. Document group2 also has property users: [user1].

This way you get a Group object and easily select all related users, and the same for the User.

This takes a bit more work when creating and updating the object. When you say 2 objects are related, you have to update both objects.

There’s also a concept DBReferences in MongoDB and depending on your driver, it’ll pull referenced objects automatically when retrieving a document.

http://www.mongodb.org/display/DOCS/Database+References#DatabaseReferences-DBRef

More Related Contents:

  1. Delete a key from a MongoDB document using Mongoose
  2. MEAN app vs. Mongo service local in Angular2
  3. Find objects between two dates MongoDB
  4. MongoDB: Combine data from multiple collections into one..how?
  5. MongoDB: Is it possible to make a case-insensitive query?
  6. How to update the _id of one MongoDB Document?
  7. MongoDB: count the number of items in an array
  8. How to remove a field completely from a MongoDB document?
  9. Multiple join conditions using the $lookup operator
  10. Aggregate $lookup Total size of documents in matching pipeline exceeds maximum document size
  11. Understanding MongoDB BSON Document size limit
  12. MongoDB – admin user not authorized
  13. How can I run MongoDB as a Windows service?
  14. MongoDB query with an ‘or’ condition
  15. Mongo complex sorting?
  16. MongoDB: update every document on one field
  17. How to sum every fields in a sub document of MongoDB?
  18. Where does mongodb stand in the CAP theorem?
  19. MongoDb shuts down with Code 100 [closed]
  20. Mongodb Query To select records having a given key
  21. MongoDB: how to parse date in 3.6 mongoDb version?
  22. MongoDB – is DBREF necessary?
  23. saving picture to mongodb
  24. MongoDB – Querying between a time range of hours
  25. Can mongodb be used as an embedded database?
  26. Using $slice operator to get last element of array
  27. Simple HTTP/TCP health check for MongoDB
  28. Mongoose.js instance.save() callback not firing
  29. Mongodb aggregation pipeline how to limit a group push
  30. MongoDB : aggregation framework : $match between fields

Leave a Comment