Optimizing Informix Applications is a comprehensive guide to improving the performance of database applications built on the Informix-SE, Informix-OnLine, and Informix-OnLine DSA engines. This book is an essential resource for developers and database administrators seeking to improve productivity and system quality. Among the topics covered are: Planning strategies that lead to more efficient databases; setting up an optimization test environment; indexing approaches that offer significantly improved performance; making the best use of the Informix optimizer; refining your SQL statements for more efficient execution; developing and maintaining efficient application code; tuning the Informix database engines; and taking advantage of data fragmentation and parallel processing. Optimizing Informix Applications contains numerous examples, including source code, database layouts, and hardware configurations. A chapter of case studies illustrates the optimization challenges Informix developers encounter most often, and the best solutions. If you design, develop, or administer Informix applications, this book brings together a world of information for making them faster, more reliable, and more cost-effective.

Optimizing Informix Applications (INFORMIX SERIES)

Schneider, Robert D.

Computers & Technology

PRENTICE/HALL

Programmers, analysts, and database and systems administrators will discover the strategies that lead to a successful index, including structure, columns, keys, data types, and clustering; how to minimize network traffic with joins, batches, searches, and tables; the secrets of disk management and replication to optimize the database engine's design; the essentials of a successful testing environment; and planning strategies for an effective roll-out. The disk contains SQL Replay, a performance monitor designed specifically for Microsoft SQL. Annotation c. by Book News, Inc., Portland, Or.

Microsoft SQL Server: Planning and Building a High Performance Database

Programming

Prentice Hall PTR

If you’re in charge of database administration, developing database software, or looking for database solutions for your company, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies can help you get a handle on this extremely popular relational database management system. Here you’ll find what’s new in the latest version; how to choose and install the right variation for your needs; how to monitor, maintain, and protect your data; and what it takes to keep your database healthy. You’ll discover how to: 
<ul>
<li>Build and maintain tables</li> <li>Design a database and communicate with it</li> <li>Retrieve, analyze, and report data</li> <li>Build solid, robust database applications</li> <li>Use the SQL Server Optimizer and Query Designer</li> <li>Navigate SQL Server with Visual Studio</li> <li>Develop useful reports with the Report Builder and Report Designer</li> <li>Create Business Intelligence solutions with Business Intelligence Development Studio</li> <li>Configure your server and perform major administrative tasks</li> </ul>
To help you quickly find what you need, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies is divided into nine minibooks: <ul>
<li>Essential Concepts</li> <li>Designing and Using Databases</li> <li>Interacting With Your Data</li> <li>Database Programming</li> <li>Reporting Services</li> <li>Analysis Services</li> <li>Performance Tips and Tricks</li> <li>Database Administration</li> <li>Appendixes</li> </ul>
Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies gets you started, helps you solve problems, and will even answer your questions down the road!

Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies

GIBSON, DARRIL

For Dummies

The authoritative, hands-on guide to advanced MySQL programming and administration techniques for high performance is here. MySQL Database Design and Tuning is the only guide with coverage of both the basics and advanced topics, including reliability, performance, optimization and tuning for MySQL. This clear, concise and unique source for the most reliable MySQL performance information will show you how to: <ul>
<li>Deploy the right MySQL product for your performance needs. </li>
<li>Set up a performance management and monitoring environment using tools from MySQL. </li>
<li>Implement the right indexing strategy </li>
<li>Apply good performance strategy when developing software to work with the MySQL database. </li>
<li>Configure dozens of variable to correctly tune the MySQL engine. </li> </ul>
If you deal with the intricacies and challenges of advanced MySQL functionality on a daily basis, you will be able to build on your knowledge with author Robert Schneider's real-world experiences in MySQL Database Design and Tuning.

MySQL Database Design and Tuning

Programming Languages

MySQL Press

See the best price to sell, buy, or rent books by Schneider, Robert D.. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Schneider, Robert D.

See the best price to sell, buy, or rent books by Schneider, Robert D.. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Optimizing Informix Applications (INFORMIX SERIES)

Microsoft SQL Server: Planning and Building a High Performance Database

Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies

MySQL Database Design and Tuning