Aug 5, 2017 · Databases

Mastering Database Schema: From Normalization to Sharding and Scaling

This comprehensive guide explores essential database design principles—including normalization, denormalization, data partitioning, routing, and scaling techniques—offering practical strategies to optimize schema structures, reduce redundancy, and improve performance for both relational and NoSQL systems.

Database designDenormalizationSchema Optimization

0 likes · 27 min read

Mastering Database Schema: From Normalization to Sharding and Scaling

ITPUB

Apr 20, 2016 · Databases

How to Shrink a 130GB Logistics JSON Column in MySQL

This article examines a MySQL table storing large JSON logistics data, analyzes why its size grows to 130 GB, and presents practical optimizations such as data archiving, JSON field reduction, and schema redesign to keep the table manageable.

JSONLogisticsSchema Optimization

0 likes · 8 min read

How to Shrink a 130GB Logistics JSON Column in MySQL