Database Tuning: Principles, Experiments, and Troubleshooting Techniques

Přední strana obálky
Elsevier, 7. 6. 2002 - Počet stran: 440
1 Recenze


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
 

Co říkají ostatní - Napsat recenzi

Na obvyklých místech jsme nenalezli žádné recenze.

Vybrané stránky

Obsah

CHAPTER 2 TUNING THE GUTS
9
CHAPTER 3 INDEX TUNING
77
CHAPTER 4 TUNING RELATIONAL SYSTEMS
123
CHAPTER 5 COMMUNICATING WITH THE OUTSIDE
165
CHAPTER 6 CASE STUDIES FROM WALL STREET
185
CHAPTER 7 TROUBLESHOOTING
213
CHAPTER 8 TUNING ECOMMERCE APPLICATIONS
243
TECHNIQUES SUCCESSES AND MISTAKES
261
APPENDIX A REALTIME DATABASES
301
APPENDIX B TRANSACTION CHOPPING
305
APPENDIX C TIME SERIES ESPECIALLY FOR FINANCE
325
APPENDIX D UNDERSTANDING ACCESS PLANS
337
APPENDIX E CONFIGURATION PARAMETERS
349
Glossary
361
Index
387
Author Biographies
416

CHAPTER 10 DATA WAREHOUSE TUNING
275
Autorská práva

Další vydání - Zobrazit všechny

Database Tuning: Principles, Experiments, and Troubleshooting Techniques
Dennis Elliott Shasha,Philippe Bonnet
Náhled není k dispozici. - 2003

Běžně se vyskytující výrazy a sousloví

aggregate algorithm application server attributes B-tree B+ tree balance bitmap cache Chapter chopping client clustering index commit composite index computed concurrency control configuration data item data mining data structure data warehouse database buffer database disks database management system database server database system DB2 UDB DBMS delete denormalization dept disk accesses e-commerce Employee example execution FIGURE foreign key functional dependency graph hardware hash structure insert interface join lineitem load materialized views monitoring multipoint queries nodes nonclustering index normalized ODBC operating system optimizer Oracle 8i overhead parameters partitioning performance point queries pointers problem processing processor query plan RAID random access memory records recovery relation require result rollback rows salary SC-cycle schema SELECT serializability snapshot isolation SQL Server ssnum statistics storage strategy subqueries subsystem Techdept throughput tool TPC-H trigger tuning tuples updates

Oblíbené pasáže

Strana ii - Management of Heterogeneous and Autonomous Database Systems Edited by Ahmed Elmagarmid, Marek Rusinkiewicz, and Amit Sheth Object-Relational DBMSs: Tracking the Next Great Wave, Second Edition Michael Stonebraker and Paul Brown with Dorothy Moore A Complete Guide...
Objevuje se u 37 knih od 1995-2006.
Strana ii - Understanding Relational Language Components Jim Melton and Alan R. Simon Information Visualization in Data Mining and Knowledge Discovery Edited by Usama Fayyad, Georges G. Grinstein, and Andreas Wierse Transactional Information Systems: Theory, Algorithms, and Practice of Concurrency Control and Recovery Gerhard Weikum and Gottfried Vossen Spatial Databases: With Application to CIS Philippe Rigaux, Michel Scholl, and Agnes Voisard Information Modeling and Relational Databases: From Conceptual Analysis...
Objevuje se u 23 knih od 1987-2006.
Strana ii - JDBC, and Related Technologies Jim Melton and Andrew Eisenberg Database: Principles, Programming, and Performance, Second Edition Patrick and Elizabeth O'Neil The Object Data Standard: ODMG 3.0 Edited by RGG Cattell and Douglas K. Barry Data on the Web: From Relations to Semistructured Data and XML Serge Abiteboul, Peter Buneman, and Dan Suciu Data Mining: Practical Machine Learning Tools and Techniques with Java Implementations Ian H.
Objevuje se u 36 knih od 1995-2006.
Strana ii - The Morgan Kaufmann Series in Data Management Systems Series Editor: Jim Gray, Microsoft Research...
Objevuje se u 52 knih od 1989-2006.
Strana iii - Models for Advanced Applications, Edited by Ahmed K. Elmagarmid A Guide to Developing Client/Server SQL Applications, Setrag Khoshafian, Arvola Chan, Anna Wong, and Harry KT Wong The Benchmark Handbook for Database and Transaction Processing Systems, Second Edition, Edited by Jim Gray Camelot and Avalon: A Distributed Transaction Facility, Edited by Jeffrey L. Eppinger, Lily B. Mummert, and Alfred Z. Spector Readings in Object-Oriented Database Systems, Edited by Stanley B. Zdonik and David Maier...
Objevuje se u 64 knih od 1990-2006.
Strana 44 - Disk organization. >TECHNICAL DIGRESSION: BACKGROUND COMMENT ON DISKS A disk is a collection of circular platters placed one on top of the other and rotating around a common axis (called a spindle). Each platter, except the top and bottom platters, has two read/write surfaces. (The top surface of the top platter and the bottom surface of the bottom platter are unused.) The data on each surface is held on tracks, each of which is a circle. Each platter is associated with a disk head. To access the...
Objevuje se u 4 knih od 1971-2003.

O autorovi (2002)

Dennis Shasha is the author or coauthor of seven books, including this book's predecessor Database Tuning: A principal Approach (Prentice Hall) and Out of Their Minds: The Lives and Discoveries of 15 Great Computer Scientists (Copernius/Springer-Verlag), numerous journal and conference papers, and four patents. He also writes monthly puzzle columns for Scientific American and Dr. Dobb's Journal.

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

Bibliografické údaje

QR code for Database Tuning
TitulDatabase Tuning: Principles, Experiments, and Troubleshooting Techniques
The Morgan Kaufmann Series in Data Management Systems
AutořiDennis Shasha, Philippe Bonnet
VydavatelElsevier, 2002
ISBN0080503780, 9780080503783
DélkaPočet stran: 440
  
Exportovat citaciBiBTeX EndNote RefMan