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
品質と速度の両立:生成AI時代の品質保証アプローチ
odasho
1
360
使いたいMCPサーバーはWeb APIをラップして自分で作る #QiitaBash
bengo4com
0
1.9k
american aa airlines®️ USA Contact Numbers: Complete 2025 Support Guide
aaguide
0
150
Backlog ユーザー棚卸しRTA、多分これが一番早いと思います
__allllllllez__
1
150
データグループにおけるフロントエンド開発
lycorptech_jp
PRO
1
100
「クラウドコスト絶対削減」を支える技術—FinOpsを超えた徹底的なクラウドコスト削減の実践論
delta_tech
4
170
CRE Camp #1 エンジニアリングを民主化するCREチームでありたい話
mntsq
1
130
無意味な開発生産性の議論から抜け出すための予兆検知とお金とAI
i35_267
4
13k
United Airlines Customer Service– Call 1-833-341-3142 Now!
airhelp
0
170
american airlines®️ USA Contact Numbers: Complete 2025 Support Guide
supportflight
1
110
【5分でわかる】セーフィー エンジニア向け会社紹介
safie_recruit
0
27k
MobileActOsaka_250704.pdf
akaitadaaki
0
130
Featured
See All Featured
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
34
3.1k
The Psychology of Web Performance [Beyond Tellerrand 2023]
tammyeverts
48
2.9k
Product Roadmaps are Hard
iamctodd
PRO
54
11k
Six Lessons from altMBA
skipperchong
28
3.9k
Navigating Team Friction
lara
187
15k
CSS Pre-Processors: Stylus, Less & Sass
bermonpainter
357
30k
Connecting the Dots Between Site Speed, User Experience & Your Business [WebExpo 2025]
tammyeverts
6
300
Agile that works and the tools we love
rasmusluckow
329
21k
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
tammyeverts
53
2.9k
The Web Performance Landscape in 2024 [PerfNow 2024]
tammyeverts
8
690
Rebuilding a faster, lazier Slack
samanthasiow
82
9.1k
Producing Creativity
orderedlist
PRO
346
40k
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?