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

Redshift Introduction

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
Avatar for elprup elprup
March 27, 2014
Technology
0
97

Redshift Introduction

Brief intro for amazon redshift service

Avatar for elprup

elprup

March 27, 2014
Tweet

More Decks by elprup

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

Other Decks in Technology

See All in Technology
名刺メーカーDevグループ 紹介資料
Avatar for Sansan, Inc. sansan33
PRO
0
1k
入社1ヶ月でデータパイプライン講座を作った話
Avatar for Yuta Ozaki waiwai2111
1
250
Agile Leadership Summit Keynote 2026
Avatar for seki at druby.org m_seki
1
530
今日から始める Amazon Bedrock AgentCore
Avatar for Har1101 har1101
4
400
茨城の思い出を振り返る ～CDKのセキュリティを添えて～ / 20260201 Mitsutoshi Matsuo
Avatar for SHIFT EVOLVE shift_evolve
PRO
1
200
20260204_Midosuji_Tech
Avatar for Takuya Yonezawa takuyay0ne
1
130
Data Hubグループ 紹介資料
Avatar for Sansan, Inc. sansan33
PRO
0
2.7k
生成AIを活用した音声文字起こしシステムの2つの構築パターンについて
Avatar for Kazuki Miura miu_crescent
PRO
1
130
マーケットプレイス版Oracle WebCenter Content For OCI
Avatar for oracle4engineer oracle4engineer
PRO
5
1.5k
なぜ今、コスト最適化（倹約）が必要なのか？ ～AWSでのコスト最適化の進め方「目的編」～
Avatar for Hayato Tan htan
1
110
Embedded SREの終わりを設計する　「なんとなく」から計画的な自立支援へ
Avatar for SansanTech sansantech
PRO
3
2.2k
こんなところでも（地味に）活躍するImage Modeさんを知ってるかい？- Image Mode for OpenShift -
Avatar for Masataka Tsukamoto tsukaman
0
110

Featured

See All Featured
ラッコキーワード サービス紹介資料
Avatar for ラッコ株式会社 rakko
1
2.2M
Being A Developer After 40
Avatar for Adrian Kosmaczewski akosma
91
590k
jQuery: Nuts, Bolts and Bling
Avatar for Doug Neiner dougneiner
65
8.4k
Done Done
Avatar for chrislema chrislema
186
16k
Docker and Python
Avatar for Tania Allard trallard
47
3.7k
How to audit for AI Accessibility on your Front & Back End
Avatar for davetheseo davetheseo
0
180
svc-hook: hooking system calls on ARM64 by binary rewriting
Avatar for Akira Moroo retrage
1
98
The untapped power of vector embeddings
Avatar for Frank van Dijk frankvandijk
1
1.6k
Bioeconomy Workshop: Dr. Julius Ecuru, Opportunities for a Bioeconomy in West Africa
Avatar for AKADEMIYA2063 akademiya2063
PRO
1
54
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
Avatar for Michelle Schulp Hunt marktimemedia
31
2.7k
The browser strikes back
Avatar for Jono Alderson jonoalderson
0
360
Digital Projects Gone Horribly Wrong (And the UX Pros Who Still Save the Day) - Dean Schuster
Avatar for UX Y'all uxyall
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?