Chapter 6. Dynamic Columns
In this chapter, we will examine the problem of storing non-homogeneous data in the same table. The first part will discuss the approaches traditionally used in relational databases. The following part will examine a MariaDB feature which solves the problem in a totally different way: dynamic columns.
We will discuss the following topics in this chapter:
- The problem of storing non-homogeneous data
- Dynamic columns functions
- Nested dynamic columns
- Indexing dynamic columns