Relational Document Time Series Amazon Aurora Amazon DocumentDB - - PowerPoint PPT Presentation

relational document time series
SMART_READER_LITE
LIVE PREVIEW

Relational Document Time Series Amazon Aurora Amazon DocumentDB - - PowerPoint PPT Presentation

Relational Document Time Series Amazon Aurora Amazon DocumentDB Amazon Timestream Graph Key-value Amazon RedShi Amazon Neptune Amazon DynamoDB Amazon RDS Ledger In-memory Amazon Quantum AWS Database Migration Amazon ElastiCache


slide-1
SLIDE 1

Amazon Aurora Amazon RDS Amazon RedShiﬞ

Relational

Amazon DynamoDB

Key-value

Redis

Amazon ElastiCache

Memcached

In-memory

Amazon DocumentDB

Document

Amazon Neptune

Graph

Amazon Timestream

Time Series

QLDB

Amazon Quantum Ledger Database

Ledger

AWS Database Migration Service

DMS

slide-2
SLIDE 2

Id First Last 1 Mark Nunnikhoven 2 Walter Ladd 3 Orlene Lapierre 4 Jen Charest

Names

Id NameId BusId 1 1 2 2 1 1 3 2 1 4 3 2

NamesToBuses

Id Start End 1 Airport Hotel 2 Hotel Office

Buses Relational Database

slide-3
SLIDE 3

SELECT * FROM Names n INNER JOIN NamesToBuses n2b ON n.Id = n2b.NameId INNER JOIN Buses b ON b.Id = n2b.BusId;

Relational Database Query

slide-4
SLIDE 4

Mark Walter Orlene Jen Bus #1 Bus #2 Graph Database

R I D E S R I D E S R I D E S R I D E S RIDES RIDES RIDES

slide-5
SLIDE 5

{ Bus { Names { First, Last } } }

Graph Database Query

Syntax depends on the graph query language used but the concepts are the same

slide-6
SLIDE 6

🔒 ObjectId First Last Customer-First-Last-## Mark Nunnikhoven

Customer Amazon DynamoDB

🔒 ObjectId Start Finish Stops Bus-## Location Name Location Name [ Location Name, Location Name, … ]

Bus

🔒 ObjectId FirstBusStop LastBusStop BusID CustomerID … Ride-TIMESTAMP-BUS-## Location Name Location Name Bus-## Customer-First-Last-## …

Ride