Editing Common warehouse metamodel

{{Short description|Specification for modeling in data warehouse}}
{{Use dmy dates|date=October 2017}}
The '''common warehouse metamodel''' ('''CWM''') defines a specification for modeling [[metadata]] for [[RDBMS|relational]], non-relational, [[Multidimensional database|multi-dimensional]], and most other objects found in a [[Data warehouse|data warehousing]] environment.  The specification is released and owned by the [[Object Management Group]], which also claims a trademark in the use of "CWM".<ref>[http://www.omg.org/legal/tm_list.htm OMG Trademarks and Logos]</ref>

== Overview ==
The CWM specifies interfaces that can be used to enable interchange of warehouse and business intelligence metadata between warehouse tools, warehouse platforms and warehouse metadata repositories in distributed heterogeneous environments. CWM is based on three standards:
* [[Unified Modeling Language|UML]] – Unified Modeling Language, an [[Object Management Group|OMG]] modeling standard
* [[Meta-Object Facility|MOF]] – Meta Object Facility, an [[Object Management Group|OMG]] metamodeling and metadata repository standard
* [[XML Metadata Interchange|XMI]] – XML Metadata Interchange, an [[Object Management Group|OMG]] metadata interchange standard

CWM models enable users to trace the lineage of data – CWM provides objects that describe where the data came from and when and how the data was created.  Instances of the metamodel are exchanged via [[XML Metadata Interchange]] (XMI) documents.

Initially, CWM contained a local definition for a data translation facility. It is not clear how the [[QVT]] final adopted specification<ref>{{Cite web |url=http://www.omg.org/docs/ptc/05-11-01.pdf |title=MOF QVT Final Adopted Specification |access-date=10 May 2007 |archive-url=https://web.archive.org/web/20070303082905/http://www.omg.org/docs/ptc/05-11-01.pdf |archive-date=3 March 2007 |url-status=dead }}</ref> will affect CWM.

== Support for the CWM ==

=== Submitters of CWM specification ===
While the Object Management Group owns the standard for CWM, some companies are considered co-submitters of the CWM specification.  The following companies were listed as co-submitters to the v1.1 specification:
* [[IBM|International Business Machines Corporation]]
* [[Unisys Corporation]]
* [[NCR Corporation]]
* [[Hyperion Solutions Corporation]]
* [[Oracle Corporation]]
* [[UBS AG]]
* Genesis Development Corporation
* Dimension EDI

=== Compliance with the CWM specification ===
Software vendors claiming CWM support differ in the degree to which they comply with CWM.  Some were co-submitters of the specification, and are actively using the OMG trademark in marketing literature.  Other vendors have expressed support for CWM or claim they have products that are "CWM-compliant."

Questions about compliance are addressed within the specification itself.  Chapter 18 in both the 1.0 and 1.1 specification list required and optional compliance points.

The Object Management Group has a list of CWM implementations, but it is unclear how this list is maintained.<ref>[http://www.omg.org/technology/cwm/ Catalog Of OMG Modeling And Metadata Specifications]</ref>

===Interoperability of CWM tools===
Compliance with the CWM specification does not guarantee tools from different vendors will integrate well, even when they are "CWM-compliant". The OMG addressed some of these issues by releasing patterns and best practices to correct these problems in a supplementary specification, [[CWM Metadata Interchange Patterns]]<ref>{{Cite web|url=http://www.omg.org/mda/specs.htm#CWM|title=MDA Specifications &#124; Object Management Group}}</ref>

==Vendors supporting CWM==

===CWM implementations identified by OMG===
These vendors have been identified as having a CWM implementation or have active projects to support CWM.
*[[IBM]]
*[[Informatica]] produces Intelligence Data Platform with PowerCenter, a data integration tool with a metadata extension Enterprise Data Catalog (EDC) (metadata manager formerly known as SuperGlue is replacing by EDC). Informatica is one of the members of the OMG
*[[Oracle Corporation]] Oracle Warehouse Builder and [[Oracle SQL Developer Data Modeler]] (formerly known as IKAN CWM4ALL)
*[[Pentaho]]<ref>{{Cite web|url=http://wiki.pentaho.com/display/ServerDoc2x/Pentaho+Metadata+Editor|title = Pentaho Community Wiki}}</ref>
*[[Chemnitz University of Technology#Spin offs|prudsys AG]] – XELOPES library for embedded data mining
*[[SAS Institute|SAS]] SAS adheres to the Object Management Group's CWM as the interoperability and interchange standard. An alliance between SAS and Meta Integration Technology Inc. (MITI) enables SAS to provide bridges for sharing and exchanging metadata with more than 40 design tool and repository vendors<ref>{{Cite web |url=http://www.sas.com/technologies/bi/appdev/base/metadatasrv_factsheet.pdf |title=Archived copy |access-date=4 January 2006 |archive-url=https://web.archive.org/web/20080517044108/http://www.sas.com/technologies/bi/appdev/base/metadatasrv_factsheet.pdf |archive-date=17 May 2008 |url-status=dead }}</ref>

===Other vendors supporting CWM===
The following products or companies have claimed CWM support, but are not listed by OMG as having a CWM implementation. In some cases, the vendor may have implemented the v1.0 specification, which was replaced by the v1.1 specification. Refer to the software vendor to determine if the product is compliant with CWM or merely supports a subset of the required portions of the specification.
*[[Cognos]], now a division of [[IBM]], is listed as a supporter of CWM in the v1.1 specification.  Cognos product literature claims support for "Common Warehouse Model (CWM)" but never mentions an actual [[Object Management Group|OMG]] specification.<ref>http://www.cognos.com/pdfs/issue_papers/ip_integration_with_c8bi.pdf [http://www.cognos.com/pdfs/whitepapers/wp_metadata_administration_with_cognos_reportnet.pdf] According to the Cognos support site, the company actively supports only OMG CWM 1.0 specification. http://support.cognos.com/en/support/products/cognos82_software_environments.html] .</ref>
*[[Hyperion Solutions]], now a division of [[Oracle Corporation]]
* InQuisient fully supports version 1.1 in its data repository.
* [[Pentaho]] Pentaho Open Source Business Intelligence Project has recently{{when|date=November 2023}} added "Pentaho Metadata" which supports CWM

== See also ==
* [[Data Warehouse]]
* [[Metadata]]
* [[Metadata registry]]
* [[Metadata standards]]
* [[Extensible Markup Language]] (XML)
* [[XML Metadata Interchange]] (XMI)
* [[Domain Specific Language]] (DSL)
* [[Domain-specific modeling]] (DSM)
* [[Model-based testing]] (MBT)
* [[Meta-modeling]]
* [[Unified Modeling Language]] (UML)
* [[ATLAS Transformation Language]] (ATL)
* [[VIATRA|Visual Automated Model Transformations]] (VIATRA) framework
* [[Object Constraint Language]] (OCL)
* [[Model Transformation Language]] (MTL)
* [[Meta-Object Facility]] (MOF)
* [[QVT|Query/View/Transformation]] (QVT) languages

== References ==
{{reflist}}

== Further reading ==
* John Poole, Dan Chang, Douglas Tolbert, and David Mellor (2002). ''The Common Warehouse Metamodel: An Introduction to the standard for Data Warehouse Integration''.  OMG Press (John Wiley & Sons), 2002 {{ISBN|0-471-20052-2}}
* John Poole, Dan Chang, Douglas Tolbert, and David Mellor (2003). ''Common Warehouse Metamodel Developer's Guide''.  OMG Press (John Wiley & Sons), 2003 {{ISBN|978-0-471-20243-1}}

== External links ==
* CWM Forum website
* [http://www.omg.org/cwm OMG CWM Technology]
* [http://www.omg.org/cwm OMG CWM Specification]

[[Category:Data warehousing products]]