| Description |
1 online resource (xxiii, 415 pages) : illustrations |
| Series |
Morgan Kaufmann series in data management systems |
|
Morgan Kaufmann series in data management systems.
|
| Note |
Includes index. |
| Contents |
Basic principles -- Tuning the guts -- Index tuning -- Tuning relational systems -- Communicating with the outside -- Case studies from Wall Street -- Troubleshooting -- Tuning e-commerce applications -- Celko on data warehouses : techniques, successes, and mistakes -- Data warehouse tuning. |
| Summary |
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. |
| Bibliography |
Includes bibliographical references and index. |
| Language |
English. |
| Subject |
Database management.
|
|
Bases de données -- Gestion. |
|
Bases de données. |
|
SGBD = Systèmes de gestion de bases de données. |
|
Database management |
| Added Author |
Bonnet, Philippe, 1970-
|
| Other Form: |
Print version: Shasha, Dennis Elliott. Database tuning. [Rev. ed.]. San Francisco, Calif. : Morgan Kaufmann Publishers, ©2003 1558607536 (DLC) 2001099791 (OCoLC)50050619 |
| ISBN |
0585448248 (electronic bk.) |
|
9780585448244 (electronic bk.) |
|
9781558607538 |
|
1558607536 |
|
1281035319 |
|
9781281035318 |
|
9786611035310 |
|
6611035311 |
|
0080503780 |
|
9780080503783 |
| Standard No. |
(WaSeSS)ssj0000135106 |
|
More Resources