Database Performance Tuning and Optimization: Using Oracle
Scope The book provides comprehensive coverage of database performance tuning and opti- zation using Oracle 8i as the RDBMS. The chapters contain both theoretical discussions dealing with principles and methodology as well as actual SQL scripts to implement the methodology. The book combines theory...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
New York, NY
Springer New York
2003
|
| Ausgabe: | 1st ed. 2003 |
| Schlagworte: | |
| Online-Zugang: | UBY01 Volltext |
| Zusammenfassung: | Scope The book provides comprehensive coverage of database performance tuning and opti- zation using Oracle 8i as the RDBMS. The chapters contain both theoretical discussions dealing with principles and methodology as well as actual SQL scripts to implement the methodology. The book combines theory with practice so as to make it useful for DBAs and developers irrespective of whether they use Oracle 8i. Readers who do not use Oracle 8i can implement the principles via scripts of their own written for the particular RDBMS they use. I have tested each script for accuracy and have included the sample outputs generated from them. An operational database has three levels: conceptual, internal, and external. The c- ceptual level results from data modeling and logical database design. When it is imp- mented via an RDBMS such as Oracle, it is mapped onto the internal level. Database - jects of the conceptual level are associated with their physical counterparts in the internal level. An external level results from a query against the database and, as such, provides a window to the database. There are many external levels for a single conceptual level |
| Beschreibung: | 1 Online-Ressource (XXI, 489 p) |
| ISBN: | 9780387218083 |
| DOI: | 10.1007/b97504 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV047064008 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 201216s2003 |||| o||u| ||||||eng d | ||
| 020 | |a 9780387218083 |9 978-0-387-21808-3 | ||
| 024 | 7 | |a 10.1007/b97504 |2 doi | |
| 035 | |a (ZDB-2-SCS)978-0-387-21808-3 | ||
| 035 | |a (OCoLC)1227480646 | ||
| 035 | |a (DE-599)BVBBV047064008 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-706 | ||
| 082 | 0 | |a 005.73 |2 23 | |
| 084 | |a ST 270 |0 (DE-625)143638: |2 rvk | ||
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 100 | 1 | |a Mittra, Sitansu S. |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Database Performance Tuning and Optimization |b Using Oracle |c by Sitansu S. Mittra |
| 250 | |a 1st ed. 2003 | ||
| 264 | 1 | |a New York, NY |b Springer New York |c 2003 | |
| 300 | |a 1 Online-Ressource (XXI, 489 p) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 520 | |a Scope The book provides comprehensive coverage of database performance tuning and opti- zation using Oracle 8i as the RDBMS. The chapters contain both theoretical discussions dealing with principles and methodology as well as actual SQL scripts to implement the methodology. The book combines theory with practice so as to make it useful for DBAs and developers irrespective of whether they use Oracle 8i. Readers who do not use Oracle 8i can implement the principles via scripts of their own written for the particular RDBMS they use. I have tested each script for accuracy and have included the sample outputs generated from them. An operational database has three levels: conceptual, internal, and external. The c- ceptual level results from data modeling and logical database design. When it is imp- mented via an RDBMS such as Oracle, it is mapped onto the internal level. Database - jects of the conceptual level are associated with their physical counterparts in the internal level. An external level results from a query against the database and, as such, provides a window to the database. There are many external levels for a single conceptual level | ||
| 650 | 4 | |a Data Structures and Information Theory | |
| 650 | 4 | |a Database Management | |
| 650 | 4 | |a Information Storage and Retrieval | |
| 650 | 4 | |a Information Systems and Communication Service | |
| 650 | 4 | |a Data structures (Computer science) | |
| 650 | 4 | |a Database management | |
| 650 | 4 | |a Information storage and retrieval | |
| 650 | 4 | |a Computers | |
| 650 | 0 | 7 | |a Tuning |0 (DE-588)4117263-2 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a ORACLE |g Datenbanksystem |0 (DE-588)4206222-6 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a ORACLE |g Datenbanksystem |0 (DE-588)4206222-6 |D s |
| 689 | 0 | |5 DE-604 | |
| 689 | 1 | 0 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |D s |
| 689 | 1 | |5 DE-604 | |
| 689 | 2 | 0 | |a Tuning |0 (DE-588)4117263-2 |D s |
| 689 | 2 | |5 DE-604 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 9781475776973 |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 9780387953939 |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 9781475776966 |
| 856 | 4 | 0 | |u https://doi.org/10.1007/b97504 |x Verlag |z URL des Eerstveröffentlichers |3 Volltext |
| 912 | |a ZDB-2-SCS | ||
| 940 | 1 | |q ZDB-2-SCS_2000/2004 | |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-032471120 | ||
| 966 | e | |u https://doi.org/10.1007/b97504 |l UBY01 |p ZDB-2-SCS |q ZDB-2-SCS_2000/2004 |x Verlag |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1804182061457604608 |
|---|---|
| adam_txt | |
| any_adam_object | |
| any_adam_object_boolean | |
| author | Mittra, Sitansu S. |
| author_facet | Mittra, Sitansu S. |
| author_role | aut |
| author_sort | Mittra, Sitansu S. |
| author_variant | s s m ss ssm |
| building | Verbundindex |
| bvnumber | BV047064008 |
| classification_rvk | ST 270 ST 271 |
| collection | ZDB-2-SCS |
| ctrlnum | (ZDB-2-SCS)978-0-387-21808-3 (OCoLC)1227480646 (DE-599)BVBBV047064008 |
| dewey-full | 005.73 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.73 |
| dewey-search | 005.73 |
| dewey-sort | 15.73 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| discipline_str_mv | Informatik |
| doi_str_mv | 10.1007/b97504 |
| edition | 1st ed. 2003 |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03433nmm a2200625zc 4500</leader><controlfield tag="001">BV047064008</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">201216s2003 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780387218083</subfield><subfield code="9">978-0-387-21808-3</subfield></datafield><datafield tag="024" ind1="7" ind2=" "><subfield code="a">10.1007/b97504</subfield><subfield code="2">doi</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-2-SCS)978-0-387-21808-3</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1227480646</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV047064008</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-706</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.73</subfield><subfield code="2">23</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">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Mittra, Sitansu S.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Database Performance Tuning and Optimization</subfield><subfield code="b">Using Oracle</subfield><subfield code="c">by Sitansu S. Mittra</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1st ed. 2003</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">New York, NY</subfield><subfield code="b">Springer New York</subfield><subfield code="c">2003</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (XXI, 489 p)</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="520" ind1=" " ind2=" "><subfield code="a">Scope The book provides comprehensive coverage of database performance tuning and opti- zation using Oracle 8i as the RDBMS. The chapters contain both theoretical discussions dealing with principles and methodology as well as actual SQL scripts to implement the methodology. The book combines theory with practice so as to make it useful for DBAs and developers irrespective of whether they use Oracle 8i. Readers who do not use Oracle 8i can implement the principles via scripts of their own written for the particular RDBMS they use. I have tested each script for accuracy and have included the sample outputs generated from them. An operational database has three levels: conceptual, internal, and external. The c- ceptual level results from data modeling and logical database design. When it is imp- mented via an RDBMS such as Oracle, it is mapped onto the internal level. Database - jects of the conceptual level are associated with their physical counterparts in the internal level. An external level results from a query against the database and, as such, provides a window to the database. There are many external levels for a single conceptual level</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Data Structures and Information Theory</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database Management</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Information Storage and Retrieval</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Information Systems and Communication Service</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Data structures (Computer science)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Information storage and retrieval</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Computers</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Tuning</subfield><subfield code="0">(DE-588)4117263-2</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">ORACLE</subfield><subfield code="g">Datenbanksystem</subfield><subfield code="0">(DE-588)4206222-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">ORACLE</subfield><subfield code="g">Datenbanksystem</subfield><subfield code="0">(DE-588)4206222-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" ind2="0"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="2" ind2="0"><subfield code="a">Tuning</subfield><subfield code="0">(DE-588)4117263-2</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">9781475776973</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">9780387953939</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">9781475776966</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">https://doi.org/10.1007/b97504</subfield><subfield code="x">Verlag</subfield><subfield code="z">URL des Eerstveröffentlichers</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-2-SCS</subfield></datafield><datafield tag="940" ind1="1" ind2=" "><subfield code="q">ZDB-2-SCS_2000/2004</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-032471120</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/b97504</subfield><subfield code="l">UBY01</subfield><subfield code="p">ZDB-2-SCS</subfield><subfield code="q">ZDB-2-SCS_2000/2004</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV047064008 |
| illustrated | Not Illustrated |
| index_date | 2024-07-03T16:12:21Z |
| indexdate | 2024-07-10T09:01:34Z |
| institution | BVB |
| isbn | 9780387218083 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-032471120 |
| oclc_num | 1227480646 |
| open_access_boolean | |
| owner | DE-706 |
| owner_facet | DE-706 |
| physical | 1 Online-Ressource (XXI, 489 p) |
| psigel | ZDB-2-SCS ZDB-2-SCS_2000/2004 ZDB-2-SCS ZDB-2-SCS_2000/2004 |
| publishDate | 2003 |
| publishDateSearch | 2003 |
| publishDateSort | 2003 |
| publisher | Springer New York |
| record_format | marc |
| spelling | Mittra, Sitansu S. Verfasser aut Database Performance Tuning and Optimization Using Oracle by Sitansu S. Mittra 1st ed. 2003 New York, NY Springer New York 2003 1 Online-Ressource (XXI, 489 p) txt rdacontent c rdamedia cr rdacarrier Scope The book provides comprehensive coverage of database performance tuning and opti- zation using Oracle 8i as the RDBMS. The chapters contain both theoretical discussions dealing with principles and methodology as well as actual SQL scripts to implement the methodology. The book combines theory with practice so as to make it useful for DBAs and developers irrespective of whether they use Oracle 8i. Readers who do not use Oracle 8i can implement the principles via scripts of their own written for the particular RDBMS they use. I have tested each script for accuracy and have included the sample outputs generated from them. An operational database has three levels: conceptual, internal, and external. The c- ceptual level results from data modeling and logical database design. When it is imp- mented via an RDBMS such as Oracle, it is mapped onto the internal level. Database - jects of the conceptual level are associated with their physical counterparts in the internal level. An external level results from a query against the database and, as such, provides a window to the database. There are many external levels for a single conceptual level Data Structures and Information Theory Database Management Information Storage and Retrieval Information Systems and Communication Service Data structures (Computer science) Database management Information storage and retrieval Computers Tuning (DE-588)4117263-2 gnd rswk-swf Datenbankverwaltung (DE-588)4389357-0 gnd rswk-swf ORACLE Datenbanksystem (DE-588)4206222-6 gnd rswk-swf ORACLE Datenbanksystem (DE-588)4206222-6 s DE-604 Datenbankverwaltung (DE-588)4389357-0 s Tuning (DE-588)4117263-2 s Erscheint auch als Druck-Ausgabe 9781475776973 Erscheint auch als Druck-Ausgabe 9780387953939 Erscheint auch als Druck-Ausgabe 9781475776966 https://doi.org/10.1007/b97504 Verlag URL des Eerstveröffentlichers Volltext |
| spellingShingle | Mittra, Sitansu S. Database Performance Tuning and Optimization Using Oracle Data Structures and Information Theory Database Management Information Storage and Retrieval Information Systems and Communication Service Data structures (Computer science) Database management Information storage and retrieval Computers Tuning (DE-588)4117263-2 gnd Datenbankverwaltung (DE-588)4389357-0 gnd ORACLE Datenbanksystem (DE-588)4206222-6 gnd |
| subject_GND | (DE-588)4117263-2 (DE-588)4389357-0 (DE-588)4206222-6 |
| title | Database Performance Tuning and Optimization Using Oracle |
| title_auth | Database Performance Tuning and Optimization Using Oracle |
| title_exact_search | Database Performance Tuning and Optimization Using Oracle |
| title_exact_search_txtP | Database Performance Tuning and Optimization Using Oracle |
| title_full | Database Performance Tuning and Optimization Using Oracle by Sitansu S. Mittra |
| title_fullStr | Database Performance Tuning and Optimization Using Oracle by Sitansu S. Mittra |
| title_full_unstemmed | Database Performance Tuning and Optimization Using Oracle by Sitansu S. Mittra |
| title_short | Database Performance Tuning and Optimization |
| title_sort | database performance tuning and optimization using oracle |
| title_sub | Using Oracle |
| topic | Data Structures and Information Theory Database Management Information Storage and Retrieval Information Systems and Communication Service Data structures (Computer science) Database management Information storage and retrieval Computers Tuning (DE-588)4117263-2 gnd Datenbankverwaltung (DE-588)4389357-0 gnd ORACLE Datenbanksystem (DE-588)4206222-6 gnd |
| topic_facet | Data Structures and Information Theory Database Management Information Storage and Retrieval Information Systems and Communication Service Data structures (Computer science) Database management Information storage and retrieval Computers Tuning Datenbankverwaltung ORACLE Datenbanksystem |
| url | https://doi.org/10.1007/b97504 |
| work_keys_str_mv | AT mittrasitansus databaseperformancetuningandoptimizationusingoracle |