Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Common Table Expressions & Window Functions

Common Table Expressions & Window Functions

 25 April - 2:20 PM - 3:10 PM @ Ballroom G
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Developer
Topics:
MySQL
Optimization
Programming

Description

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 present several examples on how you can benefit from using CTEs.A window function performs a calculation across a set of table rows that are somehow related to the current row. Such functions can be used in many ways to analyze your data. We will give an introduction and quick overview of the feature set and examples of interesting use cases.

Speakers

Ø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.

Share this talk