Book Image

Creating your MySQL Database: Practical Design Tips and Techniques

By : Marc Delisle
Book Image

Creating your MySQL Database: Practical Design Tips and Techniques

By: Marc Delisle

Overview of this book

For most of us, setting up the database for an application is often an afterthought. While you don't need to be a professional database designer to create a working application, knowing a few insider tips and techniques can make both the process easier and the end result much more effective. This book doesn't set out to make you an expert in data analysis, but it does provide a quick and easy way to raise your game in this essential part of getting your application right.

Related Content you might be interested in

Current Title:

Small book image
Creating your MySQL Database: Practical Design Tips and Techniques
Marc Delisle
Nov, 2006 | 0 hours 0 minutes
No titles found
Table of Contents (12 chapters)
Creating your MySQL Database: Practical Design Tips and Techniques
Creating your MySQL Database: Practical Design Tips and Techniques
Credits
Credits
About the Author
About the Author
About the Reviewer
About the Reviewer
Preface
Preface
Free Chapter
1
Introducing MySQL Design
Introducing MySQL Design
MySQL's Popularity and Impact
Data as a Resource
Data Modeling
Case Study
The Tale of the Too Wide Table
Summary
2
Data Collecting
Data Collecting
System Boundaries Identification
Document Gathering
Interviews
Data Collected for our Case Study
Summary
3
Data Naming
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
4
Data Grouping
Data Grouping
Initial List of Tables
Rules for Table Layout
Improving the Structure
Validating the Structure
Summary
5
Data Structure Tuning
Data Structure Tuning
Data Access Policies
Storage Engines
Performance
In-Column Data Encoding
Case Study's Final Structure
Summary
6
Supplemental Case Study
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
Index
Index

Chapter 6. Supplemental Case Study

Now, it's time to apply our newly learned principles to a completely different theme. We upgrade from cars to planes, covering a simple airline system.

This chapter's case study does not pretend to encompass the full collection of data from real airline—it's only a sample. Nonetheless, we'll see that the principles we learned previously can be applied to build and refine a correct and coherent data structure.

Normally, each airline has its own information system. We assume here that we have got the mandate to build an information system that encompasses many airlines.

Previous Section
End of Section 1
Next Section