~/lightning

Lightning Talk: Tensor Query Processing

Lightningat PyTorch Conference 2023 · 2023-10-16..10-17· [databases, machine-learning]
links:none on file
slides:none on file

Tensor Query Processor (TQP) maps SQL physical plans into PyTorch tensor programs, implements custom tensor operators for joins and group-by, and applies operator fusion plus code generation to target accelerators. It encodes columns (numbers, timestamps, padded UTF‑8 strings) as tensors, runs the full TPC-H SF50 in 33s, and reports about 4x faster than SQL Server on the tested CPU-to-GPU configuration while remaining portable to other hardware supported by the runtime.

AI-written summary · about

  1. 0:00Tensor query processing
  2. 1:49ML to SQL with Tensor Abstraction
  3. 3:35Tabular data as tensors
  4. 5:01SQL queries to PyTorch
  5. 7:09SQL on hardware accelerators
  6. 7:32TPC-H benchmarks
  7. 8:55Q&A
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.