Skip to main content

NoSQL vs SQL

I am sure most of you all are familiar with SQL database and have worked with MYSQL, Oracle or other SQL databases. And obviousely you must have heard of "NOSQL" as well. So in this blog post we'll see what this NoSQL is and the key differences between NoSQL and SQL.

What is "NOSQL"?
NOSQL stands for Not Only SQL.It is an approach to database design that can accomodate a wide variety of data models. NoSQL doesn't have a predefined schema and used for big data and real time web applications.

There are several types of database types.
1.Key-Value : Stores data as key value pairs
     Ex: Redis, Riak, Memcached
2.Document : Stores data as documents (JSON,BSON,XML)  
     Ex: MongoDB
3.Column : Stores data in column families as rows have many columns assosiated with.
     Ex: Cassendra
4.Graph : Stores entities(nodes) and relationships(edges) between them and represent it in a graph.
     Ex: Neo4j



Benefits of NoSQL

Basically NoSQL databases are more more scalable and provides a comparatively superior performance.

  • Large volumes of rapidly changing structured, semi-structured, and unstructured data
  • Agile sprints, quick schema iteration, and frequent code pushes
  • Object-oriented programming that is easy to use and flexible
  • Geographically distributed scale-out architecture instead of expensive, monolithic architecture

Now as you have an idea of what NOSQL is, let's see the major differences between SQL and NOSQL.


As you've now have a good understanding of NoSQL now, it's up yo you to browse and grab the more interesting stuff with the thousands and thousands of tutorials available.



Comments