Window Functions for MySQL 8.0: Boost Your Analytical Queries

Wednesday 2:20PM-3:10PM

@ Swift Suite 1

MySQL / MariaDB

50 minutes conference

Intermediate

Tracks:
Developer

This presentation will highlight the new support for SQL window functions in MySQL 8.0: showing how they can be used to simplify and speed up analytical queries. The talk will first give a gentle introduction to basic concepts like partitions, frames and peers, explaining the differences between physical and logical frames. Then we move on to the two kinds of window functions and show their usage: SQL aggregates like COUNT and SUM used as window functions, as well as the dedicated window functions like ROW_NUMBER, NTILE, LEAD and more.

We will also cover some implementation aspects, particularly as they pertain to performance.

MySQL offers all the standard non-aggregate window functions, as well as most of the existing MySQL aggregate functions used as window functions. Window functions have the potential to greatly speed up many kinds of queries, and should be in the repertoire of all SQL developers.


Speakers

Dag Wanvik

Dag Wanvik (Oracle)

Senior database engineer

Biography:

Dag is a M.Sc. from NTNU, Trondheim, Norway in Computer Science, 1980. After 20 yeas an a compiler writer, he has been doing relational databases since 2000, at Sun and now Oracle, first on Clustra (a DB similar to MySQL Cluster), on Derby a.k.a Java DB, and currently on MySQL. Dag's last work was co-authoring a JSON datatype and functions for MySQL.


Slides



  Download Slides  

Percona Live

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA