Wednesday 4 August, 2010

No SQL

Few weeks ago I came across a new and interesting term called "NoSQL" databases!
Yes you got it right , its called NoSQL and many of the big big IT companies are using them.
As the name suggests , it has got something to do with avoiding SQL or for that matter the traditional
RDBMS. 

This thing is not a replacement of RDBMS , ya but they have a different role to play.
when data gets huge and its retrieval takes collectively a lot of precious time in constraint checks, relationship checks
and forming joins in carrying out millions of queries, NoSQL is the solution.
traditional RDBMS focus more on eliminating redundancy and saving storage space.
whereas these databases give more focus on making data redundant so that it takes lesser time to access it.
because the world is moving on to the cloud concept!
Here when the user presses the 'enter' key, he wont like to wait for the response even for half a nano second.
Here people don't care about how much disk is being utilized because the data is not on their machine
its remote on some other server. Hence speed is what matters in this case.

the term which is creating all the buzz is "SCALABILITY" of the RDBMS!

Many companies like Google and Amazon are using them.
Checkout BigTable! its a proprietary NoSQL implementation  of Google.
but there are more and they differ in different manners, most of them store data as key value pair.
there a lot of them , Redis(I tried this one on windows),MongoDB,CouchDB,Cassandra etc etc. and many more.
Have a look at this blog.


By:- Amogh Talpalikar
MSc-ca 2010-12

No comments:

Post a Comment