Common warehouse metamodel cwm
Download
1 / 14

Common Warehouse Metamodel (CWM) - PowerPoint PPT Presentation


  • 135 Views
  • Uploaded on

Common Warehouse Metamodel (CWM). Torben Bach Pedersen. Metadata Integration Using Bridges. [n*(n-1)/2] udvekslinger (uden struktureret metadata skal det gøres i hånden ) Samme argument for data ved DMs uden centralt DW. Operational Data Store. ETL. Data Warehouse. Data Mart. OLAP.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Common Warehouse Metamodel (CWM)' - senona


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Common warehouse metamodel cwm

Common Warehouse Metamodel (CWM)

Torben Bach Pedersen


Metadata integration using bridges
Metadata Integration Using Bridges

  • [n*(n-1)/2] udvekslinger (uden struktureret metadata skal det gøres i hånden)

  • Samme argument for data vedDMs uden centralt DW

Operational

Data Store

ETL

Data

Warehouse

Data

Mart

OLAP

ODS

Metadata

ETL

Metadata

DW

Metadata

DM

Metadata

OLAP

Metadata

BIT netværksmøde 19. september 2005


Metadata integration using cwm adapters
Metadata Integration Using CWM Adapters

  • Kun n udvekslinger

  • Som for data med centralt DW

Operational

Data Store

ETL

Data

Warehouse

Data

Mart

OLAP

ODS

Metadata

ETL

Metadata

DW

Metadata

DM

Metadata

OLAP

Metadata

CWM

(common metamodels,

interchange formats, and APIs)

BIT netværksmøde 19. september 2005


Cwm common warehouse metamodel
CWM (Common Warehouse Metamodel)

  • An OMG standard for metadata interchange in the data warehousing and business intelligence domain.

    • Provides a common language (metamodel) for describing metadata.

    • Provides an XML-based facility for interchanging metadata.

    • Provides APIs for accessing metadata.

  • Extends the OMG’s metamodeling architecture to include data warehousing and business intelligence domain concepts.

  • Supports the OMG’s model-driven approach to software specification and system integration

BIT netværksmøde 19. september 2005


Omg metamodeling architecture
OMG Metamodeling Architecture

BIT netværksmøde 19. september 2005


Cwm layered package architecture
CWM Layered Package Architecture

Warehouse

Process

Warehouse

Operation

Management

Transformation

OLAP

Data

Mining

Information

Visualization

Business

Nomenclature

Analysis

Object

(Core+Behavioral+

Relationships)

Relational

Record

Multi-

Dimensional

XML

Resource

Business

Information

Data

Types

Expressions

Keys

Index

Type

Mapping

Software

Deployment

Foundation

Core

Behavioral

Relationships

Instance

Object Model

BIT netværksmøde 19. september 2005


Table column and view rltnl
Table, Column and View (Rltnl)

BIT netværksmøde 19. september 2005


Xmi overview
XMI Overview

  • XML Metadata Interchange

  • An XML vocabulary for

    • interchanging metadatain software systems

  • Specify a precise MOF to XML mapping

    • Enables automatic generation of XML documents that can be validated with generated DTDs

    • Allows interchange of any MOF based metamodel and corresponding models/metadata

      • CWM metamodel

      • CWM based metadata

BIT netværksmøde 19. september 2005


XMI Example: UML Model

CarModel.xml

Car

make

owns

owner

Person

model

<Class name="

Car

">

<Class.ownedElements>

drive()

<Attribute name="

make

"/>

<Attribute name="

model

"/>

<Operation name="

drive

"/>

</Class.ownedElements>

Convertible

</Class>

BIT netværksmøde 19. september 2005


Cwm facts
CWM facts

  • CWM stiftet i

    • IBM, Oracle, Unisys, Hyperion, Genesis, NCR, …

  • Initiel konkurrent: Meta Data Coalition (MDC)

    • BMC, Informatica, CA, NCR, Microsoft, SAS,…

    • Open Information Model (OIM)

    • Annoncerer fusion med CWM i september 2000

  • Version 1.0

    • Februar 2001

BIT netværksmøde 19. september 2005


Cwm status
CWM status

  • Version 1.1

    • Marts 2003 (nyeste)

    • De fleste store leverandører (vil i hvert fald gerne…)

    • 576 sider basisstandard

    • 218 sider udvidelser (IMS, COBOL, Express, Essbase,…)

  • Meget aktiv i 2001-2003

    • Leverandører hopper på

    • CWM Enablement showcases 2001+2002

  • Ikke meget aktivitet siden

    • Langsom standardiserings/adapterings process for V1.1

  • SAS og Informatica er nu med på CWM vognen

  • Microsoft har ikke vist noget endnu

BIT netværksmøde 19. september 2005


Cwm leverand r support
CWM Leverandør support

  • IBM

    • Metadata imp/export for Warehouse Manager,DB2 UDB+Connect

  • Hyperion

    • Essbase metadata import/export

  • Oracle

    • Oracle 9i+Warehouse Builder 3i og frem

  • SAS

    • Support for CWM i SAS System 9

  • Meta Integration

    • Meta Integration Model Bridge understøtter mange værktøjer

  • Business Objects

    • Data Integrator 6.0 data extraction and transformation værktøj

  • Informatica

    • Metadata Exchange for Data Models: bi-directional meta data exchange between Informatica Repository og CWM-baserede relationelle skemaer

BIT netværksmøde 19. september 2005


Cwm enablement showcase 2001
CWM Enablement Showcase 2001

BIT netværksmøde 19. september 2005


Cwm showcase 2002
CWM Showcase 2002

BIT netværksmøde 19. september 2005


ad