les05资料参考 学习.pptVIP

Database Sizing, Storage, Performance, and Security Considerations Objectives After completing this lesson, you should be able to dothe following: Explain data warehouse sizing techniques and test load sampling at a high level Describe data warehouse partitioning methods Describe indexing types and strategies Explain parallelism in data warehouse operations Explain the importance of security in data warehouses Identify the tools and technologies provided by Oracle Lesson Agenda Database sizing Storage and performance considerations Partitioning Indexing Optimizing star queries Parallelism Summary data Exadata storage server Security in data warehouses Sizing the Database and Other Storage Requirements Sizing influences capacity planning and systems environment management. Sizing is required for: The database Other storage areas Sizing is not an exact science. Techniques vary from implementation to implementation. Estimating the Database Size Estimate the size of each row in the fact table. Determine the grain of each dimension and estimate the number of entries in the finest level. Multiply the number of rows of all dimensions and multiply the result by the fact table row size. Determine whether the fact table is sparse or dense and estimate the reduction or increase in size. Validating Database Size Assumptions Testing Load Sampling Analyze a representative sample of the data chosen using proven statistical methods. Ensure that the sample reflects: Test loads for different periods Day-to-day operations Seasonal data and worst-case scenarios Indexes and summaries Oracle Database Architectural Advantages Real Application Clusters (RAC) and Cache Fusion Self-managing in critical areas Data Guard and Recovery Manager Exadata possibly enables the database to offload SQL processing to the storage server. Lesson Agenda Database sizing Storage and performance considerations Partitioning Indexing Optimizing star queries Parallelism Summary data Exadata storage server Se