LES13 Transportation Refreshing Warehouse Data 数据仓库英文oracle99版 教学课件.ppt

Transportation: Refreshing Warehouse Data 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: Describe methods for capturing changed data Explain techniques for applying the changes Discuss techniques for purging and archiving data Outline final tasks, such as publishing the data, controlling access, and automating processes List tools for transporting data into the warehouse Developing a Refresh Strategy for Capturing Changed Data Consider load window Identify data volumes Identify cycle Know the technical infrastructure Plan a staging area Determine how to detect changes T1 T2 T3 Operational databases User Requirements and Assistance Users define the refresh cycle IT balances requirements against technical issues Document all tasks and processes Employ user skills T1 T2 T3 Operational databases Load Window Time available for entire ETT process Plan Test Prove Monitor 0 3 am 6 9 12 pm 3 6 9 12 User Access Period Load Window Load Window Load Window Plan and build processes according to a strategy. Consider volumes of data. Identify technical infrastructure. Ensure currency of data. Consider user access requirements first. High availability requirements may mean a small load window. 0 3 am 6 9 12 pm 3 6 9 12 User Access Period Scheduling the Load Window 0 3 am 1 File 1 File 2 Receive data Control