Oracle 8 Data Warehousing by Gary Dodge
This text explains how to design, build, and manage an Oracle data warehouse. It is aimed at database developers and administrators who are seeking technical details of how to build an Oracle data warehouse. It begins with a brief overview of the basics of data warehousing, then shows technically how to: select an appropriate hardware architecture to support the data warehouse; design the data warehouse for optimum performance; build the database; load data into the data warehouse using various tools and techniques; administer and monitor data warehouse performance; tune the warehouse to improved performance; and carry out advanced techniques for distributing and mining data using OLAP techniques.