Storage and Indexed access of denormalized columns (arrays) on MySQL 8.0, via multi-valued indexes – Saverio Miroddi – 64K RAM SYSTEM 38911 BASIC BYTES FREE
Another “missing and missed” functionality in MySQL is a data type for arrays.
While MySQL is not there yet, it’s now possible to cover a significant use case: storing denormalized columns (or arrays in general), and accessing them via index.
In this article I’ll give some context about denormalized data and indexes, including the workaround for such functionality on MySQL 5.7, and describe how this is (rather) cleanly accomplished on MySQL 8.0.
Terminology
Storing and indexing arrays in MySQL 5.7: an approach, and problems
The MySQL 8.0 implementation: data type and index
Performance expectations
Storage and Indexed access of denormalized columns (arrays) on MySQL 8.0, via multi-valued indexes – Saverio Miroddi – 64K RAM SYSTEM 38911 BASIC BYTES FREE
Another “missing and missed” functionality in MySQL is a data type for arrays.
While MySQL is not there yet, it’s now possible to cover a significant use case: storing denormalized columns (or arrays in general), and accessing them via index.
In this article I’ll give some context about denormalized data and indexes, including the workaround for such functionality on MySQL 5.7, and describe how this is (rather) cleanly accomplished on MySQL 8.0.
Terminology Storing and indexing arrays in MySQL 5.7: an approach, and problems The MySQL 8.0 implementation: data type and index Performance expectations
H
https://saveriomiroddi.github.io/Storage-and-indexed-access-of-denormalized-columns-arrays-on-mysql-8.0-via-multi-valued-indexes/