Flexible Data Modeling with MariaDB Server: Part 1 – Dynamic Columns

Learn how to use dynamic columns for
semi-structured data

In part one, we explain step-by-step how to support semi-structured data with dynamic columns – columns created on demand, and for a single row – using a practical use case with sample data and queries for everything from creating, reading and querying dynamic columns to enforcing data integrity with check constraints and functions.

You will learn:

  • The benefits and limitations of using dynamic columns 
  • How to create dynamic columns on demand 
  • How to index and query dynamic columns 
  • How to enforce data integrity with dynamic columns 


Download part one to learn more about dynamic columns. Part two, which includes more information on using JSON functions introduced in MariaDB Server 10.2, is available for download.

Download the White Paper