Oracle9iR2 Data Warehousing
- 1st Edition - February 6, 2003
- Imprint: Digital Press
- Authors: Lilian Hobbs, Susan Hillson, Shilpa Lawande
- Language: English
- Paperback ISBN:9 7 8 - 1 - 5 5 5 5 8 - 2 8 7 - 6
- eBook ISBN:9 7 8 - 0 - 0 8 - 0 5 1 3 3 1 - 7
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
Institutional subscription on ScienceDirect
Request a sales quoteOracle9iR2 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.
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.
·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
·Presents concepts with working examples
·Describes best practices and critical implementation tradeoffs, based on users' actual implementations
Oracle applications developers, Consultants; Trainers, Continuing education programs
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
- Edition: 1
- Published: February 6, 2003
- Imprint: Digital Press
- No. of pages: 519
- Language: English
- Paperback ISBN: 9781555582876
- eBook ISBN: 9780080513317
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 CorporationSH
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, NHSL
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