Free shipping on all orders over $79* Limited Time Only
Track My Order
Help Centre
Likes
My Wish ListsLogin / Join
Booktopia
Australia's local bookstore
Get Free Shipping on orders over $79
Database Performance Tuning and Optimization : Using Oracle : Using Oracle - Sitansu S. Mittra

Database Performance Tuning and Optimization : Using Oracle

Using Oracle

By: Sitansu S. Mittra

Hardcover | 16 August 2010

At a Glance

Hardcover

$84.99

or 4 interest-free payments of $21.25 with

 or 

Ships in 5 to 7 business days

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.

You Can Find This Book In

Non-FictionComputing & I.T.Computer ScienceComputer Programming & Software DevelopmentAlgorithms & Data StructuresDigital Lifestyle & Online World: Consumer & User GuidesInternet Guides & Online ServicesDatabasesInformation RetrievalComputer Networking & CommunicationsReference, Information & Interdisciplinary SubjectsResearch & Information
Information theoryComputer HardwareNetwork HardwareData Warehousing

More in Databases

Python All-in-One For Dummies : 3rd Edition - John C. Shovic

Python All-in-One For Dummies

3rd Edition

Paperback

RRP $74.95

$55.75

26%
OFF
Database Systems : A Practical Approach - Mitchell Penn

Database Systems

A Practical Approach

Hardcover

$453.75

Tools and Applications of Data Mining - Richard Vincent

Tools and Applications of Data Mining

Hardcover

$453.75

Big Data Analytics : A Practical Guide - Candy Walken

Big Data Analytics

A Practical Guide

Hardcover

$413.75

This product is categorised by