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@unisys.com

2. 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

3. The CWM Metamodel

4. 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

5. 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

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. 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

9. CWM Extension Packages • Extension Techniques • Metamodel specialization • XMI extensions • UML tagged values

10. 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

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”?