Oracle DBA Guide to Data Warehousing and Star Schemas
Oracle DBA Guide to Data Warehousing and Star Schemas
ISBN: 0130325848
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 79
Pages: 79
Authors: Bert Scalzo
- 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
Oracle DBA Guide to Data Warehousing and Star Schemas
ISBN: 0130325848
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 79
Pages: 79
Authors: Bert Scalzo