Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

Redshift Introduction

Avatar for elprup elprup
March 27, 2014
Technology
110
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
90

Other Decks in Technology

See All in Technology
AIに書かせて、プラットフォームで縛る ― EKSプラットフォームで実践した責任境界と権限設計
Avatar for elmo elmodev09
1
1.1k
サーバーフルコンピューティング？AWS Lambda
Avatar for TomoyaIwata iwatatomoya
0
120
AI Native Platform Engineering 〜PlatformとAgileで“作る速さ”を“価値”へ〜
Avatar for Yuya Mizorogi uya116
0
590
AgentCoreで実践するハーネスエンジニアリング
Avatar for やくも yakumo
0
160
AI駆動開発で仕様はどこまで書くべきか？ ― 人とAIの責務境界から考える開発プロセスの実践
Avatar for matsui-dmm takahiromatsui
1
280
Incremental HTTP
Avatar for kazuho kazuho
5
1.9k
2026-09-26 Platform Engineering Kaigi 2026 インフラとアプリの境界線と委譲の設計 / Drawing the Infra and App Line
Avatar for SUZUKI Masashi masasuzu
0
550
全社共通データ基盤をつくる。ソニーのDatabricks活用とデータガバナンス設計の裏側
Avatar for ソニー株式会社 sony
0
290
オブザーバビリティを高める AI エージェント体験を考える / Designing AI Agent Experiences That Enhance Observability
Avatar for Kento Kimura aoto
PRO
1
150
1人アドミンな私は AWSアカウント申請をSlackで完結したい！
Avatar for Yosuke Suzuki ysuzuki
0
110
Mastering Agentic Development: Harness Engineering for Effective Coding Agents
Avatar for Kyosuke Konishi konippi
3
670
データ品質を壊しながらSnowflakeのAIに分析させてみた
Avatar for かわなご kawanago
0
360

Featured

See All Featured
16th Malabo Montpellier Forum Presentation
Avatar for AKADEMIYA2063 akademiya2063
PRO
0
390
How to build an LLM SEO readiness audit: a practical framework
Avatar for Nick Samuel nmsamuel
2
930
ラッコキーワード サービス紹介資料
Avatar for ラッコ株式会社 rakko
1
5.1M
Lightning talk: Run Django tests with GitHub Actions
Avatar for Sarah Abderemane sabderemane
0
270
AI: The stuff that nobody shows you
Avatar for John Nunemaker jnunemaker
PRO
10
1.1k
Design of three-dimensional binary manipulators for pick-and-place task avoiding obstacles (IECON2024)
Avatar for konakalab konakalab
0
610
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
Avatar for Marc Duiker marcduiker
35
2.6k
How to Grow Your eCommerce with AI & Automation
Avatar for Katarina Dahlin katarinadahlin
PRO
2
290
Producing Creativity
Avatar for Steve Smith orderedlist
PRO
348
41k
The Web Performance Landscape in 2024 [PerfNow 2024]
Avatar for Tammy Everts tammyeverts
12
1.3k
Introduction to Domain-Driven Design and Collaborative software design
Avatar for Kenny Baas-Schwegler baasie
1
1k
HU Berlin: Industrial-Strength Natural Language Processing with spaCy and Prodigy
Avatar for Ines Montani inesmontani
PRO
0
730

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?