RDBMS vs NOSQL
RDBMS : RDBMS stands for Relational Database Management System, example of this RDBMS is mysql, postgresql etc., this database systems is build primarily on relations between tables as of primary key and foreign key. The tables in this databases are with fixed schema as per we cannot change the no of columns when our application scales up. when you want to use the application for the Transaction involved then RDBMS is the way to go. The primary selling point of the RDBMS is the Transaction. when we try to scale our application, we can use 2 methods namely Vertical Scaling Horizontal Scaling Limitations of Scaling with RDBMS : When the data is present in only one server, then the scaling in RDBMS is also good but when the application grows we need multiple servers to store the data, while calling that because of the network I/O and the join statements is usually a costly query to run. While combining with the other servers it makes the query very slow. That is w