Ravi Sir's Cards › AWS
Analytics or OLTP?
This comparison card contrasts Analytics or OLTP. Amazon Redshift is described as columnar analytics at scale. Amazon RDS/Aurora is described as row-store transactions and apps. The card pairs Amazon Redshift with warehousing & BI, and Amazon RDS/Aurora with application databases.
Read card text
What this card says
Analytics or OLTP?
Amazon Redshift
Columnar analytics at scale.
Amazon RDS/Aurora
Row-store transactions and apps.
Key points
Year of sales facts for BI.
Checkout cart writes.
Example
SELECT heavy joins / INSERT order row
Use when
Warehousing & BI.
Application databases.