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

Voxxed Days Ticino 2018
on Saturday 20 October

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

Conference

Big Data & Machine Learning
Big Data & Machine Learning
Intermediate level
Room B1 Saturday from 13:30 til 14:20

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.

SQL   Java   persistence  
Lukas Eder
Lukas Eder
From Data Geekery GmbH

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