• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Where to use MongoDB : is it good for structured data

 
Kripal Gupta
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am interested in clear direction on places where it can be applied or has been applied. is it good for structured data or rdms is still the way to go.
Thanks
 
Rick Copeland
author
Greenhorn
Posts: 17
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well, that's a pretty open-ended question, which is probably why the answers you've gotten so far have been unsatisfactory.

In general terms, yes, MongoDB is great for structured data (also for semi-structured data). Some pros and cons to consider (with the caveat that I'm painting with a broad brush, and there are exceptions to every rule):

MongoDB over SQL
- MongoDB has a more flexible model (hierarchical documents versus rows/columns only)
- MongoDB is easier to scale horizontally (automatic sharding & built-in async replication, etc.)
- MongoDB schema migrations tend to require less downtime than SQL migrations
- MongoDB really shines when you have a single application using MongoDB as a persistence engine since you can model your schema after the queries you need
- In many cases, MongoDB requires fewer random disk seeks than SQL due to its document structure

SQL over MongoDB
- SQL typically takes much less space on disk due to its static schema
- SQL databases (particularly normalized databases) offer a great persistence layer for sharing between multiple applications
- It's easier to find people who know SQL than MongoDB
- SQL databases scale better vertically

There are probably a good number of other trade-offs, but those are the ones can think of right now.

Hope that helps!
 
Kripal Gupta
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Rick for the reply.
 
Pradeep bhatt
Ranch Hand
Posts: 8933
Firefox Browser Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is mongo db modern version of IBM's IMS database ? IMS is hierarchical database.

http://en.wikipedia.org/wiki/IBM_Information_Management_System
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic