Data Geeks Hub
    ACID Properties Databases
Relational DatabasesNon-Relational Databases
It manages structured data.It manages all types of data.
SQLNoSQL
Pre-Defined Schema / StructureNo common Schema / Structure
Mostly Tabular FormatNon – Tabular Format
Relational databases are organized in rows and columns in a series of tables. The data within these tables relate to each other, hence why it’s called relational!Unlike relational databases that store data in tables, non-relational databases don’t have a common structured schema. Instead, data is stored in a non-tabular format.
Eg: –
Oracle, Microsoft SQL Server, PostgreSQL, MySQL, SAP HANA, IBM Db2  		Eg:-
JSON, XML, Graphs,
SQL database examples: 
MySql, Oracle, Sqlite, Postgres, and MS-SQL. NoSQL database examples: MongoDB, BigTable, Redis, RavenDb, Cassandra, Hbase, Neo4j, and CouchDb.  		NoSQL or non-relational databases examples: MongoDB, Apache Cassandra, Redis, Couchbase, and Apache HBase.  
Types: – TablesTypes: –
Document
Graph
Key-Value
Column  
Advantages: –
ACID Compliant
Normalization
Data Accuracy
Reliability
No Redundancy		Advantages: –
Scalable
Flexible Data Structure
High-Speed Ingestion
Disadvantages: –
High Cost
Lack of Scalability
Performance Issue
Data Limitations		Disadvantages: –
Standarization Challenge
No ACID Compliance
Risk of Dark Data