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

Post a Comment

Popular posts from this blog

Getting started with React js

In this blog post, I'm gonna explain you all about React js, a javascript technology that is used to create interactive single page applications.
Post a Comment
Read more

New features of Java 10

Hello all! In this blog post I am gonna tell you about the new features of java 10.I am pretty sure all of you have heard of Java 10! Well, some of you might have dive in to Java 10 as well. Noo? Then this blog post will be a good beginning for you to learn about java 10 and its new exciting features. I am not gonna tell you about all the features but I will be focusing on the features that I found more interesting. 1.Local Variable Type Inference  Java 10 onwards Java also will have the 'var' keyword like JavaScript. This allows you to specify a variable without mentioning the data type of that particular variable but Java compiler will identify the real data type of the variable you declared.And also note that this 'var' keyword can only be used when defining variables inside methods and variables inside blocks.Although Java 10 allows the users to define variables with 'var', that doesn't make Java a dynamically typed language because once the ty
Post a Comment
Read more