Skip to main content
SpringerLink
Log in

Database Performance Tuning and Optimization

Using Oracle

  • Book
  • © 2003

Overview

Authors:
  1. Sitansu S. Mittra

    1. Computer Sciences Corporation, Cambridge, USA

    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Clear explanation of three levels of databases

  • Ideal mix of theory and practice

  • Addresses web-based databases

  • Useful chapter-by-chapter exercises

  • Describes mathematical foundations of relational databases

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book USD 54.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (12 chapters)

  1. Front Matter

    Pages i-xxi
    Download chapter PDF

  4. Contemporary Issues

    1. Front Matter

      Pages 359-359
      Download chapter PDF

    2. Tuning the Data Warehouse at All Levels

      Pages 361-384

    3. Web-Based Database Applications

      Pages 385-398

  5. Back Matter

    Pages 400-489
    Download chapter PDF
Back to top

Keywords

About this book

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.

Authors and Affiliations

  • Computer Sciences Corporation, Cambridge, USA

    Sitansu S. Mittra

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation