Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Redshift Introduction

Sponsored · SiteGround - Reliable hosting with speed, security, and support you can count on. →
Avatar for elprup elprup
March 27, 2014
Technology
99
0

Redshift Introduction

Brief intro for amazon redshift service

Avatar for elprup

elprup

March 27, 2014

More Decks by elprup

See All by elprup
Python Logging Tutorial
Avatar for elprup elprup
1
83

Other Decks in Technology

See All in Technology
#jawsugyokohama 100 LT11, "My AWS Journey 2011-2026 - kwntravel"
Avatar for Shinichiro Kawano shinichirokawano
0
280
聞き手の目線で考えるプロポーザル
Avatar for Takepepe takefumiyoshii
0
410
Hello UUID
Avatar for mimifuwacc mimifuwacc
0
140
Zero Data Loss Autonomous Recovery Service サービス概要
Avatar for oracle4engineer oracle4engineer
PRO
5
14k
会社紹介資料 / Sansan Company Profile
Avatar for Sansan, Inc. sansan33
PRO
17
410k
Azure PortalなどにみるWebアクセシビリティ
Avatar for tomokusaba tomokusaba
0
320
Amazon S3 Filesについて
Avatar for Yuuki Yamashita yama3133
2
110
システムは「動く」だけでは足りない 実装編 - 非機能要件・分散システム・トレードオフをコードで見る
Avatar for nwiizo nwiizo
3
390
みんなの「データ活用」を支えるストレージ担当から持ち込むAWS活用/コミュニティー設計TIPS 10選~「作れる」より、「続けられる」設計へ~
Avatar for Yoshiki Fujiwara yoshiki0705
0
190
Bluesky Meetup in Tokyo vol.4 - 2023to2026
Avatar for Takuma Shinohara shinoharata
0
190
BigQuery × dbtでコスト削減した話
Avatar for 株式会社ライトコード rightcode
0
140
Introduction to Bill One Development Engineer
Avatar for Sansan, Inc. sansan33
PRO
0
410

Featured

See All Featured
Leading Effective Engineering Teams in the AI Era
Avatar for Addy Osmani addyosmani
9
1.8k
Primal Persuasion: How to Engage the Brain for Learning That Lasts
Avatar for Mike Taylor tmiket
0
320
Become a Pro
Avatar for Speaker Deck speakerdeck
PRO
31
5.9k
No one is an island. Learnings from fostering a developers community.
Avatar for Antonio thoeni
21
3.7k
How to Build an AI Search Optimization Roadmap - Criteria and Steps to Take #SEOIRL
Avatar for Aleyda Solis aleyda
1
2k
The agentic SEO stack - context over prompts
Avatar for schlessera schlessera
0
740
GraphQLの誤解/rethinking-graphql
Avatar for sonatard sonatard
75
12k
Claude Code のすすめ
Avatar for schroneko schroneko
67
220k
The Hidden Cost of Media on the Web [PixelPalooza 2025]
Avatar for Tammy Everts tammyeverts
2
260
jQuery: Nuts, Bolts and Bling
Avatar for Doug Neiner dougneiner
66
8.4k
For a Future-Friendly Web
Avatar for Brad Frost brad_frost
183
10k
HU Berlin: Industrial-Strength Natural Language Processing with spaCy and Prodigy
Avatar for Ines Montani inesmontani
PRO
0
320

Transcript

  1. Redshift introduction A distributed data ware house

  2. Agenda • What is the problem • How to solve

    it by Redshift • Compared to other technologies

  3. Data, more data

  4. Data, more data

  5. 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

  6. How to use data? • NoSQL • RDBMS • Hive

    • Redshift

  7. Data warehouse concepts • Dimensions and metrics

  8. Data warehouse concepts

  9. Redshift • An Amazon Redshift data warehouse is an enterprise-class

    relational database query and management system.

  10. Redshift Targets • Interactive • Volume • Variety • Security

  11. Architecture • Postgres console • Query process

  12. Architecture

  13. Storage(Reduce I/O) • Column • Compression • Block size •

    Sort key

  14. Computer(MPP) • Parallel unit: Slice • Distributed key • Join

    optimize

  15. Performance • https://amplab.cs.berkeley.edu/benchmark/

  16. Management • Scalable • Create/Clone Cluster

  17. Security • Backup: Snapshot • User auth • User quota:

    Workload management

  18. Compared to Hadoop Hive • Speed • Volume • Flexible

    • Operation

  19. Question?