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 is running by RDBMS products only.
But we should not avoid new terms like: BigData, NoSQL which are the future of Data Storage and Data Science.
I have marked some of the major differences between RDBMS and NoSQL technology.
The Relational database is completely 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 different method like 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 each and every transaction by following the ACID Properties and there are no any guarantees that NoSQL database is following ACID properties.
The Relational database is enough capable 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 enough capable to handle complex and nested transactions, but at this movement NoSQL can handle 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 require for NoSQL technology.
We can preferred NoSQL technology for dynamic web application and mobile application like, blogging, social networking, news board, Content Management System.
The compare to NoSQL database, we can find big community support for Relational Database.