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 Spring Boot

In this blog post I am gonna give you all an introduction on Spring Boot, an application framework and inversion controller for the java platform. Before diving in to Spring Boot framework, let's get a brief idea about the Spring framework on top of which the Spring Boot was created. Spring is a very popular application framework for java web and enterprise and web applications which was initially written by Rod Johnson.Millions and millions of people around the world use this to make their codes high performing, easily testable and reusable.Spring framework is build on top of the Dependency Injection (DI) concept. What is Dependency Injection? When it comes to a complex java application, the classes should not be depending on one another, in order to reuse our code and to make the unit testing easy.For such situations, dependency injection is used to connect the classes together while making them independent.So what exactly happens here? Let's think of Dependency in...
Post a Comment
Read more

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

Noob introduction to Node.js

In this blog post I am gonna give you all a brief idea about Node.js. Earlier JavaScript was purely used for client side scripting, and it was embedded to a html page.But the node js developers use it for server side scripting(to produce the content of dynamic web pages before sending it to the user.) Node.js is an open source, cross platform run-time environment that executes JavaScript code server side. Why node.js? Node.js uses asynchronous programming. When a file request comes a ASP/PHP file would, Send the task to the computer's file system. Wait for the system to open and read the file. Sends the respond back to the client Get ready to handle the next task. But as node.js is using asynchronous programming, it would handle the request in a different manner.It would, Send the task to the computer's file system. Handles the next coming task. Returns the respond of the first task to the client when the system has completed it. In brief it reduces wa...
Post a Comment
Read more