skip to content
Database tuning : principles, experiments, and troubleshooting techniques Preview this item
ClosePreview this item
Checking...

Database tuning : principles, experiments, and troubleshooting techniques

Author: Dennis Elliott Shasha; Philippe Bonnet
Publisher: San Francisco, Calif. : Morgan Kaufmann Publishers, ©2003.
Series: Morgan Kaufmann series in data management systems.
Edition/Format:   eBook : Document : English : [Rev. ed.]View all editions and formats
Database:WorldCat
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  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Shasha, Dennis Elliott.
Database tuning.
San Francisco, Calif. : Morgan Kaufmann Publishers, ©2003
(DLC) 2001099791
(OCoLC)50050619
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Dennis Elliott Shasha; Philippe Bonnet
ISBN: 0585448248 9780585448244 9781558607538 1558607536
OCLC Number: 52365957
Notes: Includes index.
Description: 1 online resource (xxiii, 415 pages) : illustrations.
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.
Series Title: Morgan Kaufmann series in data management systems.
Responsibility: Dennis Shasha, Philippe Bonnet.
More information:

Abstract:

Helps you develop portable skills that allow you to tune a variety of database systems on a multitude of hardware and operating systems. This work covers the entire system environment: hardware,  Read more...

Reviews

Editorial reviews

Publisher Synopsis

"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 Read more...

 
User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/52365957> # Database tuning : principles, experiments, and troubleshooting techniques
    a schema:Book, schema:CreativeWork, schema:MediaObject ;
    library:oclcnum "52365957" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/cau> ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/800392605#Place/san_francisco_calif> ; # San Francisco, Calif.
    schema:about <http://experiment.worldcat.org/entity/work/data/800392605#Topic/database_management> ; # Database management
    schema:about <http://experiment.worldcat.org/entity/work/data/800392605#Topic/computers_database_management_general> ; # COMPUTERS--Database Management--General
    schema:about <http://experiment.worldcat.org/entity/work/data/800392605#Topic/sgbd_systemes_de_gestion_de_bases_de_donnees> ; # SGBD = Systèmes de gestion de bases de données
    schema:about <http://experiment.worldcat.org/entity/work/data/800392605#Topic/computers_desktop_applications_databases> ; # COMPUTERS--Desktop Applications--Databases
    schema:about <http://dewey.info/class/005.74/e21/> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/800392605#Topic/bases_de_donnees> ; # Bases de données
    schema:about <http://experiment.worldcat.org/entity/work/data/800392605#Topic/computers_system_administration_storage_&_retrieval> ; # COMPUTERS--System Administration--Storage & Retrieval
    schema:bookEdition "[Rev. ed.]." ;
    schema:bookFormat schema:EBook ;
    schema:contributor <http://viaf.org/viaf/203907234> ; # Philippe Bonnet
    schema:copyrightYear "2003" ;
    schema:creator <http://viaf.org/viaf/85573081> ; # Dennis Elliott Shasha
    schema:datePublished "2003" ;
    schema:description "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."@en ;
    schema:description "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."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/800392605> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isPartOf <http://experiment.worldcat.org/entity/work/data/800392605#Series/morgan_kaufmann_series_in_data_management_systems> ; # Morgan Kaufmann series in data management systems.
    schema:isSimilarTo <http://www.worldcat.org/oclc/50050619> ;
    schema:name "Database tuning : principles, experiments, and troubleshooting techniques"@en ;
    schema:productID "52365957" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/52365957#PublicationEvent/san_francisco_calif_morgan_kaufmann_publishers_2003> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/800392605#Agent/morgan_kaufmann_publishers> ; # Morgan Kaufmann Publishers
    schema:url <http://catdir.loc.gov/catdir/toc/els031/2001099791.html> ;
    schema:url <http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=81854> ;
    schema:url <http://site.ebrary.com/id/10190884> ;
    schema:url <http://www.sciencedirect.com/science/book/9781558607538> ;
    schema:url <http://www.books24x7.com/marc.asp?isbn=1558607536> ;
    schema:url <http://www.engineeringvillage.com/controller/servlet/OpenURL?genre=book&isbn=9781558607538> ;
    schema:workExample <http://worldcat.org/isbn/9780585448244> ;
    schema:workExample <http://worldcat.org/isbn/9781558607538> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/52365957> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/800392605#Agent/morgan_kaufmann_publishers> # Morgan Kaufmann Publishers
    a bgn:Agent ;
    schema:name "Morgan Kaufmann Publishers" ;
    .

<http://experiment.worldcat.org/entity/work/data/800392605#Place/san_francisco_calif> # San Francisco, Calif.
    a schema:Place ;
    schema:name "San Francisco, Calif." ;
    .

<http://experiment.worldcat.org/entity/work/data/800392605#Series/morgan_kaufmann_series_in_data_management_systems> # Morgan Kaufmann series in data management systems.
    a bgn:PublicationSeries ;
    schema:hasPart <http://www.worldcat.org/oclc/52365957> ; # Database tuning : principles, experiments, and troubleshooting techniques
    schema:name "Morgan Kaufmann series in data management systems." ;
    schema:name "Morgan Kaufmann series in data management systems" ;
    .

<http://experiment.worldcat.org/entity/work/data/800392605#Topic/bases_de_donnees> # Bases de données
    a schema:Intangible ;
    schema:name "Bases de données"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/800392605#Topic/computers_database_management_general> # COMPUTERS--Database Management--General
    a schema:Intangible ;
    schema:name "COMPUTERS--Database Management--General"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/800392605#Topic/computers_desktop_applications_databases> # COMPUTERS--Desktop Applications--Databases
    a schema:Intangible ;
    schema:name "COMPUTERS--Desktop Applications--Databases"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/800392605#Topic/computers_system_administration_storage_&_retrieval> # COMPUTERS--System Administration--Storage & Retrieval
    a schema:Intangible ;
    schema:name "COMPUTERS--System Administration--Storage & Retrieval"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/800392605#Topic/database_management> # Database management
    a schema:Intangible ;
    schema:name "Database management"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/800392605#Topic/sgbd_systemes_de_gestion_de_bases_de_donnees> # SGBD = Systèmes de gestion de bases de données
    a schema:Intangible ;
    schema:name "SGBD = Systèmes de gestion de bases de données"@en ;
    .

<http://viaf.org/viaf/203907234> # Philippe Bonnet
    a schema:Person ;
    schema:birthDate "1970" ;
    schema:familyName "Bonnet" ;
    schema:givenName "Philippe" ;
    schema:name "Philippe Bonnet" ;
    .

<http://viaf.org/viaf/85573081> # Dennis Elliott Shasha
    a schema:Person ;
    schema:familyName "Shasha" ;
    schema:givenName "Dennis Elliott" ;
    schema:name "Dennis Elliott Shasha" ;
    .

<http://worldcat.org/isbn/9780585448244>
    a schema:ProductModel ;
    schema:isbn "0585448248" ;
    schema:isbn "9780585448244" ;
    .

<http://worldcat.org/isbn/9781558607538>
    a schema:ProductModel ;
    schema:isbn "1558607536" ;
    schema:isbn "9781558607538" ;
    .

<http://www.engineeringvillage.com/controller/servlet/OpenURL?genre=book&isbn=9781558607538>
    rdfs:comment "An electronic book accessible through the World Wide Web; click for information" ;
    .

<http://www.worldcat.org/oclc/50050619>
    a schema:CreativeWork ;
    rdfs:label "Database tuning." ;
    schema:description "Print version:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/52365957> ; # Database tuning : principles, experiments, and troubleshooting techniques
    .

<http://www.worldcat.org/title/-/oclc/52365957>
    a genont:InformationResource, genont:ContentTypeGenericResource ;
    schema:about <http://www.worldcat.org/oclc/52365957> ; # Database tuning : principles, experiments, and troubleshooting techniques
    schema:dateModified "2017-09-18" ;
    void:inDataset <http://purl.oclc.org/dataset/WorldCat> ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.