Database tuning: principles, experiments, and troubleshooting techniques
Gespeichert in:
| 1. 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: | FAW01 FAW02 Volltext |
| Beschreibung: | Includes index 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 |
| Beschreibung: | 1 Online-Ressource (xxiii, 415 pages) |
| ISBN: | 0585448248 1558607536 9780585448244 9781558607538 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV043105455 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 151126s2003 |||| o||u| ||||||eng d | ||
| 020 | |a 0585448248 |9 0-585-44824-8 | ||
| 020 | |a 1558607536 |9 1-55860-753-6 | ||
| 020 | |a 9780585448244 |9 978-0-585-44824-4 | ||
| 020 | |a 9781558607538 |9 978-1-55860-753-8 | ||
| 035 | |a (OCoLC)52365957 | ||
| 035 | |a (DE-599)BVBBV043105455 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1046 |a DE-1047 | ||
| 082 | 0 | |a 005.74 |2 21 | |
| 100 | 1 | |a Shasha, Dennis Elliott |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Database tuning |b principles, experiments, and troubleshooting techniques |c Dennis Shasha, Philippe Bonnet |
| 250 | |a [Rev. ed.] | ||
| 264 | 1 | |a San Francisco, Calif. |b Morgan Kaufmann Publishers |c ©2003 | |
| 300 | |a 1 Online-Ressource (xxiii, 415 pages) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 490 | 0 | |a Morgan Kaufmann series in data management systems | |
| 500 | |a Includes index | ||
| 500 | |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 | ||
| 500 | |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 | ||
| 650 | 7 | |a COMPUTERS / Desktop Applications / Databases |2 bisacsh | |
| 650 | 7 | |a COMPUTERS / Database Management / General |2 bisacsh | |
| 650 | 7 | |a COMPUTERS / System Administration / Storage & Retrieval |2 bisacsh | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 4 | |a Database management | |
| 650 | 0 | 7 | |a Optimierung |0 (DE-588)4043664-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbanksystem |0 (DE-588)4113276-2 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Datenbanksystem |0 (DE-588)4113276-2 |D s |
| 689 | 0 | 1 | |a Optimierung |0 (DE-588)4043664-0 |D s |
| 689 | 0 | |8 1\p |5 DE-604 | |
| 700 | 1 | |a Bonnet, Philippe |e Sonstige |4 oth | |
| 856 | 4 | 0 | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=81854 |x Aggregator |3 Volltext |
| 912 | |a ZDB-4-EBA | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-028529646 | ||
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 966 | e | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=81854 |l FAW01 |p ZDB-4-EBA |q FAW_PDA_EBA |x Aggregator |3 Volltext | |
| 966 | e | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=81854 |l FAW02 |p ZDB-4-EBA |q FAW_PDA_EBA |x Aggregator |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1804175519653036032 |
|---|---|
| any_adam_object | |
| author | Shasha, Dennis Elliott |
| author_facet | Shasha, Dennis Elliott |
| author_role | aut |
| author_sort | Shasha, Dennis Elliott |
| author_variant | d e s de des |
| building | Verbundindex |
| bvnumber | BV043105455 |
| collection | ZDB-4-EBA |
| ctrlnum | (OCoLC)52365957 (DE-599)BVBBV043105455 |
| 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>04099nmm a2200553zc 4500</leader><controlfield tag="001">BV043105455</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">151126s2003 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0585448248</subfield><subfield code="9">0-585-44824-8</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1558607536</subfield><subfield code="9">1-55860-753-6</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780585448244</subfield><subfield code="9">978-0-585-44824-4</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781558607538</subfield><subfield code="9">978-1-55860-753-8</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)52365957</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV043105455</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1046</subfield><subfield code="a">DE-1047</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.74</subfield><subfield code="2">21</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Shasha, Dennis Elliott</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</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="264" ind1=" " ind2="1"><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-Ressource (xxiii, 415 pages)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" 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="500" ind1=" " 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="500" 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="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Desktop Applications / Databases</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Database Management / General</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / System Administration / Storage & Retrieval</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Optimierung</subfield><subfield code="0">(DE-588)4043664-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbanksystem</subfield><subfield code="0">(DE-588)4113276-2</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Datenbanksystem</subfield><subfield code="0">(DE-588)4113276-2</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Optimierung</subfield><subfield code="0">(DE-588)4043664-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="8">1\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Bonnet, Philippe</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=81854</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-028529646</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=81854</subfield><subfield code="l">FAW01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FAW_PDA_EBA</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=81854</subfield><subfield code="l">FAW02</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FAW_PDA_EBA</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV043105455 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T07:17:35Z |
| institution | BVB |
| isbn | 0585448248 1558607536 9780585448244 9781558607538 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028529646 |
| oclc_num | 52365957 |
| open_access_boolean | |
| owner | DE-1046 DE-1047 |
| owner_facet | DE-1046 DE-1047 |
| physical | 1 Online-Ressource (xxiii, 415 pages) |
| psigel | ZDB-4-EBA ZDB-4-EBA FAW_PDA_EBA |
| publishDate | 2003 |
| publishDateSearch | 2003 |
| publishDateSort | 2003 |
| publisher | Morgan Kaufmann Publishers |
| record_format | marc |
| series2 | Morgan Kaufmann series in data management systems |
| spelling | Shasha, Dennis Elliott Verfasser aut Database tuning principles, experiments, and troubleshooting techniques Dennis Shasha, Philippe Bonnet [Rev. ed.] San Francisco, Calif. Morgan Kaufmann Publishers ©2003 1 Online-Ressource (xxiii, 415 pages) txt rdacontent c rdamedia cr rdacarrier Morgan Kaufmann series in data management systems Includes index 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 COMPUTERS / Desktop Applications / Databases bisacsh COMPUTERS / Database Management / General bisacsh COMPUTERS / System Administration / Storage & Retrieval bisacsh Database management fast Database management Optimierung (DE-588)4043664-0 gnd rswk-swf Datenbanksystem (DE-588)4113276-2 gnd rswk-swf Datenbanksystem (DE-588)4113276-2 s Optimierung (DE-588)4043664-0 s 1\p DE-604 Bonnet, Philippe Sonstige oth http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=81854 Aggregator Volltext 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk |
| spellingShingle | Shasha, Dennis Elliott Database tuning principles, experiments, and troubleshooting techniques COMPUTERS / Desktop Applications / Databases bisacsh COMPUTERS / Database Management / General bisacsh COMPUTERS / System Administration / Storage & Retrieval bisacsh Database management fast Database management Optimierung (DE-588)4043664-0 gnd Datenbanksystem (DE-588)4113276-2 gnd |
| subject_GND | (DE-588)4043664-0 (DE-588)4113276-2 |
| 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 | COMPUTERS / Desktop Applications / Databases bisacsh COMPUTERS / Database Management / General bisacsh COMPUTERS / System Administration / Storage & Retrieval bisacsh Database management fast Database management Optimierung (DE-588)4043664-0 gnd Datenbanksystem (DE-588)4113276-2 gnd |
| topic_facet | COMPUTERS / Desktop Applications / Databases COMPUTERS / Database Management / General COMPUTERS / System Administration / Storage & Retrieval Database management Optimierung Datenbanksystem |
| url | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=81854 |
| work_keys_str_mv | AT shashadenniselliott databasetuningprinciplesexperimentsandtroubleshootingtechniques AT bonnetphilippe databasetuningprinciplesexperimentsandtroubleshootingtechniques |