Overview of NoSQL database #DOTC_Mdb

Overview of NO SQL Database.

Hello Everyone,

Today we will discuss about NO SQL database which is very popular nowadays.  Before NOSQL database go through my previous blog for other IT related topics. As we know SQL follows RDBMS but NoSQL database not follows RDBMS concept. NOSQL means  "not only SQL"  are non tabular, and store data differently than relational tables. NoSQL databases come in a variety of types based on their data model. NOSQL  provide flexible schemas and scale easily with large amounts of data and high user loads. In present day, as we are handling huge amount of data, data being organized and well-structured actually creates a problem, especially at extremely large volumes.

Structured approach of RDBMS database like SQL slows down performance as data volume or size gets bigger and it is also not scalable to meet the needs of Big Data. So NoSQL was conceived as a completely different framework of databases that allows for high-performance, agile processing of information at a much bigger scale. This is the database well-adapted to the high demands of big data. Version of NoSQL runs the database MongoDB, which stores unstructured data. This means that you don’t need to know in advance exactly what kind of data you’ll be collecting and storing. You can collect a lot more data of different kinds and can access and analyze data much faster.NoSQL is centered on the concept of distributed databases, where unstructured data may be stored across multiple processing nodes, and often across multiple servers.

 

Benefits of NOSQL database :

Handle large volumes of data at high speed with a scale-out architecture.

Store unstuctured, semi-structured, or structured data.

Take full advantage of the cloud to deliver zero downtime.

Enable easy updates to schemas and fields.

Developer friendly.

 SQL vs  NOSQL

1. SQL is relational database whereas NOSQL are non relational database

2. SQL databases are vertically scalable, NoSQL databases are horizontally scalable.

3. SQL databases uses structured query language and have a predefined schema whereas  NoSQL databases have dynamic schemas for unstructured data.

4. SQL databases are better for multi-row transactions whereas NoSQL are better for unstructured data like documents.

5. SQL databases are mainly table based, while NoSQL databases stores document, key-value, graph or wide-column stores.

 

This is the overview of NOSQL database and nowadays NOSQL database highly used where data is big , but SQL databases provide great benefits for transnational data whose structure doesn't change frequently and where data integrity is paramount. It's also best for fast analytical queries. NoSQL databases provide much more flexibility and scalability, which lends itself to rapid development and iteration.

In big industry still SQL is used as it follows RDBMS concept and uses databases like Oracle, Sybase, DB2 etc whereas NON SQL uses Mongo Database which provide more flexibility, but still SQL and PL/SQL mostly uses in Banking and telecom domain.

Please go through this blog and let me know if you have any doubts. Blogs related to SQL , PL/SQL and other IT related topics you can explore it in my archive folder. In next blog I will come up with next interesting topic.

Thanks.