Skip to main content
Elsevier

Oracle9iR2 Data Warehousing

Oracle9iR2 Data Warehousing is a guide to using the Data Warehouse features in the latest versions of Oracle -- Oracle 9i Release 1 and Release 2. Written by people on the Oracle… Read more

Purchase options

Sorry, this title is not available for purchase in your country/region.

Data Mining & ML

Unlock the cutting edge

Up to 20% on trusted resources. Build expertise with data mining, ML methods.

Explore now

Description

Oracle9iR2 Data Warehousing is a guide to using the Data Warehouse features in the latest versions of Oracle -- Oracle 9i Release 1 and Release 2. Written by people on the Oracle development team that designed and implemented the code, this updated and expanded edition provides an insider's view of how the
Oracle 9i Release 2 software is best used for your application.

It provides a detailed look at a wide range of topics including:
· New techniques to facilitate the ETL process to transform data and load the warehouse
· How to use the Oracle OLAP and Data Mining options
· An entire chapter devoted to using materialized views to radically improve warehouse performance.

This book will show you how to use the Oracle database with tools such as Oracle Discoverer to query the warehouse, generate reports that can be deployed over the web, and gain better insight into your business.

This how-to guide provides step-by-step instructions including screen captures to make it easier to design, build, and optimize performance of the data warehouse or data mart. It is a 'must have' reference for database developers, administrators, and IT professionals who want to get to work now with all of the newest features in Oracle 9i Release 2.

Key features

·Based on 9i plus the improvements in Release 2
·Presents concepts with working examples
·Describes best practices and critical implementation tradeoffs, based on users' actual implementations

Readership

Oracle applications developers, Consultants; Trainers, Continuing education programs

Table of contents

Data Warehousing; Designing a Warehouse; Data Warehouse Features; Summary Management; Loading Data into the Warehouse; Oracle Warehousing Tools; Managing the Warehouse; Data Warehousing and the Web; Oracle 9i OLAP and Data Mining

Product details

About the authors

LH

Lilian Hobbs

Lilian Hobbs has been involved in the design and tuning of computer systems for over 20 years and holds a PhD from the University of Southampton. To date she has written 10 books including guides to using the Oracle and Rdb databases. Lilian is a project leader in Oracle’s Summary Management Development team.
Affiliations and expertise
Senior Principle Consultant -- Oracle Corporation

SH

Susan Hillson

Susan Hillson is a Senior Director of Engineering Development at Oracle. Her group is responsible for the development of Summary Management, Oracle Data Guard, and

the Database Utilities. She holds a MS degree in Computer Information Systems from Boston University. Susan has over 20 years’ experience in the computer industry,

including over 6 years teaching programming and database management systems. Susan co-authored Oracle8i Data Warehousing (Digital Press, 2000).

Affiliations and expertise
Former Senior Director of Data Server Division, Oracle Corporation's New England Development Center, Nashua, NH

SL

Shilpa Lawande

Shilpa Lawande is a principal developer in Oracles's Server Technologies Division. She is a member of the team that introduced materialized view technology into the Oracle server.

Shilpa has a BA from Indian Institute of Technology, Bombay, and a Master’s degree in Computer Science from University of

Wisconsin-Madison.

Affiliations and expertise
Senior Developer in the Server Technologies division at Oracle's New England Development Center, Nashua, NH