Welcome to Percona Live Online 2021
Online Open Source Database Conference
Thursday, May 13 • 14:00 - 14:30
Validating JSON

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
JSON or JavaScript Object Notation has become the data interchange format of choice. Most relational databases have added a JSON data type (Oracle, Postgresql, MySQL) or some accommodation for JSON data (SQL Server, MariaDB). But the free form nature of JSON is problematic for relational databases resulting in compromises in speed, handling of key-value pairs, and general lack of the ability to validate data. RDMS have had the ability to check for missing values, data type checks, and range checks but that is lacking in the JSON sphere. However, JSON-Schema.org has developed a vocabulary to annotate and validate JSON documents to describe your data formats, documents your implementation, and provides a way to validate data to allow both automatic testing and assuring data quality.

The work of JSON-Schema.org is heading towards RFC status and could very well remove many of the objections to JSON data use in a relational system. We will look at whom in starting to use their methods and the progress in standardization.

avatar for Dave Stokes

Dave Stokes

MySQL Community Manager, Oracle
Dave Stokes is a MySQL Community Manager for Oracle Corporation and travels extensively to promote MySQL, speaking over thirty times each year for the past several years. He is also the author of MySQL & JSON - A Practical Programming Guide which is a guide for those wishing to take... Read More →

Thursday May 13, 2021 14:00 - 14:30 EDT
Room #7