Verfügbarkeit: Database tuning | Technische Universität München

Gespeichert in:

Bibliographische Detailangaben
Beteiligte Personen:	Shasha, Dennis (VerfasserIn), Bonnet, Philippe (VerfasserIn)
Format:	Buch
Sprache:	Englisch
Veröffentlicht:	Amsterdam [u.a.] Morgang Kaufmann 2003
Schriftenreihe:	Morgan Kaufmann series in data management systems
Schlagwörter:	Optimierung Datenbanksystem
Links:	http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009890083&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA
Beschreibung:	Früher u.d.T: Shasha, Dennis: Database tuning, 1992
Umfang:	XXIII, 415 S. graph. Darst.
ISBN:	1558607536

Internformat

MARC


LEADER	00000nam a2200000 c 4500
001	BV014530853
003	DE-604
005	20130527
007	t\|
008	020708s2003 xx d\|\|\| \|\|\|\| 00\|\|\| eng d
020			\|a 1558607536 \|9 1-55860-753-6
035			\|a (OCoLC)834303839
035			\|a (DE-599)BVBBV014530853
040			\|a DE-604 \|b ger \|e rakwb
041	0		\|a eng
049			\|a DE-739 \|a DE-91G \|a DE-859 \|a DE-11 \|a DE-188
082	0		\|a 005.74
084			\|a ST 270 \|0 (DE-625)143638: \|2 rvk
084			\|a DAT 655f \|2 stub
100	1		\|a Shasha, Dennis \|e Verfasser \|4 aut
245	1	0	\|a Database tuning \|b principles, experiments and troubleshooting techniques \|c Dennis Shasha ; Philippe Bonnet
264		1	\|a Amsterdam [u.a.] \|b Morgang Kaufmann \|c 2003
300			\|a XXIII, 415 S. \|b graph. Darst.
336			\|b txt \|2 rdacontent
337			\|b n \|2 rdamedia
338			\|b nc \|2 rdacarrier
490	0		\|a Morgan Kaufmann series in data management systems
500			\|a Früher u.d.T: Shasha, Dennis: Database tuning, 1992
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		\|5 DE-604
700	1		\|a Bonnet, Philippe \|e Verfasser \|4 aut
856	4	2	\|m Digitalisierung UB Passau \|q application/pdf \|u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009890083&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA \|3 Inhaltsverzeichnis
943	1		\|a oai:aleph.bib-bvb.de:BVB01-009890083

Datensatz im Suchindex

DE-BY-TUM_call_number	0102 DAT 655f 2001 A 32814(2)
DE-BY-TUM_katkey	1315067
DE-BY-TUM_location	01
DE-BY-TUM_media_number	040020287538
_version_	1821938580272971778
adam_text	CONTENTS Foreword ix Preface xix Chapter BASIC PRINCIPLES 1 1.1 The Power of Principles 1 1.2 Five Basic Principles 2 1.2.1 2 1.2.2 3 1.2.3 Are Low 4 1.2.4 5 1.2.5 6 1.3 Basic Principles and Knowledge 7 Chapter TUNING THE GUTS 9 2.1 Goal of Chapter 9 2.2 Locking and Concurrency Control 9 2.2.1 12 2.2.2 16 2.3 Logging and the Recovery Subsystem 36 2.3.1 37 2.3.2 42 2.4 Operating System Considerations 49 2.4.1 50 2.4.2 52 2.4.3 54 2.4.4 56 2.4.5 57 2.5 Hardware Tuning 59 2.5.1 2.5.2 59 66 Xl Xli CONTENTS Bibliography Exercises Chapter 3.1 3.2 3.3 3.4 3.4.1 3.4.2 3.5 3.6 3.6.1 3.6.2 3.6.3 3.7 3.8 3.9 3.10 3.11 Bibliography Exercises Chapter 4.1 4.2 4.2.1 4.2.2 4.2.3 4.2.4 4.2.5 4.2.6 4.2.7 4.3 4.4 4.5 CONTENTS Xlii 4.6 4.6.1 4.6.2 4.7 4.7.1 4.7.2 Bibliography Exercises Chapter5: COMMUNICATING WITH THE OUTSIDE 5.1 5.2 5.3 5.3.1 5.3.2 5.4 5.4.1 5.4.2 Between the Application and the Database Server 5.4.3 5.4.4 5.4.5 Compilations 5.5 5.6 Bibliography Chapter6: 6.1 6.2 6.3 6.3.1 6.3.2 6.3.3 Distributed Setting XIV CONTENTS 6.4 Queries 6.5 6.6 6.7 6.8 6.9 6.10 6.11 of Meaningful Keys 6.12 6.12.1 6.12.2 6.12.3 6.12.4 6.12.5 Bibliography Exercises Chapter by Alberto 7.1 7.1 · 1 7.1.2 7.2 7.2.1 7.2.2 7.2.3 7.2.4 7.3 7.3.1 7.3.2 7.3.3 7.4 7.4.1 7.4.2 CONTENTS 7.4.3 234 7.4.4 235 7.5 Is the DBMS Getting All It Needs? 236 7.5.1 237 7.5.2 237 7.5.3 239 7.5.4 239 7.6 Conclusion 240 Bibliography 240 ChapterS: NING 243 8.1 Goal 243 8.2 E-commerce Architecture 243 8.3 Tuning the E-commerce Architecture 246 8.3.1 246 8.3.2 249 8.3.3 249 8.4 Case Study: Shop Comparison Portal 250 8.5 Capacity Planning in a Nutshell 253 8.5.1 254 8.5.2 256 Bibliography 257 Exercises 258 Chapter TECHNIQUES, SUCCESSES, AND MISTAKES by Joe Celko 9.1 9.2 9.3 9.4 9.4.1 9.4.2 9.4.3 XVI CONTENTS ChapterlO: 10.1 10.1.1 10.1.2 10.2 Management Systems 10.3 10.4 Bibliography Exercises Appendix A: REAL-TIME DATABASES A.1 Overview A.2 Replicated State Machine Approach Appendix B: TRANSACTION CHOPPING B.I Assumptions B.2 Correct Choppings B.3 Finding the Finest Chopping B.4 Optimal Chopping Algorithm B.5 Application to Typical Database Systems B.5.1 Chopping and Snapshot Isolation B.6 Related Work Bibliography AppendixC: TIME SERIES, ESPECIALLY FOR FINANCE 326 327 329 329 330 332 332 333 C.1 Setting Up a Time Series Database C.2 FAME C.3 S-Plus C.4 SAS C.5 KDB C.6 Oracle 8i Time Series C.7 Features You Want for Time Series C.8 Time Series Data Mining CONTENTS XVII AppendixD: D.l Data Access Operators D.2 D.3 Bibliography Appendix ЕЛ E.2 SQL Server E.3 DB2 Glossary Index 337 339 342 346 348 349 350 354 355 361 387
any_adam_object	1
author	Shasha, Dennis Bonnet, Philippe
author_facet	Shasha, Dennis Bonnet, Philippe
author_role	aut aut
author_sort	Shasha, Dennis
author_variant	d s ds p b pb
building	Verbundindex
bvnumber	BV014530853
classification_rvk	ST 270
classification_tum	DAT 655f
ctrlnum	(OCoLC)834303839 (DE-599)BVBBV014530853
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
format	Book
fullrecord	<?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01593nam a2200397 c 4500</leader><controlfield tag="001">BV014530853</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20130527 </controlfield><controlfield tag="007">t\|</controlfield><controlfield tag="008">020708s2003 xx d\|\|\| \|\|\|\| 00\|\|\| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1558607536</subfield><subfield code="9">1-55860-753-6</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)834303839</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV014530853</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-739</subfield><subfield code="a">DE-91G</subfield><subfield code="a">DE-859</subfield><subfield code="a">DE-11</subfield><subfield code="a">DE-188</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.74</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 270</subfield><subfield code="0">(DE-625)143638:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">DAT 655f</subfield><subfield code="2">stub</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Shasha, Dennis</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="264" ind1=" " ind2="1"><subfield code="a">Amsterdam [u.a.]</subfield><subfield code="b">Morgang Kaufmann</subfield><subfield code="c">2003</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXIII, 415 S.</subfield><subfield code="b">graph. Darst.</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">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</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">Früher u.d.T: Shasha, Dennis: Database tuning, 1992</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="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Bonnet, Philippe</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Passau</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009890083&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-009890083</subfield></datafield></record></collection>
id	DE-604.BV014530853
illustrated	Illustrated
indexdate	2024-12-20T11:04:45Z
institution	BVB
isbn	1558607536
language	English
oai_aleph_id	oai:aleph.bib-bvb.de:BVB01-009890083
oclc_num	834303839
open_access_boolean
owner	DE-739 DE-91G DE-BY-TUM DE-859 DE-11 DE-188
owner_facet	DE-739 DE-91G DE-BY-TUM DE-859 DE-11 DE-188
physical	XXIII, 415 S. graph. Darst.
publishDate	2003
publishDateSearch	2003
publishDateSort	2003
publisher	Morgang Kaufmann
record_format	marc
series2	Morgan Kaufmann series in data management systems
spellingShingle	Shasha, Dennis Bonnet, Philippe Database tuning principles, experiments and troubleshooting techniques 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	Optimierung (DE-588)4043664-0 gnd Datenbanksystem (DE-588)4113276-2 gnd
topic_facet	Optimierung Datenbanksystem
url	http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009890083&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA
work_keys_str_mv	AT shashadennis databasetuningprinciplesexperimentsandtroubleshootingtechniques AT bonnetphilippe databasetuningprinciplesexperimentsandtroubleshootingtechniques

Verfügbarkeit

Bestellen (Login erforderlich)

Inhaltsverzeichnis
Paper/Kapitel scannen lassen

Teilbibliothek Mathematik & Informatik

Bestandsangaben von Teilbibliothek Mathematik & Informatik
Signatur:	0102 DAT 655f 2001 A 32814(2)
Exemplar 1	Ausleihbar Am Standort