Relational database index design and the optimizers : (Record no. 11145)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 05189cam a2200949 a 4500 |
| 001 - CONTROL NUMBER | |
| control field | ocm85820599 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | OCoLC |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20240523125529.0 |
| 006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS | |
| fixed length control field | m o d |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION | |
| fixed length control field | cr unu|||||||| |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 040917s2005 njua ob 001 0 eng d |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | DG1 |
| Language of cataloging | eng |
| Description conventions | pn |
| Transcribing agency | DG1 |
| Modifying agency | BAKER |
| -- | WOS |
| -- | BTCTA |
| -- | OCLCA |
| -- | OKU |
| -- | OCLCQ |
| -- | DG1 |
| -- | OCLCQ |
| -- | OCLCF |
| -- | N$T |
| -- | YDXCP |
| -- | TEFOD |
| -- | IDEBK |
| -- | OCLCE |
| -- | E7B |
| -- | MHW |
| -- | REDDC |
| -- | DEBSZ |
| -- | OCLCQ |
| -- | TEFOD |
| -- | EBLCP |
| -- | COO |
| -- | OCLCQ |
| -- | DG1 |
| -- | LIP |
| -- | DEBBG |
| -- | OCLCQ |
| -- | MYIIU |
| -- | AU@ |
| -- | U3W |
| -- | OCLCQ |
| -- | OCLCO |
| -- | LUU |
| -- | OCLCQ |
| -- | OCLCO |
| -- | OCLCL |
| -- | OCLCQ |
| -- | OCLCL |
| 019 ## - | |
| -- | 62140825 |
| -- | 77493044 |
| -- | 607679645 |
| -- | 609295083 |
| -- | 956950244 |
| -- | 992814497 |
| -- | 1058285414 |
| -- | 1081085415 |
| -- | 1178954615 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 0471719994 |
| Qualifying information | (cloth) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9780471719991 |
| Qualifying information | (cloth) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 0471721379 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9780471721376 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 0471721360 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9780471721369 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 1280276614 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781280276613 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9786610276615 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 6610276617 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 0470247053 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9780470247051 |
| 024 7# - OTHER STANDARD IDENTIFIER | |
| Standard number or code | 10.1002/0471721379 |
| Source of number or code | doi |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | AU@ |
| System control number | 000061124714 |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | CHNEW |
| System control number | 000928843 |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | CHVBK |
| System control number | 480091684 |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | DEBBG |
| System control number | BV022477745 |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | DEBSZ |
| System control number | 379293706 |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | DEBSZ |
| System control number | 396072011 |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | DEBSZ |
| System control number | 400439050 |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | DEBSZ |
| System control number | 425880435 |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | DEBSZ |
| System control number | 430304676 |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | GBVCP |
| System control number | 790180634 |
| 029 1# - OTHER SYSTEM CONTROL NUMBER (OCLC) | |
| OCLC library identifier | NZ1 |
| System control number | 14154190 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (OCoLC)85820599 |
| Canceled/invalid control number | (OCoLC)62140825 |
| -- | (OCoLC)77493044 |
| -- | (OCoLC)607679645 |
| -- | (OCoLC)609295083 |
| -- | (OCoLC)956950244 |
| -- | (OCoLC)992814497 |
| -- | (OCoLC)1058285414 |
| -- | (OCoLC)1081085415 |
| -- | (OCoLC)1178954615 |
| 037 ## - SOURCE OF ACQUISITION | |
| Source of stock number/acquisition | OverDrive, Inc. |
| Note | http://www.overdrive.com |
| 037 ## - SOURCE OF ACQUISITION | |
| Stock number | 137FE088-805C-43A1-9D79-CED72B9C62CB |
| Source of stock number/acquisition | OverDrive, Inc. |
| Note | http://www.overdrive.com |
| 042 ## - AUTHENTICATION CODE | |
| Authentication code | dlr |
| 050 #4 - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | QA76.9.D3 |
| Item number | L335 2005eb |
| 072 #7 - SUBJECT CATEGORY CODE | |
| Subject category code | COM |
| Subject category code subdivision | 051170 |
| Source | bisacsh |
| 082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.75/65 |
| Edition number | 22 |
| 084 ## - OTHER CLASSIFICATION NUMBER | |
| Classification number | 54.64 |
| Number source | bcl |
| 049 ## - LOCAL HOLDINGS (OCLC) | |
| Holding library | MAIN |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Lahdenm�aki, Tapio. |
| 245 10 - TITLE STATEMENT | |
| Title | Relational database index design and the optimizers : |
| Remainder of title | DB2, Oracle, SQL server et al. / |
| Statement of responsibility, etc. | Tapio Lahdenm�aki, Michael Leach. |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. | |
| Place of publication, distribution, etc. | Hoboken, N.J. : |
| Name of publisher, distributor, etc. | John Wiley & Sons, |
| Date of publication, distribution, etc. | �2005. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 1 online resource (xvii, 310 pages) : |
| Other physical details | illustrations |
| 336 ## - CONTENT TYPE | |
| Content type term | text |
| Content type code | txt |
| Source | rdacontent |
| 337 ## - MEDIA TYPE | |
| Media type term | computer |
| Media type code | c |
| Source | rdamedia |
| 338 ## - CARRIER TYPE | |
| Carrier type term | online resource |
| Carrier type code | cr |
| Source | rdacarrier |
| 504 ## - BIBLIOGRAPHY, ETC. NOTE | |
| Bibliography, etc. note | Includes bibliographical references and indexes. |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 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. |
| 520 ## - SUMMARY, ETC. | |
| Summary, etc. | 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. |
| 588 0# - SOURCE OF DESCRIPTION NOTE | |
| Source of description note | Print version record. |
| 506 ## - RESTRICTIONS ON ACCESS NOTE | |
| Materials specified | Use copy |
| Standardized terminology for access restriction | Restrictions unspecified |
| Source of term | star |
| Institution to which field applies | MiAaHDL |
| 533 ## - REPRODUCTION NOTE | |
| Type of reproduction | Electronic reproduction. |
| Place of reproduction | [Place of publication not identified] : |
| Agency responsible for reproduction | HathiTrust Digital Library, |
| Date of reproduction | 2010. |
| Institution to which field applies | MiAaHDL |
| 538 ## - SYSTEM DETAILS NOTE | |
| System details note | 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. |
| Uniform Resource Identifier | <a href="http://purl.oclc.org/DLF/benchrepro0212">http://purl.oclc.org/DLF/benchrepro0212</a> |
| Institution to which field applies | MiAaHDL |
| 583 1# - ACTION NOTE | |
| Action | digitized |
| Time/date of action | 2010 |
| Jurisdiction | HathiTrust Digital Library |
| Status | committed to preserve |
| Source of term | pda |
| Institution to which field applies | MiAaHDL |
| 590 ## - LOCAL NOTE (RLIN) | |
| Local note | John Wiley and Sons |
| Provenance (VM) [OBSOLETE] | Wiley Online Library: Complete oBooks |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Relational databases. |
| 650 #6 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Bases de donn�ees relationnelles. |
| 650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | COMPUTERS |
| General subdivision | Programming Languages |
| -- | SQL. |
| Source of heading or term | bisacsh |
| 650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Relational databases |
| Source of heading or term | fast |
| 650 17 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Relationele databanken. |
| Source of heading or term | gtt |
| 650 17 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Indexeren. |
| Source of heading or term | gtt |
| 653 ## - INDEX TERM--UNCONTROLLED | |
| Uncontrolled term | Computer Science. |
| 700 1# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Leach, Mike, |
| Dates associated with a name | 1942- |
| Real World Object URI | https://id.oclc.org/worldcat/entity/E39PCjwYXQ9ypYRBBDvK6HX36X |
| 758 ## - RESOURCE IDENTIFIER | |
| Relationship information | has work: |
| Label | Relational database index design and the optimizers (Text) |
| Real World Object URI | https://id.oclc.org/worldcat/entity/E39PCFHTQwjKWgGK9dtHYhBRqP |
| Relationship | https://id.oclc.org/worldcat/ontology/hasWork |
| 776 08 - ADDITIONAL PHYSICAL FORM ENTRY | |
| Relationship information | Print version: |
| Main entry heading | Lahdenm�aki, Tapio. |
| Title | Relational database index design and the optimizers. |
| Place, publisher, and date of publication | Hoboken, N.J. : John Wiley & Sons, �2005 |
| International Standard Book Number | 0471719994 |
| Record control number | (DLC) 2004021914 |
| 856 40 - ELECTRONIC LOCATION AND ACCESS | |
| Uniform Resource Identifier | <a href="https://onlinelibrary.wiley.com/doi/book/10.1002/0471721379">https://onlinelibrary.wiley.com/doi/book/10.1002/0471721379</a> |
| 938 ## - | |
| -- | Baker & Taylor |
| -- | BKTY |
| -- | 84.95 |
| -- | 84.95 |
| -- | 0471721379 |
| -- | 0007317908 |
| -- | active |
| 938 ## - | |
| -- | Baker and Taylor |
| -- | BTCP |
| -- | BK0007317908 |
| 938 ## - | |
| -- | ProQuest Ebook Central |
| -- | EBLB |
| -- | EBL238765 |
| 938 ## - | |
| -- | ebrary |
| -- | EBRY |
| -- | ebr10304550 |
| 938 ## - | |
| -- | EBSCOhost |
| -- | EBSC |
| -- | 140379 |
| 938 ## - | |
| -- | YBP Library Services |
| -- | YANK |
| -- | 2943166 |
| 938 ## - | |
| -- | YBP Library Services |
| -- | YANK |
| -- | 2299040 |
| 994 ## - | |
| -- | 92 |
| -- | INLUM |
No items available.
