Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Redshift Introduction
Search
elprup
March 27, 2014
Technology
0
96
Redshift Introduction
Brief intro for amazon redshift service
elprup
March 27, 2014
Tweet
Share
More Decks by elprup
See All by elprup
Python Logging Tutorial
elprup
1
73
Other Decks in Technology
See All in Technology
freeeのアクセシビリティの現在地 / freee's Current Position on Accessibility
ymrl
2
200
DatabricksにOLTPデータベース『Lakebase』がやってきた!
inoutk
0
110
Glacierだからってコストあきらめてない? / JAWS Meet Glacier Cost
taishin
1
160
LLM時代の検索
shibuiwilliam
2
170
AIの全社活用を推進するための安全なレールを敷いた話
shoheimitani
2
520
LangChain Interrupt & LangChain Ambassadors meetingレポート
os1ma
2
320
How Do I Contact HP Printer Support? [Full 2025 Guide for U.S. Businesses]
harrry1211
0
120
データグループにおけるフロントエンド開発
lycorptech_jp
PRO
1
110
品質と速度の両立:生成AI時代の品質保証アプローチ
odasho
1
360
ゼロからはじめる採用広報
yutadayo
3
950
高速なプロダクト開発を実現、創業期から掲げるエンタープライズアーキテクチャ
kawauso
2
9.4k
オーティファイ会社紹介資料 / Autify Company Deck
autifyhq
10
130k
Featured
See All Featured
Agile that works and the tools we love
rasmusluckow
329
21k
Large-scale JavaScript Application Architecture
addyosmani
512
110k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
331
22k
Understanding Cognitive Biases in Performance Measurement
bluesmoon
29
1.8k
Mobile First: as difficult as doing things right
swwweet
223
9.7k
BBQ
matthewcrist
89
9.7k
Automating Front-end Workflow
addyosmani
1370
200k
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
194
16k
Keith and Marios Guide to Fast Websites
keithpitt
411
22k
jQuery: Nuts, Bolts and Bling
dougneiner
63
7.8k
Six Lessons from altMBA
skipperchong
28
3.9k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
34
3.1k
Transcript
Redshift introduction A distributed data ware house
Agenda • What is the problem • How to solve
it by Redshift • Compared to other technologies
Data, more data
Data, more data
Data, more data • User information • User blog articles
• User visit log User_id Gender Age 1000 Female 18 User_id Article_id Contents Alice Female Hello,world User_id URL Time 1000 http://baidu.com 2014-03-01 01:00
How to use data? • NoSQL • RDBMS • Hive
• Redshift
Data warehouse concepts • Dimensions and metrics
Data warehouse concepts
Redshift • An Amazon Redshift data warehouse is an enterprise-class
relational database query and management system.
Redshift Targets • Interactive • Volume • Variety • Security
Architecture • Postgres console • Query process
Architecture
Storage(Reduce I/O) • Column • Compression • Block size •
Sort key
Computer(MPP) • Parallel unit: Slice • Distributed key • Join
optimize
Performance • https://amplab.cs.berkeley.edu/benchmark/
Management • Scalable • Create/Clone Cluster
Security • Backup: Snapshot • User auth • User quota:
Workload management
Compared to Hadoop Hive • Speed • Volume • Flexible
• Operation
Question?