SQL “Structured Query Language”

SQL - relational NoSQL - non-relational
Tables / schema Humongous data, collections, documents, duplication of data
Structured Semi/no structure, flexible
Relations Less dependence on relations, quick reads
Atomic Eventually consistent
Monolithic Distributed

SQL

MySql, Oracle, Sqlite, Postgres, MS-SQL, Amazon Aurora (part of RDS).

NoSQL

MongoDB, BigTable, Redis, RavenDb, Cassandra, Hbase, Neo4j, CouchDb, Amazon DynamoDB.

Considerations

  • Horizontal versus vertical scaling.
  • Consistency versus scale - internal versus public.
  • Two processes ensure that the distributed databases remain up-to-date and current: replication and duplication.

References