LFCS Seminar: 11 April 2019 - Torsten Grust

Title: Processing Data in its Own Habitat

Abstract:

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).
Apr 11 2019 -

LFCS Seminar: 11 April 2019 - Torsten Grust

Speaker: Torsten Grust

IF 4.31/4.33