طراحی و بهینه‌سازی پایگاه داده MySQL برای مبتدیان: از مبتدی تا حرفه‌ای؛ [به حداکثر رساندن عملکرد پایگاه داده MySQL با تسلط بر طراحی جدول، پرس‌وجو و بهترین شیوه‌های API]

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 you’re 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: it’s free, fast, robust, and scalable, and it runs on all of the major platforms, allowing maximum use of available hardware resources. But it’s easy to disregard MySQL’s 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. You’ll 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 realized using a database. For open source and many other projects, the MySQL database is a very popular choice: it's free; it's fast, robust, and scalable; and it runs on all of the major platforms, allowing maximal use of available hardware resources. However, it's easy to throw away MySQL's 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 you're building or maintaining any significant application and are using MySQL, this book is for you * Shows how to take advantage of MySQL's built-in functions, minimizing the need to process data once it's been retrieved from the database. * Demonstrates how to write and use advanced and complex queries to cut down on (middleware) application logic, including nested sub-queries and virtual tables (added since MySQL 4.1). * Points out database design do's and don'ts, including many real-world examples of bad database designs and how the databases were subsequently improved. * Includes a review of MySQL fundamentals and essential theory, such as naming conventions and connections, for quick reference purposes.

with The Help Of This Book, You'll Learn How To Identify, Overcome, And Avoid Gross Inefficiencies In Mysql. Further, You Will See How To Maximize Built-in Data Manipulation Features. And You'll Discover The Benefits Of Incorporating Tests And Branches Within Your Queries.

You Will Also Learn About Normalizing Your Database, And Issuing Simultaneous Queries To Boost Performance-along With Numerous Other Design And Optimization Topics. So If You're Building Or Maintaining Any Significant Application With Mysql, Then This Book Is Your One-stop For Training And Preparing!

Front Matter....Pages N2-xx Review of MySQL Basics....Pages 1-44 MySQL Column and Table Types....Pages 45-112 Keys, Indexes, and Normalization....Pages 113-170 Optimizing Queries with Operators, Branching, and Functions....Pages 171-238 Joins, Temporary Tables, and Transactions....Pages 239-271 Finding the Bottlenecks....Pages 273-314 MySQL Programming....Pages 315-416 Looking Ahead....Pages 417-487 Back Matter....Pages 489-500 A guide to database design and optimazation covers such topics as database types, structuring tables, management of transactions, using Perl, and PHP.