Other Database Types

• Relational databases are strict on schema
• For modern applciations we need a little bit of flexibility and also with the rise of big data
• Then Document Databases started as NOSQL Databases
• The basic idea of NOSQL is no formal query language.
• Data will not be strict on Schema
• Other advantage of NOSQL Databases is they are designed to horizontally scale
• Types of NOSQL Databases
  • Document
  • Key value
  • Column databases
  • Graph Databases
• Document Databases:
  • Each record is considered as a document generally in json format
  • mostly apart from id, all the other fields are flexible
  • Options:
    • mongodb
• Key Value Stores:
  • Data is collection of key value pairs
  • Options:
    • AWS Dynamo DB
    • etcd
    • Cache
• Column Database:
  • Generally used for large volume database
  • Options:
    • Cassandra
• Graph Databases:
  • If the records have relations between them like social media then graph databases are popular
  • OPtions:
    • Neo4j
    • neptune
• Ledger (Blockchain)
• Cache Databases:
  • Redis
  • Memcached
• DataWarehouse:

AWS Offerings

• Databases
  • Relational: RDS
    • Microsoft SQL Server
    • Oracle
    • mysql
    • Postgres
    • DB2
  • Relational: (Improvised for AWS)
    • Aurora
  • NOSQL:
    • Dynamo DB
    • DocumentDB (MongoDB)
    • Keyspaces (Cassandra)
    • Neptune (GraphDB)
    • QLDB (Blockchain Ledger)
    • Timestream (IOT)
    • ElasticCache (MemCached & Redis)
    • MemoryDB (Redis)
  • Datawarehouse:
    • RedShift

Azure Offering

• Relational:
  • Azure SQL (Microsoft SQL Server):
    • Azure SQL
    • Managed SQL
    • Azure SQL Vms
  • Azure SQL for mysql
  • Azure SQL for Postgres
• Datawarehouse:
  • Azure Synapse Analytics
• NOSQL:
  • Azure Cosmos DB
    • Mongo DB
    • Key Value
    • …
    • …
• Azure Arc enabled databases services
• Azure cache (Redis)