Lukas Eder
Lukas Eder Twitter

From Data Geekery GmbH

Lukas, master of all things SQL

Blog: http://www.jooq.org

bigdata (Big) Data

How Modern SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of

Conference

SQL is the only ever successful, mainstream, and general-purpose 4GL (Fourth Generation Programming Language) and it is awesome!

With modern cost based optimisation, relational databases like Oracle, SQL Server, PostgreSQL finally keep up to the promise of a powerful declarative programming model by adapting to ever changing productive data without performance penalties. Thousand-line-long, complex SQL statements can be run in far below a millisecond against billion-row strong tables if database developers know their ways around the SQL language - and the best news is: It's not that hard!

In this talk, I'll show how the SQL database will constantly outperform any hand written data retrieval algorithm - or in other words - how SQL, being a logic language, is the best language for business logic.