MongoDB and “joins” [duplicate]

by

It’s no join since the relationship will only be evaluated when needed. A join (in a SQL database) on the other hand will resolve relationships and return them as if they were a single table (you “join two tables into one”).

You can read more about DBRef here:
http://docs.mongodb.org/manual/applications/database-references/

There are two possible solutions for resolving references. One is to do it manually, as you have almost described. Just save a document’s _id in another document’s other_id, then write your own function to resolve the relationship. The other solution is to use DBRefs as described on the manual page above, which will make MongoDB resolve the relationship client-side on demand. Which solution you choose does not matter so much because both methods will resolve the relationship client-side (note that a SQL database resolves joins on the server-side).

More Related Contents:

  1. MongoDb query condition on comparing 2 fields
  2. What’s Mongoose error Cast to ObjectId failed for value XXX at path “_id”?
  3. MongoDB logging all queries
  4. Return only matched sub-document elements within a nested array
  5. Converting string to date in mongodb
  6. Querying internal array size in MongoDB
  7. MongoDB wildcard in the key of a query
  8. How to create a DB for MongoDB container on start up?
  9. How to access a preexisting collection with Mongoose?
  10. How to delete N numbers of documents in mongodb
  11. How do I query for distinct values in Mongoose?
  12. MongoDB Full and Partial Text Search
  13. Difference between count() and find().count() in MongoDB
  14. How to insert an element to MongoDB internal list?
  15. Hierarchical queries with Mongo using $graphLookup
  16. Remove embedded document in a nested array of documents
  17. Find all documents within last n days
  18. Unable to create/open lock file: /data/mongod.lock errno:13 Permission denied
  19. Search on multiple collections in MongoDB
  20. Image returned from REST API always displays broken
  21. MongoDB: Server has startup warnings ”Access control is not enabled for the database”
  22. Mongo group and push: pushing all fields
  23. How to stop insertion of Duplicate documents in a mongodb collection
  24. Remove multiple documents from mongo in a single query
  25. Map-Reduce performance in MongoDb 2.2, 2.4, and 2.6
  26. Unique IDs with mongodb
  27. Cannot import mongodb
  28. MongoDB count() versus countDocuments()
  29. mongodb : Increasing max connections in mongodb
  30. Create filter aggregation in spring

Leave a Comment