Øystein Grøvlen

Øystein Grøvlen

Ø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. He has been talking about the MySQL Optimizer at several conferences over the years. Dr. Grøvlen has a PhD in Computer Science from the Norwegian University of Science and Technology. Before joining the MySQL team 10 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 development of Clustra, a highly available DBMS. Øystein lives in Trondheim, Norway.


All Sessions

JSON_TABLE - The Best of Both Worlds

One of the most popular new features of MySQL 5.7 was JSON support. Now you can use SQL to search, extract information from, and change JSON documents. MySQL 8.0 takes this a step further. Using the JSON_TABLE function, you will be able to construct relational tables based on the contents of JSON documents. This way, you will be able to use the power of SQL to process JSON. For example, you can use SQL aggregate functions on your JSON data, or use the WHERE clause to find interesting objects within a JSON array.

This lightning talk will give a short introduction into how JSON_TABLE provides the missing link when processing JSON documents in MySQL.

Running JavaScript Stored-Programs Inside MySQL Server

We open a new chapter for MySQL stored-programs by enabling execution of JavaScript inside MySQL Server. The JavaScript stored-programs have all the benefits of the existing MySQL stored-programs such as reduced network traffic and enhanced security. But now, we can leverage existing JavaScript libraries to implement complex programs and run them efficiently, close to the persisted data.

In this talk, we present the integration between the GraalVM JavaScript runtime and MySQL Server. During the presentation, we demo how to define and execute JavaScript stored-programs, how to seamlessly deploy existing JavaScript code from a source repository to the database, and how to debug JavaScript code running in MySQL Server. Finally, we show how the execution of JavaScript programs in MySQL Server outperforms client-side execution.

Connect with Percona

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