Base of difference | SQL | NoSQL | NewSQL |
Support | Here support for SQL | Here no support for old SQL. | Here answer is yes and proper support and even enchanced functionalities for Old SQL. |
Scaling | Here we have vertical scaling. | Here we have only vertical scaling. | Here we have vertical and horizontal both scaling. |
OLTP support | When we say about SQL here it is inefficient for OLTP databases. | When we say about noSQL this support such databases but is not the best suited here. | Here we have fully functionally supports OLTP databases and is highly efficient. |
Distributed Databases | No there is not distributed database | Here answer is Yes | Here answer is Yes |
Type of query | When we say about the query handling in SQL it can handle simple queries with ease and faile when we have some complex one. | Here we have a better handling of queries in comparison of SQL. | It is higly efficient in processing the comples queries and smaller query both. |
Example of database | Below are the example of SQL database systems:-
(1)MySQL
(2)IBM Db2
(3)PostgreSQL
(4)Oracle Database
(5)Microsoft SQL Server | Example of NoSQL database systems:-
(1)MongoDB
(2)Redis
(3)Cassandra
(4)Neo4j | Example of NewSQL database systems are:-
(1)VoltDB
(2)NuoDB
(3)SingleStore
(4)Clustrix
(5)CockroachDB |
Relational Property | When we say about the relational modeling here in sql it will follows the relational modeling to a large extent. | Here answer is no and it doesnot follow a relational model and it was designed to be entirely different from that. | Yes becuase relational model is equally essential for real-time analytics. |
ACID property | Here answer is yes as ACID properties are fundamental to their application. | Here answer is no and this have a CAP support. | Here answer is yes and this will take care of ACID properties. |
|
|
| |