Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Øystein Grøvlen


Øystein Grøvlen's picture

Øystein Grøvlen

Senior Principal Software Engineer, Oracle


Biography:

Øystein Grøvlen is a Senior Principal Software Engineer in the MySQL group at Oracle, where he works on the MySQL Query Optimizer. Dr. Grøvlen has a PhD in Computer Science from the Norwegian University of Science and Technology. Before joining the MySQL team 9 years ago, he was a contributor on the Apache Derby project and Sun's Architectural Lead on Java DB. Prior to that, he worked for 10 years on the development of Clustra, a highly available DBMS. Øystein lives in Trondheim, Norway.


Sessions

24 April - 9:30 AM - 12:30 PM at Ballroom E
Performance of SQL queries plays a big role in application performance. If some queries execute slowly, these queries or the database schema may need tuning. This tutorial covers query processing, optimization methods, and how the MySQL optimizer chooses a specific plan to execute SQL. It demonstrates how to use tools such as EXPLAIN (including Structured and Visual EXPLAIN), Optimizer Trace,... [read more]
25 April - 2:20 PM - 3:10 PM at Ballroom G
Two new SQL features in MySQL 8.0 are presented in this session; Common Table Expressions (CTE) and Window Functions.In their simplest form, CTEs are a way of creating a view/temporary table for usage in a single query. However, they have many more use cases. In particular, when using the RECURSIVE form of CTEs, it is possible to perform advanced tasks with few lines of code. This session will... [read more]