We improved our data structure's implementation by assessing the responsible person for each data element and by storing this information into column comments. We then saw how to use privileges and views to improve security, how to choose the best storage engine per table, and how to benefit from foreign key constraints. Performance issues were considered, and then we were presented with the final model for the car dealer's case study.
Creating your MySQL Database: Practical Design Tips and Techniques
By :
Creating your MySQL Database: Practical Design Tips and Techniques
By:
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.
Table of Contents (12 chapters)
Creating your MySQL Database: Practical Design Tips and Techniques
Credits
About the Author
About the Reviewer
Preface
Free Chapter
Introducing MySQL Design
Data Collecting
Data Naming
Data Grouping
Data Structure Tuning
Supplemental Case Study
Index
Customer Reviews