CWM: A Model-based Architecture For Data Warehouse Interchange

1
CWM A Model-based Architecture For Data
Warehouse Interchange

• Doug Tolbert
• Pacific Development Lab
• Unisys Corporation
• Mission Viejo, CA
• doug.tolbert_at_unisys.com

2
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

3
The CWM Metamodel
4
OMG Metamodel Architecture

• Standard OMG Components
• Modeling Language UML
• Metadata Interchange XMI
• Metadata API
• MOF IDL Mapping

5
The CWM Metamodel
Counts Classes Associations
CWM 157 115
CWMX 130 77
Total 287 192
6
CWM Relational Metamodel (Partial)
7
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
8
CWM Data Resource Matrix
Intent
Extent
Resource
Class
Package
Attribute
Object
Extent
DataValue
Catalog/Schema
Table
Column
RowSet
Row
Column Value
RecordFile
Field
RecordDef
RecordSet
Field Value
Record
Dimension
Dimensioned Object
Schema
Member
Member Value
MemberSet
Schema
Attribute
ElementType
Document
Element
DataValue
9
CWM Extension Packages

• Extension Techniques
• Metamodel specialization
• XMI extensions
• UML tagged values

10
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

11
CWM Demo
12
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?