CWM A Modelbased Architecture For Data Warehouse Interchange

CWM: A Model-based Architecture For Data Warehouse Interchange Doug Tolbert Pacific Development Lab Unisys Corporation Mission Viejo, CA doug. tolbert@unisys. com Unisys 1

CWM Submitters & Supporters • Submitters – – – – IBM Unisys Oracle NCR Hyperion UBS AG Genesis Development Dimension EDI • OMG Specs: • CWM Info: Unisys • Supporters – Deere & Co. – Sun Microsystems – Hewlett-Packard – Data Access Technologies – In. Line Software – Aonix – Hitachi http: //www. omg. org http: //www. cwmforum. org 2

The CWM Metamodel Unisys 3

OMG Metamodel Architecture Standard OMG Components üModeling Language: UML üMetadata Interchange: XMI üMetadata API: MOF IDL Mapping M I D D L E W A R E A P P L I C A T I O N Unisys Meta-metamodel Layer (M 3) MOF: Class, Attribute, Operation, Association Metamodel Layer(M 2) UML: Class, Attribute CWM: Table, Column Element. Type, Attribute Metadata/Model Layer(M 1) User Data/Object Layer (M 0) Stock: name, price <Stock name=“IBM” price=“ 112”/> 4

The CWM Metamodel Warehouse Process Management Analysis Transformation OLAP Object (UML) Resource Foundation Counts Classes Associations CWM 157 115 CWMX 130 77 Total 287 192 Unisys Relational Warehouse Operation Data Information Business Mining Visualization Nomenclature Record Multi Dimensional XML Business Data Keys Type Software Expressions Information Types Index Mapping Deployment UML 1. 3 (Foundation, Behavioral_Elements, Model_Management) 5

CWM Relational Metamodel (Partial) Unisys 6

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 Mapping X-Form Logical Object Mapping Physical Object X-Form Unisys 7

CWM Data Resource Matrix Resource Extent Object Oriented Package Class Attribute Extent Object Data Value Relational Catalog/ Schema Table Column Row. Set Row Column Value Record. File Record. Def Field Record. Set Record Field Value Schema Dimensioned Object Member. Set Member Value Schema Element. Type Attribute Document Element Data Value Record Multidimensional XML Unisys Intent 8

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

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 Unisys org. omg UML CWM Foundation <<metamodel>> Data. Types <<metamodel>> Type. Mapping <<metamodel>> Keys. Indexes <<metamodel>> Expressions <<metamodel>> Business. Information <<metamodel>> Software. Deployment Resource <<metamodel>> Relational <<metamodel>> Record <<metamodel>> Multidimensional <<metamodel>> XML Analysis <<metamodel>> Transformation <<metamodel>> Olap <<metamodel>> Business. Nomenclature <<metamodel>> Data. Mining <<metamodel>> Information. Visualization Management <<metamodel>> Warehouse. Process <<metamodel>> Warehouse. Operation CWMX 10

CWM Demo Unisys 11

CWM Timeline September 1998 – RFI issued January 1999 – First team meeting November 1999 – Initial Submission – Proof of Concept Demo March 2000 June 2000 – Fax vote ends – Board of Directors vote September 2000 – – FTF completes Interoperability Showcase Usage Guide First OMG “Available Specification”? – Final Submission – Adoption by OMG Tech Committee & Architecture Board Unisys 12