Database Performance Tuning and Optimization, w. CD-ROM
Using Oracle
(Sprache: Englisch)
This book provides comprehensive coverage of database performance tuning using Oracle8 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...
Leider schon ausverkauft
versandkostenfrei
Buch
96.29 €
- Lastschrift, Kreditkarte, Paypal, Rechnung
- Kostenlose Rücksendung
- Ratenzahlung möglich
Produktdetails
Produktinformationen zu „Database Performance Tuning and Optimization, w. CD-ROM “
Klappentext zu „Database Performance Tuning and Optimization, w. CD-ROM “
This book provides comprehensive coverage of database performance tuning using Oracle8 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 Oracle8. Readers who do not use Oracle98 can implement the principles via scripts of their own written for the RDBMS used by them. An operational database has three levels: conceptual, internal, and external. The conceptual level results from data modeling and logical database design. When it is implemented via an RDBMS such as Oracle, it is mapped onto the internal level. Database objects 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. The performance of an OLTPdatabase is measured by the response times of databased transactions. The response time depends on the efficiency of all three levels. A query on a well-designed conceptual level can run slowly if the SQL formulation of the query is poorly done, or if the database objects involved in the query are fragmented, or if a table used by the query has excessive chaining. The book addresses each level separately by focusing first on the underlying principles and root causes of problems and then offering solutions, both on a theoretical level and with Oracle SQL scripts with sample outputs.
This book provides comprehensive coverage of database performance tuning using Oracle8 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 Oracle8. Readers who do not use Oracle98 can implement the principles via scripts of their own written for the RDBMS used by them. An operational database has three levels: conceptual, internal, and external. The conceptual level results from data modeling and logical database design. When it is implemented via an RDBMS such as Oracle, it is mapped onto the internal level. Database objects 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. The performance of an OLTP database is measured by the response times of databased transactions. The response time depends on the efficiency of all three levels. A query on a well-designed conceptual level can run slowly if the SQL formulation of the query is poorly done, or if the database objects involved in the query are fragmented, or if a table used by the query has excessive chaining. The book addresses each level separately by focusing first on the underlying principles and root causes of problems and then offering solutions, both on a theoretical level and with Oracle SQL scripts with sample outputs.
Inhaltsverzeichnis zu „Database Performance Tuning and Optimization, w. CD-ROM “
Database application development Performance tuning methodology Tuning conceptual level of a database Internal level of an Oracle database Tuning of disk resident data structures Tuning of memory resident data structures Oracle utility for tuning and optimization Optimization of the external level of a database Query tuning and optimization under Oracle 8i Special features of Oracle 8i and a glimpse into Oracle 9i Tuning the data warehouse at all levels Web-based database applications Appendices
Bibliographische Angaben
- Autor: Sitansu S. Mittra
- 2002, 489 Seiten, Maße: 25,4 cm, Gebunden, Englisch
- Verlag: Springer, New York
- ISBN-10: 0387953930
- ISBN-13: 9780387953939
Sprache:
Englisch
Kommentar zu "Database Performance Tuning and Optimization, w. CD-ROM"
0 Gebrauchte Artikel zu „Database Performance Tuning and Optimization, w. CD-ROM“
Zustand | Preis | Porto | Zahlung | Verkäufer | Rating |
---|
Schreiben Sie einen Kommentar zu "Database Performance Tuning and Optimization, w. CD-ROM".
Kommentar verfassen