skip to content
Relational database index design and the optimizers : DB2, Oracle, SQL server et al. Preview this item
ClosePreview this item
Checking...

Relational database index design and the optimizers : DB2, Oracle, SQL server et al.

Author: Tapio Lahdenmäki; Mike Leach; John Wiley & Sons.
Publisher: Hoboken, N.J. : John Wiley & Sons, ©2005.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Database:WorldCat
Summary:
Improve the performance of relational databases with indexes designed for today's hardwareOver the last few years, hardware and software have advanced beyond all recognition, so it's hardly surprising that relational database performance now receives much less attention.
Rating:

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

Subjects
More like this

 

Find a copy in the library

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

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Lahdenmäki, Tapio.
Relational database index design and the optimizers.
Hoboken, N.J. : John Wiley & Sons, ©2005
(DLC) 2004021914
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Tapio Lahdenmäki; Mike Leach; John Wiley & Sons.
ISBN: 0471719994 9780471719991 0471721379 9780471721376 0471721360 9780471721369
OCLC Number: 85820599
Reproduction Notes: Electronic reproduction. [S.l.] : HathiTrust Digital Library, 2010. MiAaHDL
Description: 1 online resource (xvii, 310 pages) : illustrations
Details: Master and use copy. Digital master created according to Benchmark for Faithful Digital Reproductions of Monographs and Serials, Version 1. Digital Library Federation, December 2002.
Contents: Table and index organization --
SQL processing --
Deriving the ideal index for a select --
Proactive index design --
Factors affecting the index design process --
Reactive index design --
Indexing for table joins --
Star join considerations --
Multiple index access --
Indexes and reorganization --
DBMS-specific indexing restrictions --
DBMS-specific indexing options --
Optimizers are not perfect --
Additional estimation considerations --
Organizing the index design process.
Responsibility: Tapio Lahdenmäki, Michael Leach.
More information:

Abstract:

This book covers index design, one aspect of database tuning. It will teach the reader how to improve the performance of relational databases (IBM DB2, Oracle, Microsoft SQL Server and others) with  Read more...

Reviews

Editorial reviews

Publisher Synopsis

"I recommend this book to all those who have anything to do with database performance. It is a must-read for all database administrations, database designers, performance-tuning specialists, and 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/85820599> # Relational database index design and the optimizers : DB2, Oracle, SQL server et al.
    a schema:CreativeWork, schema:Book, schema:MediaObject ;
    library:oclcnum "85820599" ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/802055420#Place/hoboken_n_j> ; # Hoboken, N.J.
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/nju> ;
    rdfs:comment "Warning: This malformed URI has been treated as a string - 'http://images.contentreserve.com/ImageType-100/0128-1/{137FE088-805C-43A1-9D79-CED72B9C62CB}Img100.jpg'" ;
    schema:about <http://experiment.worldcat.org/entity/work/data/802055420#Topic/indexeren> ; # Indexeren
    schema:about <http://experiment.worldcat.org/entity/work/data/802055420#Thing/computer_science> ; # Computer Science.
    schema:about <http://experiment.worldcat.org/entity/work/data/802055420#Topic/bases_de_donnees_relationnelles> ; # Bases de données relationnelles
    schema:about <http://experiment.worldcat.org/entity/work/data/802055420#Topic/computers_programming_languages_sql> ; # COMPUTERS--Programming Languages--SQL
    schema:about <http://dewey.info/class/005.7565/e22/> ;
    schema:about <http://id.worldcat.org/fast/1093575> ; # Relational databases
    schema:about <http://experiment.worldcat.org/entity/work/data/802055420#Topic/relationele_databanken> ; # Relationele databanken
    schema:bookFormat schema:EBook ;
    schema:contributor <http://experiment.worldcat.org/entity/work/data/802055420#Person/leach_mike_1942> ; # Mike Leach
    schema:contributor <http://experiment.worldcat.org/entity/work/data/802055420#Organization/john_wiley_&_sons> ; # John Wiley & Sons.
    schema:copyrightYear "2005" ;
    schema:creator <http://viaf.org/viaf/26451493> ; # Tapio Lahdenmäki
    schema:datePublished "2005" ;
    schema:description "Improve the performance of relational databases with indexes designed for today's hardwareOver the last few years, hardware and software have advanced beyond all recognition, so it's hardly surprising that relational database performance now receives much less attention."@en ;
    schema:description "Table and index organization -- SQL processing -- Deriving the ideal index for a select -- Proactive index design -- Factors affecting the index design process -- Reactive index design -- Indexing for table joins -- Star join considerations -- Multiple index access -- Indexes and reorganization -- DBMS-specific indexing restrictions -- DBMS-specific indexing options -- Optimizers are not perfect -- Additional estimation considerations -- Organizing the index design process."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/802055420> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isSimilarTo <http://worldcat.org/entity/work/data/802055420#CreativeWork/relational_database_index_design_and_the_optimizers> ;
    schema:name "Relational database index design and the optimizers : DB2, Oracle, SQL server et al."@en ;
    schema:productID "85820599" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/85820599#PublicationEvent/hoboken_n_j_john_wiley_&_sons_2005> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/802055420#Agent/john_wiley_&_sons> ; # John Wiley & Sons
    schema:url <http://catalog.hathitrust.org/api/volumes/oclc/56599360.html> ;
    schema:url <http://onlinelibrary.wiley.com/book/10.1002/0471721379> ;
    schema:url <http://dx.doi.org/10.1002/0471721379> ;
    schema:url <http://site.ebrary.com/id/10304550> ;
    schema:url <http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=140379> ;
    schema:url "http://images.contentreserve.com/ImageType-100/0128-1/{137FE088-805C-43A1-9D79-CED72B9C62CB}Img100.jpg" ;
    schema:url <http://books.google.com/books?id=kM9QAAAAMAAJ> ;
    schema:url <http://www.myilibrary.com?id=27661> ;
    schema:url <https://www.overdrive.com/search?q=137FE088-805C-43A1-9D79-CED72B9C62CB> ;
    schema:url <http://www3.interscience.wiley.com/cgi-bin/bookhome/109880569> ;
    schema:url <http://catdir.loc.gov/catdir/toc/ecip051/2004021914.html> ;
    schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=238765> ;
    schema:workExample <http://worldcat.org/isbn/9780471719991> ;
    schema:workExample <http://dx.doi.org/10.1002/0471721379> ;
    schema:workExample <http://worldcat.org/isbn/9780471721369> ;
    schema:workExample <http://worldcat.org/isbn/9780471721376> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/85820599> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/802055420#Agent/john_wiley_&_sons> # John Wiley & Sons
    a bgn:Agent ;
    schema:name "John Wiley & Sons" ;
    .

<http://experiment.worldcat.org/entity/work/data/802055420#Person/leach_mike_1942> # Mike Leach
    a schema:Person ;
    schema:birthDate "1942" ;
    schema:familyName "Leach" ;
    schema:givenName "Mike" ;
    schema:name "Mike Leach" ;
    .

<http://experiment.worldcat.org/entity/work/data/802055420#Place/hoboken_n_j> # Hoboken, N.J.
    a schema:Place ;
    schema:name "Hoboken, N.J." ;
    .

<http://experiment.worldcat.org/entity/work/data/802055420#Thing/computer_science> # Computer Science.
    a schema:Thing ;
    schema:name "Computer Science." ;
    .

<http://experiment.worldcat.org/entity/work/data/802055420#Topic/bases_de_donnees_relationnelles> # Bases de données relationnelles
    a schema:Intangible ;
    schema:name "Bases de données relationnelles"@fr ;
    .

<http://experiment.worldcat.org/entity/work/data/802055420#Topic/computers_programming_languages_sql> # COMPUTERS--Programming Languages--SQL
    a schema:Intangible ;
    schema:name "COMPUTERS--Programming Languages--SQL"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/802055420#Topic/relationele_databanken> # Relationele databanken
    a schema:Intangible ;
    schema:name "Relationele databanken"@en ;
    .

<http://id.worldcat.org/fast/1093575> # Relational databases
    a schema:Intangible ;
    schema:name "Relational databases"@en ;
    .

<http://viaf.org/viaf/26451493> # Tapio Lahdenmäki
    a schema:Person ;
    schema:familyName "Lahdenmäki" ;
    schema:givenName "Tapio" ;
    schema:name "Tapio Lahdenmäki" ;
    .

<http://worldcat.org/entity/work/data/802055420#CreativeWork/relational_database_index_design_and_the_optimizers>
    a schema:CreativeWork ;
    rdfs:label "Relational database index design and the optimizers." ;
    schema:description "Print version:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/85820599> ; # Relational database index design and the optimizers : DB2, Oracle, SQL server et al.
    .

<http://worldcat.org/isbn/9780471719991>
    a schema:ProductModel ;
    schema:isbn "0471719994" ;
    schema:isbn "9780471719991" ;
    .

<http://worldcat.org/isbn/9780471721369>
    a schema:ProductModel ;
    schema:isbn "0471721360" ;
    schema:isbn "9780471721369" ;
    .

<http://worldcat.org/isbn/9780471721376>
    a schema:ProductModel ;
    schema:isbn "0471721379" ;
    schema:isbn "9780471721376" ;
    .

<http://www.worldcat.org/title/-/oclc/85820599>
    a genont:InformationResource, genont:ContentTypeGenericResource ;
    schema:about <http://www.worldcat.org/oclc/85820599> ; # Relational database index design and the optimizers : DB2, Oracle, SQL server et al.
    schema:dateModified "2016-11-29" ;
    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.