Database tuning :: principles, experiments, and troubleshooting techniques /
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....
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Weitere Verfasser: | |
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
San Francisco, Calif. :
Morgan Kaufmann Publishers,
©2003.
|
| Ausgabe: | [Rev. ed.]. |
| Schriftenreihe: | Morgan Kaufmann series in data management systems.
|
| Schlagworte: | |
| Online-Zugang: | Volltext Volltext |
| Zusammenfassung: | 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. |
| Beschreibung: | Includes index. |
| Beschreibung: | 1 online resource (xxiii, 415 pages) : illustrations |
| Bibliographie: | Includes bibliographical references and index. |
| ISBN: | 0585448248 9780585448244 9781558607538 1558607536 1281035319 9781281035318 9786611035310 6611035311 0080503780 9780080503783 |
Internformat
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocm52365957 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr cn||||||||| | ||
| 008 | 030604s2003 caua ob 001 0 eng d | ||
| 010 | |z 2001099791 | ||
| 040 | |a N$T |b eng |e pn |c N$T |d YDXCP |d OCLCG |d OCLCA |d OCLCQ |d TNF |d OCLCQ |d NA5 |d OCLCF |d NLGGC |d OCLCQ |d OPELS |d OKU |d E7B |d OCLCQ |d BEDGE |d AGLDB |d OCLCQ |d SAV |d QT7 |d WY@ |d LUE |d STF |d D6H |d VTS |d OCLCQ |d INT |d TOF |d OCLCQ |d LEAUB |d OL$ |d UMK |d RDF |d VT2 |d UAB |d UKEHC |d OCLCO |d OCLCQ |d COA |d OCLCO |d OCLCL |d SXB |d OCLCQ |d OCLCO |d OCLCQ | ||
| 019 | |a 162596194 |a 532395104 |a 647652896 |a 847295075 |a 856952189 |a 961671822 |a 962631778 |a 992085783 |a 1007370278 |a 1035661368 |a 1053041131 |a 1109169375 |a 1156351864 |a 1179124246 |a 1192338632 |a 1200061955 |a 1240533994 |a 1340087624 | ||
| 020 | |a 0585448248 |q (electronic bk.) | ||
| 020 | |a 9780585448244 |q (electronic bk.) | ||
| 020 | |a 9781558607538 | ||
| 020 | |a 1558607536 | ||
| 020 | |a 1281035319 | ||
| 020 | |a 9781281035318 | ||
| 020 | |a 9786611035310 | ||
| 020 | |a 6611035311 | ||
| 020 | |a 0080503780 | ||
| 020 | |a 9780080503783 | ||
| 024 | 8 | |a (WaSeSS)ssj0000135106 | |
| 035 | |a (OCoLC)52365957 |z (OCoLC)162596194 |z (OCoLC)532395104 |z (OCoLC)647652896 |z (OCoLC)847295075 |z (OCoLC)856952189 |z (OCoLC)961671822 |z (OCoLC)962631778 |z (OCoLC)992085783 |z (OCoLC)1007370278 |z (OCoLC)1035661368 |z (OCoLC)1053041131 |z (OCoLC)1109169375 |z (OCoLC)1156351864 |z (OCoLC)1179124246 |z (OCoLC)1192338632 |z (OCoLC)1200061955 |z (OCoLC)1240533994 |z (OCoLC)1340087624 | ||
| 037 | |a 97113:97113 |b Elsevier Science & Technology |n http://www.sciencedirect.com | ||
| 050 | 4 | |a QA76.9.D3 |b S52 2003eb | |
| 072 | 7 | |a COM |x 084010 |2 bisacsh | |
| 072 | 7 | |a COM |x 021000 |2 bisacsh | |
| 072 | 7 | |a COM |x 030000 |2 bisacsh | |
| 082 | 7 | |a 005.74 |2 21 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Shasha, Dennis Elliott. |1 https://id.oclc.org/worldcat/entity/E39PBJv8KMwqH9By6R3CBWVKVC |0 http://id.loc.gov/authorities/names/n88635682 | |
| 245 | 1 | 0 | |a Database tuning : |b principles, experiments, and troubleshooting techniques / |c Dennis Shasha, Philippe Bonnet. |
| 250 | |a [Rev. ed.]. | ||
| 260 | |a San Francisco, Calif. : |b Morgan Kaufmann Publishers, |c ©2003. | ||
| 300 | |a 1 online resource (xxiii, 415 pages) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 1 | |a Morgan Kaufmann series in data management systems | |
| 500 | |a Includes index. | ||
| 588 | 0 | |a Print version record. | |
| 505 | 0 | |a 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. | |
| 520 | |a 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. | ||
| 504 | |a Includes bibliographical references and index. | ||
| 546 | |a English. | ||
| 650 | 0 | |a Database management. |0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a COMPUTERS |x Desktop Applications |x Databases. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Database Management |x General. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x System Administration |x Storage & Retrieval. |2 bisacsh | |
| 650 | 7 | |a Bases de données. |2 eclas | |
| 650 | 7 | |a SGBD = Systèmes de gestion de bases de données. |2 eclas | |
| 650 | 7 | |a Database management |2 fast | |
| 700 | 1 | |a Bonnet, Philippe, |d 1970- |1 https://id.oclc.org/worldcat/entity/E39PCjJRqDrgJHy87FTYxqGtmm |0 http://id.loc.gov/authorities/names/n2002153676 | |
| 776 | 0 | 8 | |i Print version: |a Shasha, Dennis Elliott. |t Database tuning. |b [Rev. ed.]. |d San Francisco, Calif. : Morgan Kaufmann Publishers, ©2003 |z 1558607536 |w (DLC) 2001099791 |w (OCoLC)50050619 |
| 830 | 0 | |a Morgan Kaufmann series in data management systems. |0 http://id.loc.gov/authorities/names/n90627178 | |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=81854 |3 Volltext |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://www.sciencedirect.com/science/book/9781558607538 |3 Volltext |
| 938 | |a EBSCOhost |b EBSC |n 81854 | ||
| 938 | |a YBP Library Services |b YANK |n 2333064 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocm52365957 |
|---|---|
| _version_ | 1816881607573766144 |
| adam_text | |
| any_adam_object | |
| author | Shasha, Dennis Elliott |
| author2 | Bonnet, Philippe, 1970- |
| author2_role | |
| author2_variant | p b pb |
| author_GND | http://id.loc.gov/authorities/names/n88635682 http://id.loc.gov/authorities/names/n2002153676 |
| author_facet | Shasha, Dennis Elliott Bonnet, Philippe, 1970- |
| author_role | |
| author_sort | Shasha, Dennis Elliott |
| author_variant | d e s de des |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D3 S52 2003eb |
| callnumber-search | QA76.9.D3 S52 2003eb |
| callnumber-sort | QA 276.9 D3 S52 42003EB |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| 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. |
| ctrlnum | (OCoLC)52365957 |
| dewey-full | 005.74 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.74 |
| dewey-search | 005.74 |
| dewey-sort | 15.74 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | [Rev. ed.]. |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>05658cam a2200733 a 4500</leader><controlfield tag="001">ZDB-4-EBA-ocm52365957 </controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cn|||||||||</controlfield><controlfield tag="008">030604s2003 caua ob 001 0 eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="z"> 2001099791</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">N$T</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">N$T</subfield><subfield code="d">YDXCP</subfield><subfield code="d">OCLCG</subfield><subfield code="d">OCLCA</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">TNF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">NA5</subfield><subfield code="d">OCLCF</subfield><subfield code="d">NLGGC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OPELS</subfield><subfield code="d">OKU</subfield><subfield code="d">E7B</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">BEDGE</subfield><subfield code="d">AGLDB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">SAV</subfield><subfield code="d">QT7</subfield><subfield code="d">WY@</subfield><subfield code="d">LUE</subfield><subfield code="d">STF</subfield><subfield code="d">D6H</subfield><subfield code="d">VTS</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">INT</subfield><subfield code="d">TOF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">LEAUB</subfield><subfield code="d">OL$</subfield><subfield code="d">UMK</subfield><subfield code="d">RDF</subfield><subfield code="d">VT2</subfield><subfield code="d">UAB</subfield><subfield code="d">UKEHC</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">COA</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield><subfield code="d">SXB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">162596194</subfield><subfield code="a">532395104</subfield><subfield code="a">647652896</subfield><subfield code="a">847295075</subfield><subfield code="a">856952189</subfield><subfield code="a">961671822</subfield><subfield code="a">962631778</subfield><subfield code="a">992085783</subfield><subfield code="a">1007370278</subfield><subfield code="a">1035661368</subfield><subfield code="a">1053041131</subfield><subfield code="a">1109169375</subfield><subfield code="a">1156351864</subfield><subfield code="a">1179124246</subfield><subfield code="a">1192338632</subfield><subfield code="a">1200061955</subfield><subfield code="a">1240533994</subfield><subfield code="a">1340087624</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0585448248</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780585448244</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781558607538</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1558607536</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1281035319</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781281035318</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9786611035310</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">6611035311</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0080503780</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780080503783</subfield></datafield><datafield tag="024" ind1="8" ind2=" "><subfield code="a">(WaSeSS)ssj0000135106</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)52365957</subfield><subfield code="z">(OCoLC)162596194</subfield><subfield code="z">(OCoLC)532395104</subfield><subfield code="z">(OCoLC)647652896</subfield><subfield code="z">(OCoLC)847295075</subfield><subfield code="z">(OCoLC)856952189</subfield><subfield code="z">(OCoLC)961671822</subfield><subfield code="z">(OCoLC)962631778</subfield><subfield code="z">(OCoLC)992085783</subfield><subfield code="z">(OCoLC)1007370278</subfield><subfield code="z">(OCoLC)1035661368</subfield><subfield code="z">(OCoLC)1053041131</subfield><subfield code="z">(OCoLC)1109169375</subfield><subfield code="z">(OCoLC)1156351864</subfield><subfield code="z">(OCoLC)1179124246</subfield><subfield code="z">(OCoLC)1192338632</subfield><subfield code="z">(OCoLC)1200061955</subfield><subfield code="z">(OCoLC)1240533994</subfield><subfield code="z">(OCoLC)1340087624</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">97113:97113</subfield><subfield code="b">Elsevier Science & Technology</subfield><subfield code="n">http://www.sciencedirect.com</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.D3</subfield><subfield code="b">S52 2003eb</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">084010</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">021000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">030000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.74</subfield><subfield code="2">21</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Shasha, Dennis Elliott.</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PBJv8KMwqH9By6R3CBWVKVC</subfield><subfield code="0">http://id.loc.gov/authorities/names/n88635682</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Database tuning :</subfield><subfield code="b">principles, experiments, and troubleshooting techniques /</subfield><subfield code="c">Dennis Shasha, Philippe Bonnet.</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">[Rev. ed.].</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">San Francisco, Calif. :</subfield><subfield code="b">Morgan Kaufmann Publishers,</subfield><subfield code="c">©2003.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (xxiii, 415 pages) :</subfield><subfield code="b">illustrations</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Morgan Kaufmann series in data management systems</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Print version record.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">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.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">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.</subfield></datafield><datafield tag="504" ind1=" " ind2=" "><subfield code="a">Includes bibliographical references and index.</subfield></datafield><datafield tag="546" ind1=" " ind2=" "><subfield code="a">English.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85035848</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Gestion.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Desktop Applications</subfield><subfield code="x">Databases.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Database Management</subfield><subfield code="x">General.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">System Administration</subfield><subfield code="x">Storage & Retrieval.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Bases de données.</subfield><subfield code="2">eclas</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">SGBD = Systèmes de gestion de bases de données.</subfield><subfield code="2">eclas</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="2">fast</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Bonnet, Philippe,</subfield><subfield code="d">1970-</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCjJRqDrgJHy87FTYxqGtmm</subfield><subfield code="0">http://id.loc.gov/authorities/names/n2002153676</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Shasha, Dennis Elliott.</subfield><subfield code="t">Database tuning.</subfield><subfield code="b">[Rev. ed.].</subfield><subfield code="d">San Francisco, Calif. : Morgan Kaufmann Publishers, ©2003</subfield><subfield code="z">1558607536</subfield><subfield code="w">(DLC) 2001099791</subfield><subfield code="w">(OCoLC)50050619</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Morgan Kaufmann series in data management systems.</subfield><subfield code="0">http://id.loc.gov/authorities/names/n90627178</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=81854</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://www.sciencedirect.com/science/book/9781558607538</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">81854</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">2333064</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-ocm52365957 |
| illustrated | Illustrated |
| indexdate | 2024-11-27T13:15:24Z |
| institution | BVB |
| isbn | 0585448248 9780585448244 9781558607538 1558607536 1281035319 9781281035318 9786611035310 6611035311 0080503780 9780080503783 |
| language | English |
| oclc_num | 52365957 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource (xxiii, 415 pages) : illustrations |
| psigel | ZDB-4-EBA |
| publishDate | 2003 |
| publishDateSearch | 2003 |
| publishDateSort | 2003 |
| publisher | Morgan Kaufmann Publishers, |
| record_format | marc |
| series | Morgan Kaufmann series in data management systems. |
| series2 | Morgan Kaufmann series in data management systems |
| spelling | Shasha, Dennis Elliott. https://id.oclc.org/worldcat/entity/E39PBJv8KMwqH9By6R3CBWVKVC http://id.loc.gov/authorities/names/n88635682 Database tuning : principles, experiments, and troubleshooting techniques / Dennis Shasha, Philippe Bonnet. [Rev. ed.]. San Francisco, Calif. : Morgan Kaufmann Publishers, ©2003. 1 online resource (xxiii, 415 pages) : illustrations text txt rdacontent computer c rdamedia online resource cr rdacarrier Morgan Kaufmann series in data management systems Includes index. Print version record. 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. 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. Includes bibliographical references and index. English. Database management. http://id.loc.gov/authorities/subjects/sh85035848 Bases de données Gestion. COMPUTERS Desktop Applications Databases. bisacsh COMPUTERS Database Management General. bisacsh COMPUTERS System Administration Storage & Retrieval. bisacsh Bases de données. eclas SGBD = Systèmes de gestion de bases de données. eclas Database management fast Bonnet, Philippe, 1970- https://id.oclc.org/worldcat/entity/E39PCjJRqDrgJHy87FTYxqGtmm http://id.loc.gov/authorities/names/n2002153676 Print version: Shasha, Dennis Elliott. Database tuning. [Rev. ed.]. San Francisco, Calif. : Morgan Kaufmann Publishers, ©2003 1558607536 (DLC) 2001099791 (OCoLC)50050619 Morgan Kaufmann series in data management systems. http://id.loc.gov/authorities/names/n90627178 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=81854 Volltext FWS01 ZDB-4-EBA FWS_PDA_EBA https://www.sciencedirect.com/science/book/9781558607538 Volltext |
| spellingShingle | Shasha, Dennis Elliott Database tuning : principles, experiments, and troubleshooting techniques / Morgan Kaufmann series in data management systems. 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. Database management. http://id.loc.gov/authorities/subjects/sh85035848 Bases de données Gestion. COMPUTERS Desktop Applications Databases. bisacsh COMPUTERS Database Management General. bisacsh COMPUTERS System Administration Storage & Retrieval. bisacsh Bases de données. eclas SGBD = Systèmes de gestion de bases de données. eclas Database management fast |
| subject_GND | http://id.loc.gov/authorities/subjects/sh85035848 |
| title | Database tuning : principles, experiments, and troubleshooting techniques / |
| title_auth | Database tuning : principles, experiments, and troubleshooting techniques / |
| title_exact_search | Database tuning : principles, experiments, and troubleshooting techniques / |
| title_full | Database tuning : principles, experiments, and troubleshooting techniques / Dennis Shasha, Philippe Bonnet. |
| title_fullStr | Database tuning : principles, experiments, and troubleshooting techniques / Dennis Shasha, Philippe Bonnet. |
| title_full_unstemmed | Database tuning : principles, experiments, and troubleshooting techniques / Dennis Shasha, Philippe Bonnet. |
| title_short | Database tuning : |
| title_sort | database tuning principles experiments and troubleshooting techniques |
| title_sub | principles, experiments, and troubleshooting techniques / |
| topic | Database management. http://id.loc.gov/authorities/subjects/sh85035848 Bases de données Gestion. COMPUTERS Desktop Applications Databases. bisacsh COMPUTERS Database Management General. bisacsh COMPUTERS System Administration Storage & Retrieval. bisacsh Bases de données. eclas SGBD = Systèmes de gestion de bases de données. eclas Database management fast |
| topic_facet | Database management. Bases de données Gestion. COMPUTERS Desktop Applications Databases. COMPUTERS Database Management General. COMPUTERS System Administration Storage & Retrieval. Bases de données. SGBD = Systèmes de gestion de bases de données. Database management |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=81854 https://www.sciencedirect.com/science/book/9781558607538 |
| work_keys_str_mv | AT shashadenniselliott databasetuningprinciplesexperimentsandtroubleshootingtechniques AT bonnetphilippe databasetuningprinciplesexperimentsandtroubleshootingtechniques |