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

Discover the power of SQL as a fourth-generation programming language in this 51-minute conference talk by Lukas Eder at Devoxx. Explore how modern cost-based optimization in relational databases like Oracle, SQL Server, and PostgreSQL fulfills the promise of a robust declarative programming model. Learn how these databases adapt to changing data without sacrificing performance, enabling complex SQL statements to run in sub-millisecond times against billion-row tables. Gain insights into how SQL outperforms hand-written data retrieval algorithms and why it excels as a language for business logic. Uncover the potential of SQL's logical approach and discover techniques to harness its power for efficient database development.

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