How De-normalizing Your Data with JSON Can Boost Query Performance - David Stokes - PHP UK 2019

This talk explores the benefits of using JSON columns to optimize database performance by minimizing expensive joins. The speaker discusses strategies for loading data from smaller 'stub' tables into main tables to streamline access to simple information such as addresses and phone numbers within schemaless JSON documents. While third normal form has its advantages, the speaker highlights how adopting a hybrid SQL/NoSQL approach can enhance query performance and improve code readability, especially for many-to-many relationships with stagnant or infrequently updated data. This session aims to reshape perspectives on data architecture and promote greater mutability for future changes.