RDBMS VS NoSql

What is Relational Database (RDBMS)?

A relational database stores data in tables in an organized way. These tables can be connected to each other using something called foreign keys. We will use SQL to work with the data.

Examples:

• MySQL, PostgreSQL, Oracle, Microsoft SQL Server

Use Case:

• Banking, ERP, CRM systems

What is NoSQL Database?

NoSQL stands for “Not Only SQL”. These kinds of databases are more flexible and can handle unstructured data like no limit these data types need to be used. These are great for big and fast-moving applications.

Examples:

• Document-based: MongoDB, CouchDB
• Key-value stores: Redis, DynamoDB
• Graph DB: Neo4j, Amazon Neptune
• Column-based: Cassandra, HBase

Use Case:

• Social media, IOT, real-time Apps

When to choose NoSQL

• When our data often changes or doesn’t have fixed format.
• For handling large amount of data at a high speed
• When developing an application that has real-time features like chats and feeds.
• When the application needs to scale across multiple servers.

Why we use RDBMS

• When we know what are the data we are going to store in database.
• When our application works on complex relationships.
• When we need reliable transactions.

Can we use both databases?

Yeah we can use RDBMS for user profiles and payments, with that for storing chats, logs and feeds we can use NoSQL in one application.