Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Window functions in MariaDB

Window functions in MariaDB

 20 April 02:00 PM - 02:50 PM @ Room 210
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Analytics
Topics:
MySQL
Tools and Techniques
Programming

Description

Window functions are a new feature in MariaDB 10.2 This talk gives it a comprehensive coverage. We'll start with a description of what window functions are, and what are their possible use cases. Then, we will describe how MariaDB computes window functions.We will compare MariaDB's algorithm to algorithms in other databases, and discuss its possible performance. Finally, we will present a benchmark results comparing the performance of using window functions with computing the same values using other SQL constructs, both in MariaDB and other databases.

Speakers

Vicentiu-Marian Ciorbaru's picture

Vicentiu-Marian Ciorbaru

Software Engineer, MariaDB Foundation

Biography:

Started working for MariaDB as a Google Summer of Code student in 2013, implementing SQL Standard Roles. Later, converted to a full time employee as part of the MariaDB Foundation. Currently developing Window Functions for MariaDB. Also handling problems related to the Query Optimizer, Packaging and Replication.

Sergei Petrunia's picture

Sergei Petrunia

Query Optimizer Developer, MariaDB Corporation

Biography:

Sergei Petrunia is a query optimizer developer at MariaDB Corporation Ab. He implemented MariaDB's optimizer features like Table Elimination (MariaDB 5.1), improvements to semi-join subquery optimizations (MariaDB 5.3/5.5), SHOW EXPLAIN (MariaDB 10.0), and ANALYZE for statements (MariaDB 10.1) Prior to Monty Program, he has worked for MySQL Ab/Sun Microsystems, where he was the author of query optimizer features like Partition Pruning, Index Merge (MySQL 5.1), and numerous smaller improvements in query optimizer and other parts of the server. He maintains a highly technical blog at http://s.petrunia.net/blog

Share this talk


Slides