Database Performance Tuning and Optimization : Using Oracle

Sitansu S. Mittra

ISBN 10: 1475776977 / ISBN 13: 9781475776973

Verlag: Springer New York, Springer New York, 2013

Beschreibung

Druck auf Anfrage Neuware - Printed after ordering - 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.

Bestandsnummer des Verkäufers 9781475776973

Bibliografische Details

• Titel: Database Performance Tuning and Optimization : Using Oracle
• Verlag: Springer New York, Springer New York
• Erscheinungsjahr: 2013
• Sprache: Englisch
• ISBN-10: 1475776977
• ISBN-13: 9781475776973
• Einband: Taschenbuch
• Zustand: Neu

Über diesen Titel

Inhaltsangabe

The book assumes an understanding of relational database concepts and a familiarity with Oracle. It is targeted primarily for database professionals such as DBAs, developers, and system analysts with two to three years of experience in the development, implementation, and maintenance of relational databases using some RDBMS, preferably Oracle. A junior DBA or a developer can use the scripts of the book under the guidance of a senior DBA or developer.

Reseña del editor

Presents an ideal mix of theory and practice, which allows the reader to understand the principle behind the application.; Coverage of performance tuning of datawarehouses offers readers the principles and tools they need to handle large reporting databases.; Material can also be used in a non-Oracle environment; Highly experienced author.