Database Tuning: Principles, Experiments, and Troubleshooting Techniques (The Morgan Kaufmann Series in Data Management Systems) - Brossura

Shasha, Dennis

Brossura

ISBN 10: 1558607536 ISBN 13: 9781558607538

Casa editrice: Morgan Kaufmann, 2002

Riassunto

Tuning your database for optimal performance means more than following a few short steps in a vendor-specific guide. For maximum improvement, you need a broad and deep knowledge of basic tuning principles, the ability to gather data in a systematic way, and the skill to make your system run faster. This is an art as well as a science, and Database Tuning: Principles, Experiments, and Troubleshooting Techniques will help you develop portable skills that will allow you to tune a wide variety of database systems on a multitude of hardware and operating systems. Further, these skills, combined with the scripts provided for validating results, are exactly what you need to evaluate competing database products and to choose the right one. * Forward by Jim Gray, with invited chapters by Joe Celko and Alberto Lerner* Includes industrial contributions by Bill McKenna (RedBrick/Informix), Hany Saleeb (Oracle), Tim Shetler (TimesTen), Judy Smith (Deutsche Bank), and Ron Yorita (IBM) * Covers the entire system environment: hardware, operating system, transactions, indexes, queries, table design, and application analysis* Contains experiments (scripts available on the author's site) to help you verify a system's effectiveness in your own environment* Presents special topics, including data warehousing, Web support, main memory databases, specialized databases, and financial time series* Describes performance-monitoring techniques that will help you recognize and troubleshoot problems

Su questo libro

Dalla quarta di copertina

"For the novice, this book gives sage advice on the performance issues of SQL-level logical database design that cuts across all systems. For me at least, the physical database design was particularly interesting, because the book presents the implications of design choices on IBM, Oracle, and Microsoft systems. These systems are quite different internally, and the book's example will surprise even the systems' implementers."

--Jim Gray, Microsoft

"Shasha and Bonnet prove the value of applying timeless principles to everchanging technology. The unique wealth of practical ideas, facts, and examples equip database practitioners "in the trenches" like no other resource. Chapter 2 alone is worth the price of the book."

--Bob Badour, Online Curmudgeon

Tuning your database for optimal performance means more than following a few short steps in a vendor-specific guide. For maximum improvement, you need a broad and deep knowledge of basic tuning principles, the ability to gather data in a systematic way, and the skill to make your system run faster. This is an art as well as a science, and Database Tuning: Principles, Experiments, and Troubleshooting Techniques will help you develop portable skills that will allow you to tune a wide variety of database systems on a multitude of hardware and operating systems. Further, these skills, combined with the scripts provided for validating results, are exactly what you need to evaluate competing database products and to choose the right one.

Features

• Forward by Jim Gray, with invited chapters by Joe Celko and Alberto Lerner
  
• Includes industrial contributions by Bill McKenna (RedBrick/Informix), Hany Saleeb (Oracle), Tim Shetler (TimesTen), Judy Smith (Deutsche Bank), and Ron Yorita (IBM)
  
• Covers the entire system environment: hardware, operating system, transactions, indexes, queries, table design, and application analysis
  
• Contains experiments (scripts available on the author's site) to help you verify a system's effectiveness in your own environment
  
• Presents special topics, including data warehousing, Web support, main memory databases, specialized databases, and financial time series
  
• Describes performance-monitoring techniques that will help you recognize and troubleshoot problems

|

"For the novice, this book gives sage advice on the performance issues of SQL-level logical database design that cuts across all systems. For me at least, the physical database design was particularly interesting, because the book presents the implications of design choices on IBM, Oracle, and Microsoft systems. These systems are quite different internally, and the book's example will surprise even the systems' implementers."

--Jim Gray, Microsoft

"Shasha and Bonnet prove the value of applying timeless principles to everchanging technology. The unique wealth of practical ideas, facts, and examples equip database practitioners "in the trenches" like no other resource. Chapter 2 alone is worth the price of the book."

--Bob Badour, Online Curmudgeon

Tuning your database for optimal performance means more than following a few short steps in a vendor-specific guide. For maximum improvement, you need a broad and deep knowledge of basic tuning principles, the ability to gather data in a systematic way, and the skill to make your system run faster. This is an art as well as a science, andDatabase Tuning: Principles, Experiments, and Troubleshooting Techniques will help you develop portable skills that will allow you to tune a wide variety of database systems on a multitude of hardware and operating systems. Further, these skills, combined with the scripts provided for validating results, are exactly what you need to evaluate competing database products and to choose the right one.

Features

• Forward by Jim Gray, with invited chapters by Joe Celko and Alberto Lerner
  
• Includes industrial contributions by Bill McKenna (RedBrick/Informix), Hany Saleeb (Oracle), Tim Shetler (TimesTen), Judy Smith (Deutsche Bank), and Ron Yorita (IBM)
  
• Covers the entire system environment: hardware, operating system, transactions, indexes, queries, table design, and application analysis
  
• Contains experiments (scripts available on the author's site) to help you verify a system's effectiveness in your own environment
  
• Presents special topics, including data warehousing, Web support, main memory databases, specialized databases, and financial time series
  
• Describes performance-monitoring techniques that will help you recognize and troubleshoot problems

Dettagli dell?edizione

• Editore: Morgan Kaufmann
• Data di pubblicazione: 2002
• Lingua: Inglese
• ISBN 10: 1558607536
• ISBN 13: 9781558607538
• Rilegatura: Copertina flessibile
• Numero di pagine: 440
• Contatto del produttore: non disponibile
• Persona responsabile: non disponibile