SQL vs NoSQL databases – relational vs non-relational databases

SQL databases
NoSQL databases
Databases
Oracle
Microsoft
MySQL
Hadoop
MongoDB
Cassandra
Redis
Upfront cost
free to very expensive
free
ongoing cost
lower operating costs from adminstration and analytics
Higher operating costs from adminstration and analytics
throughput
High
Low
Latency
(processing speed)
Real-time
Slow, mostly historical
portability
MB to TB
TB to ZB
storage
Centralized
Distributed
structure
Structured data like RDBMS
Semi-structured to unstructured
consistency
Stable models
Unstable flat schemas

One thought on “SQL vs NoSQL databases – relational vs non-relational databases

Leave a Reply

Your email address will not be published. Required fields are marked *