Oracle8i Data Warehousing

Sixty per cent+ of Oracle 8i‘s new features affect data warehousing – how users store, gather, and leverage the information contained in their database systems. Many corporations consider data warehousing essential, from spreadsheet/financial data to high–level strategic data. "Oracle 8i Data Warehousing" is a complete resource providing data warehousers with the means to collect, analyse, and act on information contained on their database system.

From the back cover:

Create a Single Integrated Source of Corporate Business Information

Take full advantage of all the new Oracle8i tools and functionality to build a robust data warehousing system. Officially authorized by Oracle Corporation, Oracle8i Data Warehousing explains how to leverage Oracle‘s powerful family of technologies to build a reliable, scalable data warehousing and business intelligence infrastructure. You‘ll get full details on developing a plan, putting together a team, implementing your data warehouse, writing queries, and giving end–users direct access to their data. The book also explains how to use Oracle‘s integrated query analysis and reporting software, including Oracle Discoverer and the Oracle Data Mining Suite.

Plan, implement, and manage a data warehouse project

Build star schemas and design data marts

Set up a data warehouse using Oracle8i as its repository

Extract, transform, and load data using the Oracle Warehouse Builder

Index your data warehouse for optimal access

Manage storage and handle backup, recovery, tuning, and security

Enable data warehouse querying and analysis with Oracle Discoverer and Oracle Express

Convert a legacy database system into an Oracle8i data warehouse

Implement data webhousing to enable access via an intranet or the Internet

About the Author:

Michael J. Corey (Newton, MA) is co–owner of Database Technologies, former president of IOUG–A, and has more than 12 years experience using Oracle products. He has garnered a huge following in the Oracle Community and is considered to have the ear of the Oracle Corporation by the community. Michael Abbey (Ottawa, Ontario CN) has used Oracle for the past 12 years, specializing in Oracle/UNIX installation, performance tuning, and instance management. He is a member of the board of IOUG–A. Ben Taub (Ann Arbor, MI) is a Project Manager/Senior Warehouse architect with Dataspace Incorporated, as well as founder of the firm. He is the data warehousing focus area manager for IOUG–A. Ian Abramson (Toronto, Ontario) is the principal at IAS Inc., in Toronto, CA, and is currently the Director of Education Programming for IOUG–A and specializes in building applications and data warehousing.