How Modern SQL Databases Come up with Algorithms that You Wouldn’t Dream Of
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.
Speaker: Lukas Eder
Lukas Eder is the founder and CEO of Data Geekery GmbH. He is a Java Champion, located in Zurich, Switzerland. Data Geekery has been selling database products and services around Java and SQL since 2013.
Ever since his Master’s studies at EPFL in 2006, he has been fascinated by the interaction of Java and SQL. He credits his work in the Swiss E-Banking field through various variants (JDBC, Hibernate, mostly with Oracle) for his experience. He is happy to share this knowledge at various conferences, JUGs, in-house presentations and on his blog.