عنوان
پدید آورنده
موضوع
رده
کتابخانه
محل استقرار
INTERNATIONAL STANDARD BOOK NUMBER
(Number (ISBN
9781430207290
(Number (ISBN
9781590593325
NATIONAL BIBLIOGRAPHY NUMBER
Number
b405181
TITLE AND STATEMENT OF RESPONSIBILITY
Title Proper
Beginning MySQL Database Design and Optimization
General Material Designation
[Book]
Other Title Information
From Novice to Professional /
First Statement of Responsibility
by Jon Stephens, Chad Russell.
.PUBLICATION, DISTRIBUTION, ETC
Place of Publication, Distribution, etc.
Berkeley, CA :
Name of Publisher, Distributor, etc.
Imprint: Apress,
Date of Publication, Distribution, etc.
2004.
CONTENTS NOTE
Text of Note
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.
0
SUMMARY OR ABSTRACT
Text of Note
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.
OTHER EDITION IN ANOTHER MEDIUM
International Standard Book Number
9781590593325
PIECE
Title
Springer eBooks
TOPICAL NAME USED AS SUBJECT
Computer science.
Software engineering.
PERSONAL NAME - PRIMARY RESPONSIBILITY
Stephens, Jon.
PERSONAL NAME - ALTERNATIVE RESPONSIBILITY
Russell, Chad.
CORPORATE BODY NAME - ALTERNATIVE RESPONSIBILITY
SpringerLink (Online service)
ORIGINATING SOURCE
Date of Transaction
20190423143244.0
ELECTRONIC LOCATION AND ACCESS
Electronic name
مطالعه متن کتاب [Book]
Y
