|
 |
|
 |
 |
Beginning MySQL Database Design and Optimization: From Novice to Professional
|
by Chad Russell and Jon Stephens
Sales Rank: 102731
|
Discount: 40 %
$16.52
At Amazon
|
|
Paperback: 520 pages
Publisher: Apress; 1 edition October 18, 2004
Language: English
ISBN-10: 1590593324
ISBN-13: 978-1590593325
Product Dimensions:
9 x 7 x 1.2 inches
Shipping Weight: 1.8 pounds
Book Description
Nearly every non-trivial application requires data persistence, and for an application of any significant size and scope, persistence is typically realized using a database. For open source and many other projects, the MySQL database is a very popular choice: its free; its fast, robust, and scalable; and it runs on all of the major platforms, allowing maximal use of available hardware resources. However, its easy to throw away MySQLs speed and other advantages if your database design is inefficient. Needlessly duplicating data, using improper types for columns, overloading a single table where multiple tables should be used, failing to leverage the calculation features of MySQL, and making multiple queries instead of efficient, single query are some of the common mistakes.
MySQL Database Design and Optimization, shows you how to identify, overcome, and avoid gross inefficiencies, and demonstrates how to maximize the many data manipulation features that MySQL has built-in. MySQL Database Design and Optimization explains how to include tests and branching in your queries, how to normalize your database, and how to issue concurrent queries to boost performance, among many other design and optimization topics. If youre building or maintaining any significant application and are using MySQL, this book is for you.
About The Author
Chad Russell is a programmer and network administrator who owns his own Internet hosting company. He previously has written on MySQL, PHP, and other topics. Jon Stephens is a programmer and database analyst based out of Australia. He has written about MySQL, PHP, and other topics, and he has co-authored PHP 5 Recipes: A Problem-Solution Approach. Stephens recently joined MySQL AB as a member of the Documentation Team.
Customer Reviews & Comments
I was hoping that there would be more about designing databases. Though I was pleasantly surprised at the solid introduction to MySQL that the book gives. In fact it spends the first two thirds of the book on the basics, before getting into optimization and finally programming. The design aspect of the book is in the third chapter, which is one of the books best. There is some good high level material on the fundamentals of schema design, and then material on relation mapping, and then into it's implementation in MySQL. There is a lot to like in this book. And I like the fact that someone is finally giving some attention to MySQL, which, if it's not the most advanced database in the world, is probably the most ubiquitous. This is a fine book for anyone who works with MySQL.
Comment | Permalink |
(Report this)
|
Beginning MySQL Database Design and Optimization: From Novice to Professional
Discount: 40 %
Available from Amazon
Price: $16.52
| |
|
|
|
|
