Redshift & Final Project Monday, March 20, 2017 Agenda - - PowerPoint PPT Presentation

redshift final project
SMART_READER_LITE
LIVE PREVIEW

Redshift & Final Project Monday, March 20, 2017 Agenda - - PowerPoint PPT Presentation

Redshift & Final Project Monday, March 20, 2017 Agenda Announcements Redshift Primer Final Project Specs Final Project Setup Session Announcements Midterm exam grades No reading quiz today Next class:


slide-1
SLIDE 1

Redshift & Final Project

Monday, March 20, 2017

slide-2
SLIDE 2

Agenda

  • Announcements
  • Redshift Primer
  • Final Project Specs
  • Final Project Setup Session
slide-3
SLIDE 3

Announcements

  • Midterm exam grades
  • No reading quiz today
  • Next class: guest lecture
slide-4
SLIDE 4

Redshift Primer

  • Amazon’s data warehouse database
  • Derived from Postgres
  • Does not support B-tree indexes
  • Uses parallel processing
  • Uses data compression (~3x)
  • Uses columnar storage
  • Distribution styles (Even, Key, All)
  • Sort styles (Single, Compound, Interleaved)
  • COPY, ANALYZE, VACUUM commands
  • Workload Management (WLM)
  • Denormalization (materializing views not supported)

Source: Redshift Developer Guide

slide-5
SLIDE 5

What happened to referential integrity?

slide-6
SLIDE 6

Demo 1: Launching a Redshift Cluster

slide-7
SLIDE 7

Final Project Specs

http://www.cs.utexas.edu/~scohen/assignments/final-project.pdf

slide-8
SLIDE 8

Demo 2: Connecting to Redshift