DB: SQL and NoSQL



Similar Posts:


  • Q: Differences between SQL and NoSQL
Name Summary
Schema Fixed schema vs Schema-free
Querying SQL vs UnQL(Unstructured query language)
Scalability vertical scaling vs horizontal scarling
Reliability ACID vs eventual consistency

ACID: Atomicity, Consistency, isolation, durability


  • Q: Relation Base Database
Name Summary
Open Source RDBMS Mysql, Mariadb, postgres
Commercial RDBMS Oracle, Microsoft SQL Server, AWS RDS/Aurora

  • Q: NoSQL Database
Name Summary
General K/V DB AWS DynamoDB, Mongodb, AWS DocumentDB
Wide-column Cassandra, HBase
Document based Mongodb, Couchbase
Caching redis/memcached
Search engine DB Elasticsearch, Lucence, Sphinx
Graph DB Neo4j, OrientDB
Time series database InfluxDB
Ledger database Amazon Quantum Ledger Database (QLDB)
  • Wide-Column Databases: Instead of ‘tables,’ in columnar databases we have column families, which are containers for rows. Unlike relational databases, we don’t need to know all the columns up front and each row doesn’t have to have the same number of columns. Columnar databases are best suited for analyzing large datasets – big names include Cassandra and HBase.
  • HDFS: can be used to store huge amount of static data, such as pictures and videos.
  • HBase: TODO
  • Cassandra: TODO
  • MongoDB: TODO
  • Couchbase: TODO

  • Q: Data store for big data
Name Summary
Hadoop  
Spark  
Impala  

  • Q: Cross-site DB replication/migration

A: TODO


Leave a Reply

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