Window functions in MariaDB
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.
Software Engineer, MariaDB Foundation
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.
Query Optimizer Developer, MariaDB Corporation
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