Can one make a relational database using MongoDB?

mongodb relational-database rdbms
İlker Dağlı picture İlker Dağlı · Nov 15, 2011 · Viewed 34.5k times · Source

I am going to make a student management system using MongoDB. I will have one table for students and another for attendance records. Can I have a key in the attendance table to reach the students table, as pictured below? How?

diagram of a relational database

Answer

Mike Christensen picture Mike Christensen · Nov 15, 2011

The idea behind MongoDB is to eliminate (or at least minimize) relational data. Have you considered just embedding the attendance data directly into each student record? This is actually the preferred design pattern for MongoDB and can result in much better performance and scalability.

If you truly need highly relational and normalized data, you might want to reconsider using MongoDB.

Related questions

When to use MongoDB

I'm writing an application that doesn't necessarily need scaling abilities as it won't be collecting large amounts data at the beginning. (However, if I'm lucky, I could down the road potentially.) I will be running my web server and database …

Read More
Use cases for NoSQL

NoSQL has been getting a lot of attention in our industry recently. I'm really interested in what peoples thoughts are on the best use-cases for its use over relational database storage. What should trigger a developer into thinking that particular …

Read More
How to organise a many to many relationship in MongoDB

I have two tables/collections; Users and Groups. A user can be a member of any number of groups and a user can also be an owner of any number of groups. In a relational database I'd probably have a …

Read More