UDN-7391 How Modern SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of | Voxxed Days

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

Conference

Big Data & Machine Learning

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.

Lukas Eder Lukas Eder

SQL is a device whose mystery is only exceeded by its power