JSON_TABLE - The Best of Both Worlds

Monday 5:30PM

@ Demo Theater in the Exhibit Hall


Lightning Talk



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.


Øystein Grøvlen

Øystein Grøvlen (Oracle)

Senior Principal Software Engineer


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

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