Beginning MySQL Database Design and Optimization
From Novice to Professional
Seiten
2004
|
Softcover reprint of the original 1st ed.
Apress (Verlag)
978-1-59059-332-5 (ISBN)
Apress (Verlag)
978-1-59059-332-5 (ISBN)
'MySQL Database Design and Optimisation' shows how to identify, overcome, and avoid gross inefficiencies, and demonstrates how to maximize the many data manipulation features that MySQL has built-in. It explains how to include tests and branching in queries, how to normalize the database, and much more.
Nearly every non-trivial application requires data persistence, and for an application of any significant size and scope, persistence is typically achieved using a database. If youre building or maintaining any significant application and are using MySQL, this book is for you. For open source and other types of projects, the MySQL database is a very popular choice: its free, fast, robust, and scalable, and it runs on all of the major platforms, allowing maximum use of available hardware resources. But its easy to disregard 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 an efficient single query are some of the common mistakes.
Beginning MySQL Database Design and Optimization shows you how to identify, overcome, and avoid gross inefficiencies. It demonstrates how to maximize the many data manipulation features that MySQL includes. This book explains how to include tests and branches in your queries, how to normalize your database, and how to issue concurrent queries to boost performance, among many other design and optimization topics. Youll also learn about some features new to MySQL 4.1 and 5.0 like subqueries, stored procedures, and views, all of which will help you build even more efficient applications.
Nearly every non-trivial application requires data persistence, and for an application of any significant size and scope, persistence is typically achieved using a database. If youre building or maintaining any significant application and are using MySQL, this book is for you. For open source and other types of projects, the MySQL database is a very popular choice: its free, fast, robust, and scalable, and it runs on all of the major platforms, allowing maximum use of available hardware resources. But its easy to disregard 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 an efficient single query are some of the common mistakes.
Beginning MySQL Database Design and Optimization shows you how to identify, overcome, and avoid gross inefficiencies. It demonstrates how to maximize the many data manipulation features that MySQL includes. This book explains how to include tests and branches in your queries, how to normalize your database, and how to issue concurrent queries to boost performance, among many other design and optimization topics. Youll also learn about some features new to MySQL 4.1 and 5.0 like subqueries, stored procedures, and views, all of which will help you build even more efficient applications.
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.
1 Review of MySQL Basics.- 2 MySQL Column and Table Types.- 3 Keys, Indexes, and Normalization.- 4 Optimizing Queries with Operators, Branching, and Functions.- 5 Joins, Temporary Tables, and Transactions.- 6 Finding the Bottlenecks.- 7 MySQL Programming.- 8 Looking Ahead.
| Zusatzinfo | 281 Illustrations, black and white; XX, 520 p. 281 illus. |
|---|---|
| Verlagsort | Berkley |
| Sprache | englisch |
| Maße | 178 x 235 mm |
| Themenwelt | Informatik ► Datenbanken ► MySQL |
| Mathematik / Informatik ► Informatik ► Software Entwicklung | |
| Schlagworte | MySQL |
| ISBN-10 | 1-59059-332-4 / 1590593324 |
| ISBN-13 | 978-1-59059-332-5 / 9781590593325 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
Mehr entdecken
aus dem Bereich
aus dem Bereich
ideal für Programmiereinsteiger
Buch | Softcover (2023)
Rheinwerk (Verlag)
CHF 41,85
