Database Performance Tuning and Optimization
Using Oracle
Seiten
2013
|
Softcover reprint of the original 1st ed. 2003
Springer-Verlag New York Inc.
978-1-4757-7697-3 (ISBN)
Springer-Verlag New York Inc.
978-1-4757-7697-3 (ISBN)
Scope The book provides comprehensive coverage of database performance tuning and opti- zation using Oracle 8i as the RDBMS. 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.
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.
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.
Methodology.- Database Application Development.- Performance Tuning Methodology.- Tuning the Conceptual Level of a Database.- Oracle Tools for Tuning and Optimization.- 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.- Contemporary Issues.- Tuning the Data Warehouse at All Levels.- Web-Based Database Applications.
Zusatzinfo | XXI, 489 p. |
---|---|
Verlagsort | New York, NY |
Sprache | englisch |
Maße | 178 x 254 mm |
Themenwelt | Mathematik / Informatik ► Informatik ► Datenbanken |
Mathematik / Informatik ► Informatik ► Netzwerke | |
Informatik ► Theorie / Studium ► Algorithmen | |
ISBN-10 | 1-4757-7697-7 / 1475776977 |
ISBN-13 | 978-1-4757-7697-3 / 9781475776973 |
Zustand | Neuware |
Haben Sie eine Frage zum Produkt? |
Mehr entdecken
aus dem Bereich
aus dem Bereich
IT zum Anfassen für alle von 9 bis 99 – vom Navi bis Social Media
Buch | Softcover (2021)
Springer (Verlag)
CHF 41,95
Interlingua zur Gewährleistung semantischer Interoperabilität in der …
Buch | Softcover (2023)
Springer Fachmedien (Verlag)
CHF 46,15
Eine Einführung mit Java
Buch | Hardcover (2020)
dpunkt (Verlag)
CHF 62,85