Common Warehouse Metamodel

From Wikipedia, the free encyclopedia

For other uses of "CWM", see CWM (disambiguation).

The Common Warehouse Metamodel (CWM) is a specification for modeling metadata for relational, non-relational, multi-dimensional, and most other objects found in a data warehousing environment. In addition, 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 whether the new QVT recommendation proposed by OMG makes this facility redundant since it has not yet been applied to the field of data engineering.

1 Vendors that claim to support CWM
2 See also
3 References
4 External links

[edit] Vendors that claim to support CWM

Hyperion
IBM
IKAN CWD4ALL, a CWM compliant database modeling and design tool
Meta Integration Technology (MITI)
SAS SAS adheres to the Object Management Group’s Common Warehouse Metamodel (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...[1]
Oracle Oracle Warehouse Builder
Pentaho Pentaho Open Source Business Intelligence Project has recently added "Pentaho Metadata" wich supports CWM
Informatica, an ETL tool with a Metadata extension (Metadata Manager formerly known as SuperGlue). Informatica is one of the members of the OMG

[edit] See also

[edit] References

The Common Warehouse Metamodel: An Introduction to the standard for Data Warehouse Integration by John Poole, Dan Chang, Doublas Tolbert, and David Mellor, OMG Press, 2002 ISBN 0-471-20052-2