Key Differences between Relational and Non-Relational Databases
Relational databases
Have tables that store fields in columns, and rows of records that hold data in relational database management systems (RDBMS)
Use primary and foreign keys to establish relationships that control how certain data relates to data in other tables
Leverage normalization techniques for optimal design
Use traditional SQL language to query and handle transactions within the database
Expect data to fit within the tables that are designed for the database
Are designed around the ACID Principles
Non-relational databases
do not follow the same structural requirements of a SQL-based database
Are much easier to scale and build for web-based applications and do not require the same level of detailed planning and structure that relational databases require
Use various programming languages to retrieve and handle transactions within the stored data
categorized into four sub-types:
document-oriented
most prominent
key-value stores
column-oriented
graph stores
Can store structured and non-structured data with more flexibility