Creating your MySQL Database: Practical Design Tips and Techniques
Credits
About the Author
About the Reviewer
Preface
What This Book Covers
What You Need for This Book
Conventions
Reader Feedback
Customer Support
Introducing MySQL Design
MySQL's Popularity and Impact
Data as a Resource
Data Modeling
Case Study
The Tale of the Too Wide Table
Summary
Data Collecting
System Boundaries Identification
Document Gathering
Interviews
Data Collected for our Case Study
Data Naming
Data Cleaning
Subdividing Data Elements
Data that are Results
Data as a Column's or Table's Name
Planning for Changes
Naming Recommendations
Data Grouping
Initial List of Tables
Rules for Table Layout
Improving the Structure
Validating the Structure
Data Structure Tuning
Data Access Policies
Storage Engines
Performance
In-Column Data Encoding
Case Study's Final Structure
Supplemental Case Study
Results from the Document Gathering Phase
Preliminary List of Data Elements
Tables and Sample Values
Airline System Data Schema
Sample Queries