Posts Tagged MS-SQL

Jun 10 2014

Crouching “NoSQL” Cautious “SQL”

“According to analysis by Wikibon’s David Floyer (and highlighted in the Wall Street Journal), the NoSQL database market is expected to grow at a compound annual growth rate of nearly 60% between 2011 and 2017. The SQL slice of the Big Data market, in contrast, will grow at just a 26% CAGR during that same time period.” NoSQL adoption will go big bang but will it impact all the organizations? Will SQL lose this battle? Does everybody need to care about NoSQL? First of all, there is no battle to begin with. NoSQL doesnt mean NO SQL. It simply means “Not only SQL”. Wikipedia defines NoSQL database as

                  “A NoSQL or Not Only SQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases. Motivations for this approach include simplicity of design, horizontal scaling and finer control over availability. The data structure (e.g., key-value, graph, or document) differs from the RDBMS, and therefore some operations are faster in NoSQL and some in RDBMS. There are differences though and the particular suitability of a given NoSQL DB depends on the problem to be solved.”

 

Let us understand SQL and NoSQL a bit more better!

NoSQL=SQL

 

Clearly each one has its own merits and shortcomings. There is no standard solution that fits to all business requirements. Sometimes it is more shocking to see how people react/make decisions on this front. See for yourself one such fight.

SQL v/s NoSQL

SQL v/s NoSQL

Platforms, technologies should be chosen to fit business and not vice-versa.  While there are problems SQL isn’t suitable for, it still got its strengths. Lots of data models are simply best represented as a collection of tables which reference each other. Therefore SQL atleast for now should be good enough for most of the organizations. Right now, it’s fair to say NoSQL is only relevant to a very minor proportion of businesses. But that proportion is very very significant! The changing data arena would sooner see a technical innovation driving business innovation very similar to what we have seen with smart phones?

There wasn’t a need for smart phones but the technical innovation provided business opportunities. Likewise, big data promises a huge opportunity for NoSQL.