Common questions on NoSQL or BigData Implementations.

[ ] SQL vs noSQL?

[ ] MongoDB over Cassandra?

[ ] Reporting from mongo or mysql?

[ ] Why not elastic search as a primary Database?

[ ] SQL vs noSQL?
Ans: There are huge explanations on this topic all over the internet.
http://jennyxiaozhang.com/nosql-hbase-vs-cassandra-vs-mongodb/
http://lmgtfy.com/?q=SQL+vs+noSQL :)

My two cents on this topic is, if you think your table structure needs to be altered frequently, don't go for SQL-RDBMS.

[ ] MongoDB over Cassandra?
Ans: Take a look on these links:
https://blog.serverdensity.com/mongodb-vs-cassandra/
http://stackoverflow.com/questions/18635657/advantages-of-cassandra-db-o...

[ ] Reporting from mongo or mysql?
Ans : I did not find any free solution of reporting on MongoDB. So I first planned to run ETL and send data to MySQL and then generate report. Now we have found a good solution that is using kibana over elastic search. To connect with mongodb and elastic search we are using mongo_river plugin on elastic search.

[ ] Why not elastic search as a primary Database?
Ans : Here are the main "disadvantages" I see:

Security - ElasticSearch does not provide any authentication or access control functionality.
Transactions - There is no support for transactions or processing on data manipulation.
Durability - ES is distributed and fairly stable but backups and durability are not as high priority as in other data stores.
Maturity of tools - ES is still relatively new and has not had time to develop mature client libraries and 3rd party tools which can make development much harder.
Large Computations - Commands for searching data are not suited to "large" scans of data and advanced computation on the db side.

Share this post

Leave a comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.