Database Performance Tuning Handbook, with CD-ROM (Data Warehousing/Data Management) [CD-ROM]

Jeff Dunham (Author)

Book Description

Publication Date: December 10, 1997 | Series: The McGraw-Hill series on databases & data management

This comprehensive reference contains everything one needs to know about database technology, from Informix to Web databases. It should be of interest to database administrators, technical support analysts, system programmers and database designers.

Editorial Reviews

From the Back Cover

Improve performance on every major database using one all-inclusive volume. Database administrators, programmers, system programmers, and technical specialists are responsible for optimizing database usage to improve system performance, but recent changes in the database marketplace and the advent of Open Data Base Connectivity have forced them to learn and manage more than one database product. Fortunately, Jeffrey Allan DunhamÕs Database Performance Tuning Handbook covers all major database products and performance issues in one comprehensive volume. Consolidating performance-improving tactics from manufacturers, user groups, published works, and training courses, this essential reference contains tips for optimizing all major database products including: Oracle v7.3 & 8.0; Sybase v11; Microsoft SQL Server v6.5; DB2 v4.X; CA-IDMS release 14. Other sections cover tuning tips for client/server systems and database networking over TCP/IP and SNA. Also featured are discussions of database planning and design, mainframe blocking, buffering, coding and caching, PC files and buffers, and advanced data management techniques. This comprehensive resource even includes tips for Windows NT 4.0, Windows 95, and minor database managers like CA-Clipper, dBASE, BTRIEVE, and the FoxPro family. With over 300 illustrations and valuable appendices, this book is a one-stop source for every database professional.

About the Author

Jeff Dunham has over 25 years experience as a computer professional specializing in database tuning and performance. He currently works at Allen Systems Group, which makes CA-IDMS and DB2 database tools.

Product Details

• CD-ROM: 778 pages
• Publisher: Mcgraw-Hill (Tx); Bk&CD-Rom edition (December 10, 1997)
• Language: English
• ISBN-10: 0070182442
• ISBN-13: 978-0070182448
• Product Dimensions: 9.3 x 7.5 x 2.4 inches
• Shipping Weight: 4 pounds
• Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
• Amazon Best Sellers Rank: #5,591,652 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

4 of 5 people found the following review helpful:

5.0 out of 5 stars Covers complete tuning of Oracle, Sybase, MS Sql, DB2, IDMS, October 9, 1997

By A Customer

This review is from: Database Performance Tuning Handbook, with CD-ROM (Data Warehousing/Data Management) (CD-ROM)

Chapter1: Statistics Collection (and monitors)
Chapter2: Mainframe Blocking and Buffering
Chapter3: PC Files and Buffers
Chapter4: DB2 System Tuning
Chapter5: Logical Database Design
Chapter6: Microsoft SQL 6.5 Tuning
Chapter7: Oracle 7.3 & 8.0 Tuning
Chapter8: Windows NT 4.0 Tuning
Chapter9: Windows 95 Tuning
Chapter10: PC & Client/Server Program Coding
Chapter11: Sybase 11 Tuning
Chapter12: Mainframe Coding
Chapter13: Mainframe Sorts
Chapter14: CA-IDMS 12 & 14 Tuning
Chapter15: Mainframe Multi-Level Caching
Chapter16: PC & Client/Server Caching
Chapter17: Communications and Networking
Chapter18: Advanced Topics

The advanced chapter is really hot. It covers new technology and techniques which are right on the edge. It completely covers major databases like Oracle Sybase and MS SQL, more so, than other tuning books out. aware of.