Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Is Your Data Relational?

By Steve Jones,

When should you use MongoDB? I've asked that question a few times, and I haven't gotten a good answer I understand. I've read about a few of the NoSQL, document databases, and I think they do have a place in the world. There are domains of problems that they solve better than relational databases. I'm sure that streaming databases, graph databases, columnar databases, and more have places where we they shine, but I still believe that many, perhaps most, problems are best solved by relational databases.

I saw this piece about MongoDB being a poor choice by the Diaspora developers because they hadn't modeled their data well. It's a decent analysis of a real situation, and I think it's one that has probably been repeated many times by many developers that were intimidated, frustrated, or otherwise turned off by relational platforms.

There is a cost to using a relational platform, and it can require expensive developer time to map objects to relational structures. However the solution isn't to abandon the relational platform. The better solution is likely to train developers and hire a few DBAs that can help with the mapping and queries to solve problems.

Total article views: 213 | Views in the last 30 days: 1
Related Articles

The Platform Problem

Steve Jones sees a problem with the Azure platform. It's one that he thinks is limiting adoption, an...


corrupted relations in database

corrupted relations in database


Modeling relational databases

Modeling relational databases


Relational By Default

Should we consider the relational model the default and only after having a good reason look at a No...


Timewarp: What Is a Relational Database?

Relational?!? Move On, Geezer! Maybe you’re thinking that relational databases management systems...


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones