Les14 Leaving a Metadata Trail 数据仓库英文oracle99版 教学课件.ppt

Leaving a Metadata Trail 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: Define warehouse metadata, its types, and its roles in a warehouse environment Develop a metadata strategy Describe in detail each type of warehouse metadata List tools for managing metadata Describe the Oracle Common Warehouse Metadata architecture (CWM) Defining Warehouse Metadata Data about warehouse data and processing Vital to the warehouse Used by everyone Metadata The Key to Understanding Warehouse Information Specifies data location Manages data Aids use of information Describes the data Documents the development process Provides a record of changes Records enhancements over time The Key to Understanding Metadata Users IT developers End users Warehouse Metadata repository Operational ETT End user Types of Metadata End user: Key to a good warehouse Navigation aid Information provider ETT: Maps structure Source and target information Transformations Context Operational: Load, management, scheduling processes Performance Developing a Metadata Strategy Define a strategy to ensure high-quality metadata useful to users and developers. Primary strategy considerations: Define goals and intended use. Identify target users. Choose tools and techniques. Choose the metadata location. Manage the metadata. Manage access to the metadata. Integrate metadata from multiple tools. Manage change. Defining Metadata Goals and Intended Usage Define clear goals. Identify requirements. Identify intended usage. Metadata Identifying Target Metadata Users Who are the metadata users? De