1/15

Contents

Beta Draft: 2012-07-16

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Part I Building Your Data Warehouse

1 Introduction to Data Warehousing Concepts

• About This Guide
  • What This Guide Is Not
• What Is a Data Warehouse?
  • The Key Characteristics of a Data Warehouse
  • Common Oracle Data Warehousing Tasks
• Concepts Illustrated in This Guide

Part II Oracle's Data Warehouse Architecture

2 Data Warehouse Reference Architecture

• About Oracle's Data Warehouse Reference Architecture
  • How Requirements are Evolving
  • Requirements of a Reference Architecture
  • Packaged Applications and the Reference Architecture
• About Data Sources
• About Data Warehouse Layers
  • Staging Data Layer
  • Foundation Data Layer
  • Access and Performance Layer
• About Business Intelligence Tools
• About ETL and the Data Loading Process
• About Security
• About Information Provisioning Process

Part III Modeling

3 Data Warehousing Logical Design

• Logical Versus Physical Design in Data Warehouses
• Creating a Logical Design
  • Comparing Schema Design Approaches
• About Third Normal Form Schemas
  • About Normalization
  • Levels of Normalization
• About Star Schemas
  • Facts and Dimensions
    • Fact Tables
    • Dimension Tables
  • Design Concepts in Star Schemas
    • Data Grain
    • Working with Multiple Star Schemas
    • Conformed Dimensions
    • Conformed Facts
    • Surrogate Keys
    • Degenerate Dimensions
    • Junk Dimension
    • Embedded Hierarchy
    • Factless Fact Tables
    • Slowly Changing Dimensions
  • About Snowflake Schemas
• About Data Warehousing Objects
  • Data Warehousing Objects: Fact Tables
    • Requirements of Fact Tables
  • Data Warehousing Objects: Unique Identifiers
  • Data Warehousing Objects: Relationships
  • Example of Data Warehousing Objects and Their Relationships

4 Data Warehousing Physical Design

• Moving from Logical to Physical Design
• About Physical Design
  • Physical Design Structures
  • Tablespaces
  • About Partitioning
    • Basic Partitioning Strategies
    • Index Partitioning
    • Partitioning for Manageability
    • Partitioning for Performance
    • Partitioning for Availability
  • Views
  • Integrity Constraints
  • Indexes and Partitioned Indexes
  • Materialized Views
  • Dimensions
    • Hierarchies
    • Typical Dimension Hierarchy
• About Compression

Part IV Data Warehouse Deployment Considerations

5 Introduction to Exadata

• Balanced Hardware Configuration
  • About Orion
  • About Disk Layout
• About Oracle Exadata
• Exadata Database Machine Architecture
  • Database Server Software
  • Exadata Smart Scan Processing
    • Smart Scan Predicate Filtering
    • Smart Scan Column Filtering
    • Smart Scan Join Processing
    • Smart Scan Processing of Encrypted Tablespaces and Columns
    • Storage Indexing
    • Offload of Data Mining Model Scoring
    • Other Exadata Smart Scan Processing
    • Exadata Smart Memory Scans
  • About Hybrid Columnar Compression
  • Exadata Smart Flash Cache Features
  • I/O Resource Management with Exadata
  • Quality of Service (QoS) Management with Exadata
  • Conclusion

6 ODI

• About ODI
  • ODI Component Architecture
  • Smart Export and Import Feature
• Simplifying the Complexity of Data Integration
• E-LT Architecture for High Performance
• High-Productivity Designer for Data Integration
  • Enterprise Deployment for High Availability and Scalability
  • Unified Administration and Management
  • Knowledge Modules Provide Flexibility and Extensibility
    • Incremental Updates
    • Slowly Changing Dimension
  • Load Plans
• Benefits of E-LT Combined with a Business-Rule Driven Approach

7 Information Access

• About Information Access
• Industry Data Models
  • Oracle Airline Data Model
  • Oracle Communications Data Model
  • Oracle Retail Data Model
• Data Mining
  • What is Data Mining?
    • Data Mining and Data Warehousing
    • Asking the Right Questions
    • Data Mining in the Database Kernel
• OLAP
  • Business Model in the Oracle Database
  • Oracle OLAP in the Oracle Database
  • Direct SQL Query of the Cube
    • Summary Management With Cube-Organized Materialized Views
    • Improving the Business Intelligence Solutions You Already Own
    • Centralized Management of Key Business Intelligence Assets
  • Managing Cubes
• About R Enterprise
  • R Enterprise Architecture
• OBI Enterprise Edition

Index