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


Anders Karlsson

Principal Sales Engineer

Shane Johnson

Senior Director of Product Marketing