Table of content

	Table of Contents

Oracle DBA Guide to Data Warehousing and Star Schemas
By Bert Scalzo
Publisher	: Prentice Hall PTR
Pub Date	: June 04, 2003
ISBN	: 0-13-032584-8
Pages	: 240

		Copyright
		The Prentice Hall PTR Oracle Series
		About Prentice Hall Professional Technical Reference
		Acknowledgments
		Introduction
			Purpose
			Audience
		Chapter 1.  What Is a Data Warehouse?
			The Nature of the Beast
			Data Warehouse vs. Big Database
			Operational Data Stores Don't Count
			Executive Information Systems Don't Count
			Warehouses Evolve without Phases
			The Warehouse Roller Coaster
		Chapter 2.  Software Architecture
			Business Intelligence Options
			Oracle Version Options
			Oracle Instance OptionsQuerying
			Oracle Instance OptionsLoading
			Recommended Oracle Architecture
			Great Operating System Debate
			The Great Programming Language Debate
			The Serial vs. Parallel Programming Debate
		Chapter 3.  Hardware Architecture
			Four Basic Questions
			How Many CPUs?
			How Much Memory?
			How Many of What Disks?
			Recommended Hardware Architecture
			The Great Vendor Debate
			The 32- vs. 64-Bit Oracle Debate
			The Raw vs. Cooked Files Debate
			The Need for Logical Volume Managers
		Chapter 4.  Star Schema Universe
			The Rationale for Stars
			Star Schema Challenges
			Modeling Star Schemas
			Avoid Snowflakes
			Dimensional Hierarchies
			Querying Star Schemas
			Fact Table Options
			When Stars Implode
		Chapter 5.  Tuning Ad-Hoc Queries
			Key Tuning Requirements
			Star Optimization Evolution
			Star Transformation Questions
			Initialization Parameters
			Star Schema Index Design
			Cost-Based Optimizer
			Some Parting Thoughts
		Chapter 6.  Loading the Warehouse
			What About ETL Tools?
			Loading Architecture
			Upstream Source Data
			Transformation Requirements
			Method 1: Transform, Then Load
			Method 2: Load, Then Transform
			Deploying the Loading Architecture
		Chapter 7.  Implementing Aggregates
			What Aggregates to Build?
			Loading Architecture
			Aggregation by Itself
			Use Materialized Views
		Chapter 8.  Partitioning for Manageability
			A Plethora of Design Options
			Logical Partitioning Design
			Simple Partitioning in 8i
			Simple Partitioning in 9i
			Complex Partitioning in 8i
			Complex Partitioning in 9i
			Partition Option Benchmarks
		Chapter 9.  Operational Issues and More
			Backup and Recovery
			Space Management
			Extent Management
			Updates and Patches