Lextree Simply the best software for managing legal entities and documents.
The Berkman Letter Practical analysis and commentary for business, law, and more.

When is a SQL database better than a NoSQL or document database?

1
star
2
answers
1262
views

We are considering a substantial enterprise application development effort. The application will be multi-tenant, global and highly configurable. Most of our internal team supports SQL. But it would be help to have another perspective, especially if its objective.

Answers
2
stars

There are many factors to consider when thinking about whether you choose a relational database (RDBMS) or NoSQL database.

There are the obvious:

  • Cost tradeoffs (NoSQL DBs are usually open source and free, e.g. MongoDB, Cassandra, etc) whereas RDBMSes are often pricey (Microsoft SQL Server, Oracle).
  • Performance: NoSQL DBs are often much faster than relational DBs but they are also build targeting a single use-case. Using them outside this use-case can be extra challenging but not impossible.

There are also less obvious tradeoffs such as does the team have experience (or desire to gain experience) with a given NoSQL DB?

Here is a great overview video from Martin Fowler:

https://www.youtube.com/watch?v=qI_g07C_Q5I

And another intro talk (first half) I recently did at a conference in London:

https://www.youtube.com/watch?v=_r7ozqiTN2k

0
stars

I am not an expert from the programming side, but there are difference from a procurement perspective. This video is a nice overview focused on hardware implications of SQL and NoSQL databases.

This is a report from some very extensive performance testing of the two types of databases.

If you want to learn more about NoSQL and MongoDB in particular, check out Michael Kennedy's blog. He is a highly rated expert on the subject. I've included a link below.