Cwm a model based architecture for data warehouse interchange
This presentation is the property of its rightful owner.
Sponsored Links
1 / 12

CWM: A Model-based Architecture For Data Warehouse Interchange PowerPoint PPT Presentation


  • 61 Views
  • Uploaded on
  • Presentation posted in: General

CWM: A Model-based Architecture For Data Warehouse Interchange. Doug Tolbert Pacific Development Lab Unisys Corporation Mission Viejo, CA [email protected] Submitters IBM Unisys Oracle NCR Hyperion UBS AG Genesis Development Dimension EDI OMG Specs: http://www.omg.org

Download Presentation

CWM: A Model-based Architecture For Data Warehouse Interchange

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


Cwm a model based architecture for data warehouse interchange

CWM: A Model-based Architecture For Data Warehouse Interchange

Doug Tolbert

Pacific Development Lab

Unisys Corporation

Mission Viejo, CA

[email protected]


Cwm submitters supporters

Submitters

IBM

Unisys

Oracle

NCR

Hyperion

UBS AG

Genesis Development

Dimension EDI

OMG Specs:http://www.omg.org

CWM Info:http://www.cwmforum.org

Supporters

Deere & Co.

Sun Microsystems

Hewlett-Packard

Data Access Technologies

InLine Software

Aonix

Hitachi

CWM Submitters & Supporters


Cwm a model based architecture for data warehouse interchange

The CWM Metamodel


Omg metamodel architecture

M

I

DD

L

E

W

ARE

MOF: Class, Attribute,

Operation,

Association

Meta-metamodel

Layer (M3)

UML: Class, Attribute

CWM: Table, Column

ElementType, Attribute

Metamodel

Layer(M2)

AP

P

L

I

C

A

T

I

O

N

Metadata/Model

Layer(M1)

Stock: name, price

User Data/Object

Layer (M0)

<Stock name=“IBM”

price=“112”/>

OMG Metamodel Architecture

  • Standard OMG Components

  • Modeling Language: UML

  • Metadata Interchange: XMI

  • Metadata API:

    MOF IDL Mapping


Cwm a model based architecture for data warehouse interchange

Warehouse

Process

Warehouse

Operation

Management

Transformation

OLAP

Data

Mining

Information

Visualization

Business

Nomenclature

Analysis

Object

(UML)

Relational

Record

Multi

Dimensional

XML

Resource

Business

Information

Data

Types

Expressions

Keys

Index

Type

Mapping

Software

Deployment

Foundation

UML 1.3

(Foundation, Behavioral_Elements, Model_Management)

The CWM Metamodel


Cwm a model based architecture for data warehouse interchange

CWM Relational Metamodel (Partial)


Cwm a model based architecture for data warehouse interchange

Transformation

X-Form

  • General mechanism describing data movement and lineage

  • Generic transformations from any physical object to any other physical object

  • Maps logical structures and concepts in the warehouse onto physical implementation

  • Provides for multiple physical implementations of logical structures and concepts

Conceptual Object

Conceptual Object

Mapping

Mapping

X-Form

Logical Object

Logical Object

Mapping

Mapping

Physical Object

Physical Object

X-Form


Cwm a model based architecture for data warehouse interchange

Object

Oriented

Relational

Record

XML

Multi-dimensional

CWM Data Resource Matrix

Resource

Intent

Extent

Package

Class

Attribute

Extent

Object

DataValue

Catalog/Schema

Table

Column

RowSet

Row

Column

Value

RecordFile

RecordDef

Field

RecordSet

Record

Field

Value

Schema

Dimension

Dimensioned

Object

MemberSet

Member

Member

Value

Schema

ElementType

Attribute

Document

Element

DataValue


Cwm a model based architecture for data warehouse interchange

CWM Extension Packages

  • Extension Techniques

  • Metamodel specialization

  • XMI extensions

  • UML tagged values


Cwm package architecture

org.omg

UML

CWM

Foundation

<<metamodel>> DataTypes

<<metamodel>> TypeMapping

<<metamodel>> KeysIndexes

<<metamodel>> Expressions

<<metamodel>> BusinessInformation

<<metamodel>> SoftwareDeployment

Resource

<<metamodel>> Relational

<<metamodel>> Record

<<metamodel>> Multidimensional

<<metamodel>> XML

Analysis

<<metamodel>> Transformation

<<metamodel>> Olap

<<metamodel>> BusinessNomenclature

<<metamodel>> DataMining

<<metamodel>> InformationVisualization

Management

<<metamodel>> WarehouseProcess

<<metamodel>> WarehouseOperation

CWMX

CWM Package Architecture

  • Modular Design

    • Minimum dependencies

      • Cross package services provided by links to UML

    • Avoid subpackages

    • Reduced complexity, improved understanding

    • Use only the packages you need


Cwm demo

CWM Demo


Cwm timeline

CWM Timeline

September 1998

  • RFI issued

    January 1999

  • First team meeting

    November 1999

  • Initial Submission

  • Proof of Concept Demo

    March 2000

  • Final Submission

  • Adoption by OMG Tech Committee & Architecture Board

  • June 2000

    • Fax vote ends

    • Board of Directors vote

  • September 2000

    • FTF completes

    • Interoperability Showcase

    • Usage Guide

    • First OMG “Available Specification”?


  • Login