This article is half-done without your Comment! *** Please share your thoughts via Comment ***
This is my third day with the theory of NoSQL technology and understanding the core difference between Relational Database Management System and NoSQL technology.
The RDBMS products have been around us more than 25 years, and still, many enterprise applications are running on RDBMS products only.
But we should not avoid new terms like BigData, NoSQL which is the future of Data Storage and Data Science.
I marked some of the major differences between RDBMS and NoSQL technology.
The Relational database is entirely structured way of storing data, and the NoSQL is an unstructured way of storing the data.
The Relational database is fixed schema oriented and stores data into a tabular format. The NoSQL database does not depend on any other schema and stores data using a different architecture like key-value store, column base store, document base store, graph base store.
The Relational database uses Structured Query Language for manipulating the data and NoSQL does not follow any standard query language because it uses a different method of document reading and key-value pair matching.
The Relational database is vertically scalable, and NoSQL database is horizontally scalable.
We can add more hardware resources for vertical scaling of a Relational Database, and We can add more server or node for horizontal scaling of a NoSQL database.
The Relational database gives guarantee for every transaction by following the ACID Properties, and there are no any guarantees that NoSQL database is following ACID properties.
The Relational database is capable enough to handle complex query and relations of the tables. The NoSQL database does not govern by any standard so, in some situation, it cannot handle more complex queries.
The Relational database is capable enough to handle complex and nested transactions, but at this movement, NoSQL can process only simple transactions only.
We should not use NoSQL for the big ERP system because since 2009 lots of research is going on NoSQL technology and lots of improvement also requires for NoSQL technology.
We can prefer NoSQL technology for dynamic web application and mobile application like blogging, social networking, news board, Content Management System.
The compare to NoSQL databases, we can find big community support for Relational Database.