Главная
Study mode:
on
1
Introduction
2
History Lesson
3
The Problem
4
The Solution
5
Tape Drives
6
Single Key
7
Edgar Codd
8
Structured Query Language
9
Better Performance
10
Normalizing Data
11
Cost Model
12
Package Your Data
13
No SQL
14
SQL Vendors
15
JSON Data Type
16
Creating a Springless Fantasy Business
17
Guitars
18
Custom Guitars
19
Classic Guitars
20
Getting Started
21
Serial Number
22
Electric Guitar
23
Wiring Options
24
Variable Options
25
Finite Element Analysis
26
ManytoMany Join
27
JSON Data Types
28
JSON mutable
29
Production data
30
Schema list JSON
31
Architecture
32
New Shell
33
New API
34
Search Conditions
35
New JSON API
36
New JSON API with Tables
37
JSON Table
38
SQL Operator
39
JSON Bulk Loader
40
Hybrid Databases
41
NonHybrid Databases
42
Data Structure Changes
43
Buy my book
44
Questions
Description:
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

PHP UK Conference
Add to list