Creating your MySQL Database: Practical Design Tips and Techniques

版权声明：原创作品，允许转载，转载时请务必以超链接形式标明文章原始出版、作者信息和本声明。否则将追究法律责任。 http://blog.csdn.net/topmvp - topmvp

The book covers: Asking users the right questions to collect relevant data for the system you are building Detecting bad structures Sound data-naming techniques, for both table and column names Modeling data with future growth in mind Implementing security policies with data privileges and views Tuning the structure for performance Producing system documentation (data dictionary, relational schema) Testing the model with appropriate SQL queries This book takes a practical approach, implementing all theoretical concepts with examples.

It is a fast-paced tutorial that focuses on critical decisions that you need to make every time you build MySQL databases. It is rich with tips and advice from an experienced practitioner. The book is ideal for anyone working with applications that use a MySQL database backend will benefit greatly from the advice and techniques in this book. Although a working knowledge of both SQL and MySQL is assumed, the book is suitable for both beginners and intermediate users alike. Whether you read it through and absorb the advice or work through it on a live project, the efficiency and maintainability of your databases will certainly improve as a result. Chapter 1: Introduction Chapter 2: Data Collection Chapter 3: Data Naming Chapter 4: Data Grouping Chapter 5: Data Structure Tuning Chapter 6: Case Study: An Airline System

http://file2upload.com/file/5984/b-375b01.zip.html
http://rapidshare.com/files/11068982/b-375b01.zip