PacktLib: Creating your MySQL Database: Practical Design Tips and Techniques

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

Summary

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

Summary

Data Grouping

Initial List of Tables

Rules for Table Layout

Improving the Structure

Validating the Structure

Summary

Data Structure Tuning

Data Access Policies

Storage Engines

Performance

In-Column Data Encoding

Case Study's Final Structure

Summary

Supplemental Case Study

Results from the Document Gathering Phase

Preliminary List of Data Elements

Tables and Sample Values

Airline System Data Schema

Sample Queries

Summary