Difference between RDBMS and NoSql

RDBMS

• Stands for Relational Database Management System
• It is completely a structured way of storing data.
• The amount of data stored in RDBMS depends on physical memory of the system or in other words it is vertically scalable.
• In RDBMS schema represents logical view in which data is organized and tells how the relation are associates.
• It is a mixture of open and closed development models. like oracle, apache and so on.
• RDBMS databases are table based databases This means that SQL databases represent data in form of tables which consists of n number of rows of data
• RDBMS have predefined schemas.
• For defining and manipulating the data RDBMS use structured query language i.e. SQL which is very powerful.
• RDBMS database examples: MySql, Oracle, Sqlite, Postgres and MS-SQL.
• RDBMS database is well suited for the complex queries as compared to NoSql.
• If we talk about the type of data then RDBMS are not best fir for hierarchical data storage
• Scalability: RDBMS database is vertically scalable so to manage the increasing load by increase in CPU, RAM, SSD on a single server.
• RDBMS is best suited for high transactional based application and its more stable and promise for the atomicity and integrity of the data.
• RDBMS support large scale deployment and get support from there vendors.
• Properties: ACID properties(Atomicity, Consistency, Isolation, Durability).

NoSql

• Stands for Not Only SQL
• It is completely a unstructured way of storing data.
• While in Nosql there is no limit you can scale it horizontally.
• Work on only open source development models.
• NoSQL databases are document based, key-value pairs, graph databases or wide-column stores.whereas NoSQL databases are the collection of key-value pair, documents, graph databases or wide-column stores which do not have standard schema definitions which it needs to adhered to.
• NoSql have dynamic schema with the unstructured data.
• It uses UnQL i.e. unstructured query language and focused on collection of documents and vary from database to database.
• NoSQL database examples: MongoDB, BigTable, Redis, RavenDb, Cassandra, Hbase, Neo4j and CouchDb
• NoSql is note well suited for complex queries on high level it dose not have standard interfaces to perform that queries.
• NoSql is best bit for hierarchical data storage because it follows the key-value pair way of data similar to JSON. Hbase is the example for the same.
• Scalability: as we know Nosql database is horizontally scalable so to handle the large traffic you can add few servers to support that.
• NoSql is still rely on community support and for large scale NoSql deployment only limited experts are available.
• Properties: Follow Brewers CAP theorem(Consistency, Availability and Partition tolerance).

Embed this Infographics on your site(Copy this Code)

{`


Courtesy of:
AssignmentHelpNet
`}

Know more about NoSql Click here

To get help in your projects in RDBMS and NoSql Contact Us