oracle数据仓库最佳实践白皮书新.pdf

Best practices for a Data Warehouse on Oracle Database 11g An Oracle White Paper September 2008 NOTE: The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle. Best Practices for a Data Warehouse on Oracle Database 11g Page 2 Best Practices for a Data Warehouse on Oracle Database 11g Note: 2 Executive Summary 4 Introduction 4 Balanced Configuration 5 Interconnect 6 Disk Layout 7 Logical Model 9 Physical Model 10 Staging layer 10 Efficient Data Loading 11 Foundation layer - Third Normal Form 14 Optimizing 3NF 15 Access layer - Star Schema 19 Optimizing Star Queries 20 System Management 22 Workload Management 22 Workload Monitoring 26 Resource Manager 31 Optimizer Statistics Management 32 Initialization Parameter 34 Memory allocation 34 Controlling Parallel Execution 36 Enabling efficient IO throughput 36 Star Query 37 Conclusion 37 Best Practices for a Data Warehouse on Oracle Database 11g Page 3 Best practices for a Data Warehouse on Oracle Database 11g EXECUTIVE SUMMARY Increasingly