Oracle9iR2 Data Warehousing
Digital Press
Published on 26. February 2003
Book
Paperback/Softback
519 pages
978-1-55558-287-6 (ISBN)
Article exhausted; check for reprint
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; and 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. Based on 9i plus the improvements in Release 2, it presents concepts with working examples and describes best practices and critical implementation tradeoffs, based on users' actual implementations.
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. Based on 9i plus the improvements in Release 2, it presents concepts with working examples and describes best practices and critical implementation tradeoffs, based on users' actual implementations.
Reviews / Votes
"By using Oracle 9i, pre-summarizing data, and storing it in materialized views, reports that used to take 2 hours to run now complete in 2 minutes." - Chuck Rozwat, Executive Vice President, Server Technologies, Oracle CorporationMore details
Language
English
Place of publication
Oxford
United Kingdom
Publishing group
Elsevier Science & Technology
Target group
College/higher education
Illustrations
ill.
Illustrated
Dimensions
Height: 235 mm
Width: 178 mm
Weight
835 gr
ISBN-13
978-1-55558-287-6 (9781555582876)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Other editions
New editions

Lilian Hobbs | Susan Hillson | Shilpa Lawande
Oracle 10g Data Warehousing
Book
12/2004
Digital Press
€88.00
Shipment within 3-4 weeks
Persons
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 Oracles 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 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 Masters degree in Computer Science from University of Wisconsin-Madison.
Content
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