les12资料参考 学习.pptVIP

Data Warehouse Implementation Considerations Objectives After completing this lesson, you should be able to do the following: Describe the project management plan (PMP) Specify the requirements for the implementation Describe the metadata repository, technical architecture, and other considerations Describe post-implementation change management considerations Project Management Develop a project management plan (PMP) with: Purpose Scope Technical architecture Data warehouse design Data quality and data acquisition Data access and security Objectives Goals and success factors Approach Implementation methods Administration Control and reporting Project tasks, work products, and milestones Requirements Specification or Definition Conform to the detailed business and system objectives. Review the initial data model. Define requirement standards and guidelines. Define data access requirements. Define reporting requirements. Define security requirements. Data access Reporting Portal Logical, Dimensional, and Physical Data Models Define logical model. Identify entities, relationships between them, and cardinality. Define dimensional model. Identify facts, dimensions, and hierarchies. Design time dimension. Define physical model. Document all themodels. Data Warehouse Architecture Define technical architecture. Define functional architecture. Decide which tools to use: For data modeling For database design For extraction, transformation, and loading (ETL) For reporting, and so on Decide which Oracle Database features to leverage: Partitioning Bitmap indexes, bitmap join indexes Materialized views Parallelism, and so on ETL Considerations Select the right ETL tools. Identify the extraction techniques to be used. Identify the types of data transformations needed, and also identify the techniques. Identify the tables to be loaded for the initial load. Load the dimension and fact tables. Reporting Considerations Identify the common reports to be generated by the syst