Main Page

  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

Oracle DBAs finally have a definitive guide to every aspect of designing, constructing, tuning, and maintaining star schema data warehouses with Oracle 8i and 9i. Bert Scalzo, one of the world's leading Oracle data warehousing experts, offers practical, hard-won lessons and breakthrough techniques for maximizing performance, flexibility, and manageability in any production environment. Coverage includes:

  • Data warehousing fundamentals for DBAs--including what a data warehouse isn't

  • Planning software architecture: business intelligence, user interfaces, Oracle versions, OS platforms, and more

  • Planning hardware architecture: CPUs, memory, disk space, and configuration

  • Radically different star schema design for radically improved performance

  • Tuning ad-hoc queries for lightning speed Industrial-strength data loading techniques

  • Aggregate tables: maximizing performance benefits, minimizing complexity tradeoffs

  • Improving manageability: The right ways to partition

  • Data warehouse administration: Backup/recovery, space and extent management, updates, patches, and more

  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

    The Prentice Hall PTR Oracle Series
    About Prentice Hall Professional Technical Reference
    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