Nic Acton
  • My Gitbook
  • My Favorite Things
    • Podcasts
    • Newsletters
  • Monthly Summaries
    • May 2019
    • June 2019
  • Cloud Computing
    • Cloud Concepts
    • AWS
      • Certified Solutions Architect
      • Well Architected Framework
        • Operational Excellence
        • Reliability
        • Performance Efficiency
        • Cost Optimization
        • Security
      • Analytics
        • Elasticsearch Service
        • Kinesis
        • Elastic MapReduce (EMR)
      • Compute Services
        • Elastic Beanstalk
        • Elastic Container Service (ECS)
      • Deployment
        • CloudFormation
      • Application Services
        • Key Management Service (KMS)
        • Simple Queue Service (SQS)
        • API Gateway
        • Simple Work Flow (SWF)
        • Amazon MQ
        • Simple Notification Service (SNS)
      • Simple Storage Service (S3)
        • Macie
      • Databases
        • RDS
        • DynamoDB
        • ElastiCache
        • Neptune
        • Redshift
      • Cloudfront
      • IAM
      • Monitoring
        • Trusted Advisor
        • Amazon Inspector
        • AWS Config
        • AWS Shield
        • CloudWatch
          • VPC Flow Logs
        • CloudTrail
        • Guard Duty
      • Route53
      • Serverless Architectures
        • Lambda
      • VPC
        • Highly Available & Fault Tolerant VPCs
        • Hybrid Environments
          • VPC Peering
          • Direct Connect
        • Cloud HSM
    • GCP
    • Azure
    • HashiCorp
    • Red Hat
      • RHEL
        • Basics
        • Grep & Regex
        • SSH
      • Ansible
    • Tutorials/Guides
      • Linux
        • Admin
  • Software Engineering
    • Machine Learning
      • Deep Learning
        • Tensorflow
      • Training and Loss
    • Programming
      • APIs
    • Security
    • Web Development
      • OSI 7 Layer Model
    • Tutorials/Guides
      • Apache Server
    • Virtualization
      • Virtual Machines
      • Containers
      • Serverless
  • Fitness
    • Nutrition
      • Diets
      • Macronutrients
      • Supplements
      • Miscellaneous
    • Strength Training
    • BodyBuilding
  • Miscellaneous
    • Technology Ethics
      • Education
    • Interesting Concepts
      • Libertarian Paternalism
Powered by GitBook
On this page
  • Essentials
  • Relational (SQL) Databases
  • NoSQL Databases
  • AWS Managed DB Services

Was this helpful?

  1. Cloud Computing
  2. AWS

Databases

Different database options inside AWS

Essentials

Relational (SQL) Databases

  • Structured Data (schema)

  • Data is normalized and spread across multiple tables

  • SQL Query Language

  • ACID (Atomicity, Consistency, Isolation, Durability) Compliant

  • Vertical Scaling and Read Replicas

  • OLTP/OLAP

    • OLTP - Transactional - Good for reads/writes

    • OLAP - Analytical - Good for queries

  • Examples: Oracle, SQL Server, MySQL, PostgreSQL

NoSQL Databases

  • Semi-structured Data (schema-less)

  • Flat table structure

  • API Queries

  • High Transaction Rates

  • Horizontal Scaling

  • Four Types: Column, Key-Value, Document, Graph

    • Column - Stores in columns, fast for querying (only looking in certain columns by query)

    • Key-Value - Simple (key and a value)

    • Document - JSON/XML storage

    • Graph - Relationship between data optimizations

  • Examples: MongoDB, CouchDB, HBase, Cassandra, Riak

AWS Managed DB Services

Offloading a lot of maintenance and optimization, also usually serverless so they scale very well and have fault tolerance/high availability! But managed services may not be optimized outside of a given database like Mongodb or Cassandra. Also, you don't get privileged access to tweaking and tuning.

  • Relational DB Services

  • NoSQL DB Services

    • HBase on EMR - Column DB

PreviousMacieNextRDS

Last updated 6 years ago

Was this helpful?

- Many engines like MySQL available

- Document DB

- Key-Value DB

- Graph DB

RDS
Redshift
DynamoDB
ElastiCache
Neptune