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
DatabricksにOLTPデータベース『Lakebase』がやってきた!
inoutk
0
110
DBのスキルで生き残る技術 - AI時代におけるテーブル設計の勘所
soudai
PRO
50
19k
What’s new in Android development tools
yanzm
0
310
高速なプロダクト開発を実現、創業期から掲げるエンタープライズアーキテクチャ
kawauso
2
9.3k
AI時代の開発生産性を加速させるアーキテクチャ設計
plaidtech
PRO
3
160
整頓のジレンマとの戦い〜Tidy First?で振り返る事業とキャリアの歩み〜/Fighting the tidiness dilemma〜Business and Career Milestones Reflected on in Tidy First?〜
bitkey
2
16k
Delegating the chores of authenticating users to Keycloak
ahus1
0
140
SEQUENCE object comparison - db tech showcase 2025 LT2
nori_shinoda
0
140
United Airlines Customer Service– Call 1-833-341-3142 Now!
airhelp
0
170
AI専用のリンターを作る #yumemi_patch
bengo4com
5
4.3k
React開発にStorybookとCopilotを導入して、爆速でUIを編集・確認する方法
yu_kod
1
270
Backlog ユーザー棚卸しRTA、多分これが一番早いと思います
__allllllllez__
1
150
Featured
See All Featured
[RailsConf 2023] Rails as a piece of cake
palkan
55
5.7k
A Modern Web Designer's Workflow
chriscoyier
695
190k
What's in a price? How to price your products and services
michaelherold
246
12k
Navigating Team Friction
lara
187
15k
Side Projects
sachag
455
42k
The World Runs on Bad Software
bkeepers
PRO
69
11k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
stephaniewalter
281
13k
Into the Great Unknown - MozCon
thekraken
40
1.9k
Speed Design
sergeychernyshev
32
1k
A designer walks into a library…
pauljervisheath
207
24k
The Language of Interfaces
destraynor
158
25k
How to Think Like a Performance Engineer
csswizardry
25
1.7k
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?