SLIDE 1
Parallel Incep+on MPP Databases GPGPU Kyle Dunn Me Data - - PowerPoint PPT Presentation
Parallel Incep+on MPP Databases GPGPU Kyle Dunn Me Data - - PowerPoint PPT Presentation
Parallel Incep+on MPP Databases GPGPU Kyle Dunn Me Data nerd for Recovering HPC/GPGPU researcher Poll Adap+ve JIT Mature Cu?ng Edge SQL GPGPU Rigid SQL MemSQL pg_strom numba JIT GPGPU Edmund Cartwright (1784/5) Scale vs.
SLIDE 2
SLIDE 3
Poll
SLIDE 4
Cu?ng Edge Adap+ve
JIT GPGPU SQL
Rigid Mature
SLIDE 5
JIT GPGPU numba SQL pg_strom MemSQL
SLIDE 6
Scale vs. Capability
Edmund Cartwright (1784/5)
SLIDE 7
GPGPU
Code blueprint Magic Results
SLIDE 8
MPP
SELECT foo(columnA), bar(columnB) FROM someTable; SQL Query Magic Results
SLIDE 9
The incep+on
MPP Node
SLIDE 10
SLIDE 11
Ship it.
SLIDE 12
So what?
SLIDE 13
SLIDE 14
Shard 2 Shard 1 x1 SQL query xN - MPP Nodes xP - GPU Cores
SLIDE 15
Free lunch?
- 1. IO
– Depends on the restaurant…
- 2. SIMD
– And the entrée…
- 3. Concurrency
– Hoard your Pi[e]
SLIDE 16
Time series
“Find the related measurements in full flight data.”
SLIDE 17
CF34 GE90 GEnx
x1 SQL query xN - MPP Nodes xP - GPU Cores
SLIDE 18
Mul+media
“Find a set of plants with resemblance to this one.”
SLIDE 19
Gnetophyta Magnoliophyta Cycadophyta
x1 SQL query xN - MPP Nodes xP - GPU Cores
SLIDE 20
Geospa+al
“Find loca+ons with high historical solar insola+on.”
SLIDE 21
Florida Colorado California x1 SQL query xN - MPP Nodes xP - GPU Cores
SLIDE 22
tl;dr
- Turn-key >> nuts and bolts
- JIT your code
- SQL lives (seriously though)
SLIDE 23