Table of Contents

oracle9ir2 data warehousing
Oracle9iR2 Data Warehousing
by Lilian Hobbs, Susan Hillson and Shilpa Lawande ISBN:1555582877
Digital Press © 2003 (519 pages)

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.

Table of Contents
Oracle 9iR2 Data Warehousing
Foreword
Preface
Chapter 1 - Data Warehousing
Chapter 2 - Designing a Warehouse
Chapter 3 - Data Warehouse Features
Chapter 4 - Summary Management
Chapter 5 - Loading Data into the Warehouse
Chapter 6 - Oracle Warehousing Tools
Chapter 7 - Managing the Warehouse
Chapter 8 - Data Warehousing and the Web
Chapter 9 - Oracle 9i OLAP and Data Mining
Appendix
Index
List of Figures
List of Tables

oracle9ir2 data warehousing
Oracle9iR2 Data Warehousing
by Lilian Hobbs, Susan Hillson and Shilpa Lawande ISBN:1555582877
Digital Press © 2003 (519 pages)

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.

Oracle9IR2 Data Warehousing is a guide to using the Data Warehouse features in the latest versions of Oracle—Oracle9i 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 Oracle9i 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.

  • 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

About the Authors

Lilian Hobbs has been involved in the design and tuning of computer systems for over 20 years and holds a Ph.D. from the University of Southampton. To date she has written ten books including guides to using the Oracle and Rdb databases. Lilian is a project leader in Oracle’s Summary Management Development team.

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).

Shilpa Lawande is a principal developer in the 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.