NoSQL DBs - Feature Comparison

NoSQL DBs - Feature Comparison

"Hi there, come on in and welcome again to the ocean of data. Which DB solution are you planning to ride the waves of data?" The answer can be easy if only RDBMS (ACID) based solutions are point of consideration. This becomes little difficult to choose among BASE (No-SQL) providers.

Here is a small matrix of feature comparison on BASE(No-SQL) databases and probably it can help choosing one. Feel free to comment back if you guys think something has changed since I last updated it.

CSV: https://drive.google.com/file/d/0B5ukOz8LhAaNSEFGQ3BYOTEyZzg/view?usp=sharing

Excel: https://drive.google.com/file/d/0B5ukOz8LhAaNMHh1eUhiTDhaUFk/view?usp=sharing

Agile Delivery - Awards & Rewards

"We believe in agile fashion of delivery to add more value to the delivered/working product."

This sounds like having great understanding the scrum triangles like "Stakeholders => Scrum Team => Working product" OR "Product Owner => Scrum Master => Team" and execution excellence by eliminating the waste.

But is this all? May be not? What else is left out?

Come-on guys it is "Awards". If the company is really agile than all the awards should be team oriented. Which means the "The STAR", "Mr. DEPENDABLE" or any other individual awards should be stopped. If it is a failure it is for the team and if it is a success it is also for team. If any individual is performing good or bad then it is team's behaviour.

Now the question is how to recognize the good work of individual and the simple answer is "Rewards". Good work to be reflected in promotions and money.

Moving Trends - ACID to BASE (NoSql)

Sales guy - "Hey! Are you guys just stuck with SQL Databases?" and the reply "Yes ..." leaves the sales guys with a thought of plenteous opportunities and weirdy expressions as if he is talking to someone from stone age. Surely the trends are moving from ACID to BASE i.e. SQL to NoSQL (Not only SQL) but the question is should the business adopt? Which solution should they adopt.

There can be multiple answers but my simple take is "Yes, but only if the business needs it and it is making the transformation to the existing business.".

Most of us know but trying to make the point again that No-SQL have nothing to do with the SQL or query language but it is just related to the transaction processing side i.e. reads and writes of the system. Therefore I am considering ACID (Atomicity, Consistency, Isolation, Durability) for the SQL databases and BASE (Basically Available, Soft state, Eventual consistency) for the No-SQL database.

Another big debate can start on "Is the whole planet moving from ACID to BASE?" And the answer is "Noooo !". We are not throwing away whatever we learnt from ACID theories and an excellent example can be Spanner. A planet scale database with ACID properties. Yes I know the CAP (Consistency, Availability, Partition tolerance) theorem and having my fingers crossed for Spanner.

Best wishes for a very-2 happy new year 2015.