---

Oracle DBA Guide to Data Warehousing and Star Schemas

ISBN: 0130325848
EAN: 2147483647

Year: 2003
Pages: 79

Authors: Bert Scalzo

BUY ON AMAZON

• Main Page
• Table of content
• 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