Lukas Eder
From Data Geekery GmbH
Lukas Eder is the founder and CEO of Swiss company Data Geekery GmbH, which has been selling database products and services since 2013. His specialty is the interaction of Java and SQL. Most of this experience has been obtained via the Swiss E-Banking sector. He is best known in the Java community as the designer of the popular ‘jOOQ’ database access library and a frequent conference speaker on improving Java/DB integration, and a Java Champion.
Blog: http://blog.jooq.org
Big Data & Analytics
Ten SQL Tricks that You Didn’t Think Were Possible
SQL is the winning language of Big Data. Whether you’re running a classic relational database, a column store (“NewSQL”), or a non-relational storage system (“NoSQL”), a powerful, declarative, SQL-based query language makes the difference. The SQL standard has evolved drastically in the past decades, and so have its commercial and open source implementations. In this fast-paced talk, we’re going to look at very peculiar and interesting data problems and how we can solve them with SQL. We’ll explore common table expressions, hierarchical SQL, table-valued functions, lateral joins, row value expressions, window functions, and advanced data types, such as XML and JSON. And we’ll look at Oracle’s mysterious MODEL and MATCH_RECOGNIZE clauses, devices whose mystery is only exceeded by their power. Most importantly, however, we’re going to learn that everyone can write advanced SQL. Once you learn the basics in these tricks, you’re going to love SQL even more.
Java, JVM, Javas SE/EE
Get Back in Control of Your SQL with jOOQ
Java does not provide an API to directly support the expressiveness and power of SQL. All attention is given to object-relational mapping and abstractions on a higher level, such as OQL, HQL, JPQL, CriteriaQuery.
jOOQ is a dual-licensed Open Source product filling this gap. It implements SQL itself as a type safe domain-specific language in Java.
jOOQ is a good choice in a Java application where SQL and its proprietary features of the database in use are important. It shows, how a modern domain-specific language can greatly increase developer productivity, internalising SQL into Java.