MongoDB normalization, foreign key and joining

by

MongoDB doesn’t support server side foreign key relationships, normalization is also discouraged. You should embed your child object within parent objects if possible, this will increase performance and make foreign keys totally unnecessary. That said it is not always possible, so there is a special construct called DBRef which allows to reference objects in a different collection. This may be then not so speedy because DB has to make additional queries to read objects but allows for kind of foreign key reference.

Still you will have to handle your references manually. Only while looking up your DBRef you will see if it exists, the DB will not go through all the documents to look for the references and remove them if the target of the reference doesn’t exist any more. But I think removing all the references after deleting the book would require a single query per collection, no more, so not that difficult really.

If your schema is more complex then probably you should choose a relational database and not nosql.

There is also a book about designing MongoDB databases: Document Design for MongoDB

UPDATE The book above is not available anymore, yet because of popularity of MongoDB there are quite a lot of others. I won’t link them all, since such links are likely to change, a simple search on Amazon shows multiple pages so it shouldn’t be a problem to find some.

See the MongoDB manual page for ‘Manual references’ and DBRefs for further specifics and examples

More Related Contents:

  1. Possibility of duplicate Mongo ObjectId’s being generated in two different collections?
  2. Where does mongodb stand in the CAP theorem?
  3. How do you query for “is not null” in Mongo?
  4. How to stop insertion of Duplicate documents in a mongodb collection
  5. Is mongodb running?
  6. Does MongoDB support floating point types?
  7. Get a document in MongoDB without specifying collection
  8. Update field in exact element array in MongoDB
  9. MongoDB: How to update multiple documents with a single command?
  10. How to remove a field completely from a MongoDB document?
  11. Add new field to every document in a MongoDB collection
  12. Querying internal array size in MongoDB
  13. How can I run MongoDB as a Windows service?
  14. MongoDB vs. Cassandra [closed]
  15. Find duplicate records in MongoDB
  16. Best practice to maintain a mgo session
  17. How do you rename a MongoDB database?
  18. How do I do a “NOT IN” query in Mongo?
  19. How to enforce foreign keys in NoSql databases (MongoDB)?
  20. NoSQL (MongoDB) vs Lucene (or Solr) as your database [closed]
  21. MongoDB update with condition
  22. MongoDB lookup when foreign field is an array of objects
  23. Mongodb: Failed to connect to 127.0.0.1:27017, reason: errno:10061
  24. MongoDB nested array query
  25. Filtering embedded documents in MongoDB
  26. Mongodb aggregation $group, restrict length of array
  27. MongoDB/NoSQL: Keeping Document Change History
  28. MongoDB Single Document size limit is 16MB
  29. Unique IDs with mongodb
  30. How to return only value of a field in mongodb

Leave a Comment