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