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

About the Author

Marc Delisle is a member of the MySQL Developers Guild, which regroups community developers—because of his involvement with phpMyAdmin. He started to contribute to this popular MySQL web interface in December 1998, when he made the first multi-language version. He has been actively involved with the phpMyAdmin project since May 2001 as a developer and project administrator.

He has worked since 1980 at Collège de Sherbrooke, Québec, Canada, as an application programmer and network manager. He has also been teaching networking, security, Linux servers, and PHP/MySQL application development.

I would like to thank the whole Packt team for their support, especially Louay Fatoohi and Nikhil Bangera; their advice helped shaping this book. My thanks also go to Rudy Limeback for his insight.

The developers of the MySQL software have earned my respect; may they find here my warm gratitude for their excellent product.

I hope that this book will assist readers into building effective data structures.

To Carole, André, Corinne, Annie, and Guillaume, with all my love.

Previous Section
Next Chapter