Database Tuning

Principles, Experiments, and Troubleshooting Techniques

Dennis Shasha, Philippe Bonnet

416 pages, parution le 12/03/2003

Ajouter à une liste

Indisponible

Résumé

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 this 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

Contents

Preface
Chapter 1: Basic Principles
Chapter 2: Tuning The Guts
Chapter 3: Index Tuning
Chapter 4: Tuning Relational Systems
Chapter 5: Communicating With The Outside
Chapter 6: Case Studies From Wall Street
Chapter 7: Troubleshooting by Alberto Lerner
Chapter 8: Tuning E-Commerce Applications
Chapter 9: Celko On Data Warehouses: Techniques, Successes, and Mistakes by Joe Celko
Chapter 10: Data Warehouse Tuning
Appendix A: Real-Time Databases
Appendix B: Transaction Chopping
Appendix C: Time Series, Especially For Finance
Appendix D: Understanding Access Plans
Appendix E: Configuration Parameters
Glossary
Index

L'auteur - Dennis Shasha

Dennis Shasha est professeur d'informatique au Courant Institute of Mathematical Science de la New York University. Il a publié Jeux d'esprit et énigmes mathématiques, tome I (Les Aventures extraordinaires du Dr Ecco)et tome II (Codes, mystères et complots).

Autres livres de Dennis Shasha

Jeux d'esprit et énigmes mathématiques - Volume 1

Jeux d'esprit et énigmes mathématiques - Volume 4

Les cyberénigmes du Dr Ecco

Découvrir tous les livres de Dennis Shasha

L'auteur - Philippe Bonnet

Philippe Bonnet is an experiment database researcher. He directs code development of the open source object-relational database system Predator developed at Cornell.

Autres livres de Philippe Bonnet

Noirs tatouages

Découvrir tous les livres de Philippe Bonnet

Caractéristiques techniques

	PAPIER
Éditeur(s)	Morgan Kaufmann
Auteur(s)	Dennis Shasha, Philippe Bonnet
Parution	12/03/2003
Nb. de pages	416
Format	18,5 x 23,5
Couverture	Relié
Poids	895g
Intérieur	Noir et Blanc
EAN13	9781558607538
ISBN13	978-1-55860-753-8