NoSQL vs. SQL

Oktober 19, 2010 claus

mysql vs. nosql

mysql vs. nosql

NoSQL vs. SQL – this is really an old topic. But with upcoming database projects like cassandra, CouchDB, MongoDB and many others it gets back into the focus. We asked our self which database is the right one for our project? We evaluated SQL databases as well as nosql databases… And decided to build our application on top of MongoDB. A NoSQL database – yes! None of us has ever worked with a NoSQL database at all. Why decided we us against the classic SQL approach? Here are the pros and cons for MongoDB (this is not a comparison between SQL and NoSQL in general):

pros

- it’s super fast (it depends on the case – but for ours it is about 5 times faster than a SQL database)
- it’s extermly scalable – up to petabytes with little effort (we don’t need the space for a petabyte, but 10 terrabytes)
- it has got a very good replication mechanism (replica sets)
- it has got a easy to use Java API
- the storage format is JSON, which is very easy to handle in Java as well as in Java Script
- it’s easy in operations – you don’t have to sit an admin next to it
- is has got a very active community (I had bugfixes in less than 20 minutes!!! Thanks Elliot! :)
- they have a clear release cycle
- the company behind MongoDB (10gen) got fresh money for the next years

cons

- none of us has ever used a NoSQL database
- the project is relatively young
- you don’t have the relational integrity

As you can see, there’re a few cons against a lot of pros for our case. We simply want to store config files and process instances into the database – and of we want to get them out of it in lightening speed. For this case MongoDB fits perfect. So why should we take the hammer, if we have a screwdriver as well? ;)

www.mongodb.org

, database

Trackbacks For This Post

  1. NoSQL Daily – Wed Oct 20 › PHP App Engine - 3 years ago

    [...] NoSQL vs. SQL [...]

  2. Apache Camel: Handle Events in a clustered Environment (part 2) - 3 years ago

    [...] using MongoDB as persistence layer under catify, so it’s not a question, what db to use (here’re some thoughts about Mongo DB). By the way – it’s best suited for that case, because it’s really fast, scalable [...]

  3. MongoDB 身上的优势和劣势| 祥云工作室 - 3 years ago

    [...] 原文链接:http://www.catify.com/2010/10/19/nosql-vs-sql/ about author [...]

  4. 调查显示超过50A开始学习使用NoSQL « 编程王网站 - 3 years ago

    [...]     关于MongoDB的一些优劣势分析,实际上,MongoDB最大的优势无疑于能够快速部署,这也和应用有关,和关系型数据库相比,它的部署时间仅为它的1/5;此外,replication模式(replica sets)也是MongoDB的一大特性,完善的Java API无疑也是企业级开发人员所关注的特性。另一个最强大的理由在于,10gen已经打算给MongoDB继续投入资金。 [...]

  5. NoSQL vs. SQL | Ideensammlung - 3 years ago

    [...] NoSQL vs. SQL. 23. Januar 2011 – 14:37 | Von Daniel | Geposted in nosql | Kommentare (0) ← [...]

Leave a Reply