Personal tools
You are here: Home Events LFCS Seminars-Folder LFCS Seminars LFCS seminar: Torsten Grust: Processing Data in its Own Habitat

LFCS seminar: Torsten Grust: Processing Data in its Own Habitat

— filed under: ,

What
  • LFCS Seminar
  • Upcoming events
When Apr 11, 2019
from 11:00 AM to 12:00 PM
Where IF 4.31/4.33
Add event to calendar vCal
iCal

Data residing in relational databases is widely considered to be "in jail." This leads to the infamous SQL reflex SELECT * FROM T to extract and get hold of the data so that "real computation" can be performed using your general-purpose programming language of choice. This approach bears at least three problems:
  1. It goes against the wisdom of Turing Award winners,
  2. it moves potentially huge data sets instead of performing computation close to the data, and
  3. it disregards the abilities of modern SQL dialects which can concisely and efficiently express complex computation.
We shine a light on a few SQL constructs that rarely take the center stage—window functions and recursion, in particular—to formulate solutions to problems that typically are considered to lie outside the database query realm.  We also show how complex SQL queries can be authored much like functional programs (although the evaluation strategies for both differ significantly).
Document Actions