Oracle數據倉庫最佳實踐培訓
? Oracle數據倉庫最佳實踐培訓
課程大綱：
???????? Introduction
??????? Building?a?Balanced?Hardware?Configuration
????????????? Maintaining?High?Throughput
????????????? Balanced?System
????????????? Components?of?Hardware?Configuration
????????????? Example?of?a?Balanced?System:?4-Node?RAC?Environment
????????????? Data?Warehouse?Hardware?Configuration:?Best?Practices
????????????? Disk?Layout?and?Design
????????????? Implementing?S.A.M.E.?Using?ASM?and?Hardware?Mirroring
??????? Data?Warehouse?Logical?and?Physical?Design
????????????? Data?Warehouse?Models:?3NF?and?Star
????????????? Industry?Best?Practices:?When?to?Use?Each?Model
????????????? The?Typical?Blueprint?of?Physical?Layers?in?a?Data?Warehouse?Environment
????????????? Optimizing?3rd?Normal?Form:?Power,?Partitioning,?Parallelism
????????????? Partitioning?Strategies?Example:?Composite?Range-Hash?Partitioning
????????????? Partition?Pruning
????????????? Partition?Wise?Join
????????????? Optimizing?Star?Queries:?Star?Transformation
??????? Loading?Data:?Best?Practices
????????????? Loading?Data?into?the?Warehouse
????????????? The?Three?Layers?of?ETL
????????????? Data?Loading?Methods?in?a?Data?Warehouse
????????????? Loading?Data?from?Flat?Files?into?the?Data?Warehouse?Using?External?Tables
????????????? Pre-Processing?in?an?External?Table
????????????? Using?Direct?Path?Load
????????????? Partition?Exchange?Loading
????????????? Tips?for?Data?Loading:?File?Size?and?Formats,?Compression,?and?Statistics
??????? Managing?the?System?Workload?and?Resources
????????????? System?Management:?Keeping?the?Lights?On?for?Your?Data?Warehouse
????????????? Scanning?a?Table?in?Parallel
????????????? SQL?Parallel?Execution:?Overview
????????????? Parallel?Execution?In?Action
????????????? General?Rules?on?When?to?Use?Parallel?Execution
????????????? Workload?Monitoring?Using?(G)V$?Views?or?Oracle?EM?11g
????????????? Oracle?Resource?Manager
????????????? Gathering?Statistics

? ?