본문 바로가기

AWS Database

(27)
[AWS Certificate]-Amazon Neptune Amazon Neptune - Overview Fully managed graph database service (non-relational) Relationships are first-class citizens Can quickly navigate relationships and retrieve complex relations between highly connected datasets Can query bilions of relationships. with milisecond latency ACID compliant with immediate consistency Supports transaction semantics for highly concurrent OLTP workloads (ACID tra..
[AWS Certificate]-DocumentDB Amazon DocumentDB - Overview Fully-managed (non-relational) document database for MongoDB workloads JSON documents (nested key-value pairs) stored in collections (~tables) Compatible w/ majority of MongoDB applications, drivers, and tools High performance, s calability, and availability Support for flexible indexing, powerful ad-hoc queries, and analytics Storage and compute can scale independen..
[AWS Certificate]-ElastiCache Amazon ElastiCache - Overview Fully-managed in-memory data store (caching service, to boost DB read performance) It is a remote caching service, or a side cache i.e. separate dedicated caching instance Provides rapid access to data across distributed nodes Two flavors (both are open-source key-value stores) - Amazon ElastiCache for Redis - Amazon ElastiCache for Memcached Sub-millisecond latency..
[AWS Certificate]-Athena & Quicksight Athena Serverless SQL Queries on top of your data in S3, pay per query, output to S3 Supports CSV, JSON, Parquet, ORC Queries are logged in CloudTrail (which can be chained with CloudWatch logs) Greate for sporadic queries Quicksight Business Intelligence tool for data visualization, creating dahsboards Integrates with Athena, Redshift, EMR, RDS... AQUA for Redshift AQUA = Advanced Query Acceler..
[AWS Certificate]-Amazon Redshift Amazon Redshift - Overview OLAP database (Data warehousing solution) based on PostgreSQL OLAP = Online Analytical Processing Can query petabytes of structured and semi-structured data across your data warehouse and your data lake using standard SQL 10x performance than other data warehouses Columnar storage of data (instead of row based) Massively Parallel Query Execution (MPP), highly available..
[AWS Certificate]-DynamoDB Streams DynamoDB Streams 24 Hours time-ordered log of all table-write activity React to changes to DynamoDB tables in real time Can be read by AWS Lambda, EC2, ES, Kinesis ... Use cases: Replication, Archival, Notifications, Log processing DynamoDB Streams are organized into shards Records are not retroactively populated in a stream after enabling it Simply enable streams from DynamoDB console Four supp..
[AWS Certificate]-DynamoDB Encryption DynamoDB Encryption Server-side Encryption at Rest Enabled by default Uses KMS 256-bit AES Encryption Can use AWS owned CMK, AWS managed CMK, or customer managed CMK Encrypts primary key, secondary indexes, streams, global tables, backups and DAX clusters Encryption in transit Use VPC endpoints for applications running in a VPC Use TLS endpoints for encrypting data transit DynamoDB Encryption Cl..
[AWS Certificate]-DynamoDB Backup & Restore Backup and Restore in Dynamo DB Automatically encrypted, cataloged and easily discoverable Highly Scalable - create or retain as many backups for tables of any size Backup operations complete in seconds Backup are consistent within seconds across thusands of partitions No provisioned capacity consumption Does not affect table performance or availability Backups are preserved regardless of table ..