Les17 Managing the Data Warehouse 数据仓库英文oracle99版 教学课件.ppt

Managing the Data Warehouse Overview Project Management (Methodology, Maintaining Metadata) DefiningDW Concepts Terminology Planningfor a SuccessfulWarehouse AnalyzingUser QueryNeeds Choosing aComputingArchitecture Modeling the DataWarehouse PlanningWarehouseStorage ETT(Building theWarehouse) Meeting aBusinessNeed SupportingEnd UserAccess Managing the Data Warehouse Objectives After completing this lesson, you should be able to do the following: Develop a plan for managing the transition from development to implementation Identify challenges pertaining to the growth of the data warehouse Describe backup and archive mechanisms Identify data warehouse performance issues Managing the Transition to Production Promoting support for change Pilot versus large-scale implementation Documentation Testing Training Postimplementation support Maintaining the warehouse Promoting Support for Change To Support Not to Support Management Competitiveness Fear of change Business benefit Risk avoidance Developers New skills Outdated skills Leading edge End Users Faster flexible system Disruption Improved tools Change Increased workload Methods for Promoting Support Awareness Feedback Information Skills Education Direction Control Choosing Between Pilot and Large-Scale Implementation Pilot Large-Scale Implementation The Warehouse Pilot Demonstrates benefits to: Management Users IT staff Relevant to the business Low technical risk Small and feasible Anticipates increased use Focused on an initial business issue Remains in context Piloting the Warehouse Piloting the warehouse is a vital part of the implementation. The pilot must cover all aspects of implementation and ensure user involvement at every step in the life cycle. The pilot fulfills a number of tasks: It enables the designers to prove the model, the data, and the access tools and evaluate tests against acceptance criteria. It enables the users to see how ea