Mariadb

Flexible data modeling with JSON functions and dynamic columns

There are times when storing related / similar data in a lot of tables or rows (normalized) or in a lot of columns (denormalized) is neither practical nor preferable – times when a little schema flexibility goes a long way, and is most welcome.

MariaDB Server 10.2 introduces a comprehensive set of SQL functions for validating, indexing and querying JSON documents in addition to existing functions for reading and writing dynamic columns – columns created in a row, but not defined in the table.

In this webinar, we will explain and demonstrate how to create flexible schemas using both structured (i.e., relational) and semi-structured data (e.g., JSON) – the best of both worlds.

You will learn:

The pros and cons of using semi-structured data
The capabilities and limitations of JSON / dynamic column functions
How to validate JSON documents and maintain data integrity
Where and when to use JSON documents or dynamic columns

Webinar Registration

Webinar Time:

First Name:

Last Name:

Job Title:

Company Name:

Business Email:

Business Phone:

Country:

State:

Postal Code:

How long have you used MariaDB in production?

* May we use your contact details to update you on offers, products, and services? You may unsubscribe anytime.

* I have read and I agree to the MariaDB Privacy Policy.

JSON and Semi-Structured Data with MariaDB Server

Flexible data modeling with JSON functions and dynamic columns

SPEAKERS

Anders Karlsson

Shane Johnson