Amazon Redshift & Amazon DynamoDB

47 Pages·2014·3.22 MB·English

Amazon Redshift &
Amazon DynamoDB
Michael Hanisch, Amazon Web Services
Erez Hadas-Sonnenschein, clipkit GmbH
Witali Stohler, clipkit GmbH 2014-05-15

© 2014 Amazon.com, Inc. and its affiliates. All rights reserved. May not be copied, modified, or distributed in whole or in part without the express consent of Amazon.com, Inc.
Amazon Redshift &
Amazon DynamoDB
Amazon Redshift
Amazon Redshift
Fast, simple, petabyte-scale data warehousing
for less than $1,000/TB/Year
A fully managed data warehouse service
•  Massively parallel relational data warehouse
•  Takes care of cluster management and
distribution of your data
•  Columnar data store with variable compression
•  Optimized for complex queries across many
large tables
•  Use standard SQL & standard BI tools
Amazon Redshift
Amazon DynamoDB
A fully managed fast key-value store
•  Fast, predictable performance
•  Simple and fast to deploy
•  Easy to scale as you go, up to millions of IOPS
•  Pay only for what you use: Read / write IOPS + storage
•  Data is automatically replicated across data centers
Amazon DynamoDB
Amazon DynamoDB Amazon Redshift
•  Fast insert & update •  Fast queries
•  Limited query •  Flexible queries
capability (single (JOINs, aggregation
table only) functions, …)
•  NoSQL database •  SQL
Queries in Amazon DynamoDB
Queries in Amazon DynamoDB
•  Query or BatchQuery APIs retrieve items
•  Scan & filter to comb through a whole table
•  You have to join tables in your own code!
Amazon DynamoDB