Amazon DynamoDB

• noSQL database service → not relational, no fixed tables/columns, flexible format
• single-digit millisecond latency at any scale
• supports document + key-value data models

Create Table

• each table needs a primary key / partition key - used to partition data across DynamoDB servers
• sort key - used to sort data within table

Enter Data

• table - collection of data
• items - rows/entries
• attributes - columns/elements of data
• explore items →
  • create items
  • modify items
  • query / scan items
• tables → select + delete table
• can use AWS data pipeline to programmatically load data

knowledge check

1. query → retrieve data based on specific param
2. before deleting table → consider creating backup of data
3. flexibility → attributes can be added to items without disturbing others
4. inserting data → items can different attributes exc. primary key which must be present in each item
5. primary key + sort key → both are used together to uniquely identify items