Contents

About RDB and NoSQL

   Jun 27, 2023     1 min read

This is an article about the difference between RDB and NoSQL.

can be divided into four main parts

  1. data model: RDB: RDB structures data in the form of tables. Tables store data in a structure of rows and columns, and data is managed according to a set schema. Data can be linked by establishing relationships between tables. NoSQL: NoSQL supports a variety of data models. It primarily uses data models such as Key-Value, Document, Column, and Graph. NoSQL is schema flexible and does not enforce relationships between data.
  2. scalability: RDB: RDBs primarily use vertical scaling, meaning they perform hardware upgrades to improve the performance of the server. Horizontal scaling requires more complex configuration and data partitioning. NoSQL: NoSQL is better suited for horizontal scaling. You can distribute and parallelize data across multiple servers to increase performance and scalability.
  3. schema flexibility: RDB: RDBs require the data schema to be predefined. It strictly specifies the structure and type of data to ensure data consistency. NoSQL: NoSQL is schema flexible. It allows for flexible data model changes, such as adding new fields or changing existing ones.
  4. Transactional and consistent: RDB: RDBs adhere to ACID principles to ensure data consistency and atomicity of transactions. Multiple operations can be bundled into a single transaction. NoSQL: NoSQL uses a more flexible approach to ensuring transactions and consistency. NoSQL databases have a choice of consistency models, and you can adjust the tradeoff between consistency and performance by adjusting the scope.