Explore how de-normalizing data with JSON can significantly improve query performance in this PHP UK 2019 conference talk. Dive into the world of database optimization as David Stokes demonstrates how using JSON columns can reduce expensive joins and minimize index dives. Learn to challenge traditional database design principles by incorporating hybrid SQL/NoSQL approaches, potentially revolutionizing your data architecture. Discover techniques for refactoring stagnant or infrequently updated data into schemaless JSON documents, leading to enhanced query performance and improved code readability. Follow along as Stokes illustrates these concepts using a fictional guitar business, covering topics such as JSON data types, mutable JSON, production data considerations, and the implementation of new JSON APIs. Gain insights into the benefits and challenges of hybrid databases, and understand how this approach can provide flexibility for future data structure changes.
How De-normalizing Your Data with JSON Can Boost Query Performance
Overview
Syllabus
Introduction
History Lesson
The Problem
The Solution
Tape Drives
Single Key
Edgar Codd
Structured Query Language
Better Performance
Normalizing Data
Cost Model
Package Your Data
No SQL
SQL Vendors
JSON Data Type
Creating a Springless Fantasy Business
Guitars
Custom Guitars
Classic Guitars
Getting Started
Serial Number
Electric Guitar
Wiring Options
Variable Options
Finite Element Analysis
ManytoMany Join
JSON Data Types
JSON mutable
Production data
Schema list JSON
Architecture
New Shell
New API
Search Conditions
New JSON API
New JSON API with Tables
JSON Table
SQL Operator
JSON Bulk Loader
Hybrid Databases
NonHybrid Databases
Data Structure Changes
Buy my book
Questions
Taught by
PHP UK Conference
