Database tuning: principles, experiments and troubleshooting techniques
Saved in:
| Main Authors: | , |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Amsterdam [u.a.]
Morgang Kaufmann
2003
|
| Series: | Morgan Kaufmann series in data management systems
|
| Subjects: | |
| Online Access: | Inhaltsverzeichnis |
| Item Description: | Früher u.d.T: Shasha, Dennis: Database tuning, 1992 |
| Physical Description: | XXIII, 415 S. graph. Darst. |
| ISBN: | 1558607536 |
Staff View
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV014530853 | ||
| 003 | DE-604 | ||
| 005 | 20130527 | ||
| 007 | t | ||
| 008 | 020708s2003 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 |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-009890083 | ||
Record in the Search Index
| _version_ | 1804129323020451840 |
|---|---|
| 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>01592nam 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 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="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-009890083</subfield></datafield></record></collection> |
| id | DE-604.BV014530853 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T19:03:18Z |
| 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 |
| spelling | Shasha, Dennis Verfasser aut Database tuning principles, experiments and troubleshooting techniques Dennis Shasha ; Philippe Bonnet Amsterdam [u.a.] Morgang Kaufmann 2003 XXIII, 415 S. graph. Darst. txt rdacontent n rdamedia nc rdacarrier Morgan Kaufmann series in data management systems Früher u.d.T: Shasha, Dennis: Database tuning, 1992 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 DE-604 Bonnet, Philippe Verfasser aut Digitalisierung UB Passau application/pdf 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 Inhaltsverzeichnis |
| 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 |