Author: KAMAL
Keywords: NoSQL, SQL, RDBMS and Hadoop.

What is NoSQL and the difference between SQL and NoSQL ?

When data handling is not following RDBMS data rules and regulations, data stored as it comes under the columns defined on the fly then we can refer it as NoSQL database. There are no referential integrity rules on the NoSQL. Where as SQL based RDBMS is highly structured and supports all the needs of OLTP and OLAP systems. But RDBMS needs proper analysis and design changes whener there are new fields are required to add to a table. But in NoSQL, we can add data immdeiately by adding additional columns. Later we can consolidate the data in related columns.

NoSQL is a middle ground between Hadoop and RDBMS (SQL) platforms where Hadoop handles highly structured data where as RDBMS handles highly structured data, but NoSQL is right for semistructured flexible data handling needs.

BLOGS INDEX

Informatica Big Data Management Editions - The BIG DATA and Data Science Game changer !

Tableau 10.1 Beta version released...

What is NoSQL and the difference between SQL and NoSQL ?

New Features of Tableau 10 Desktop

Tableau 10 Beta version released...

Difference between Tableau, QlikView, MSBI and PowerBI – PART I

What is Business Intelligence and Analytics Platform ?

What is BIG Data ? - Part I

Difference between Apache Hadoop and Apache Spark – PART I