Common Warehouse Metamodel

from Wikipedia, the free encyclopedia

The Common Warehouse Metamodel ( CWM ) is a standard developed by the Object Management Group (OMG) for the description, access and exchange of metadata occurring in the data warehouse process . It is intended to enable interoperability between different data warehouse systems and tools.

With the help of the CWM, for example, the data schemes of source and target databases used in the ETL process and the transformations taking place between them can be described. It also allows the definition of mapping rules between the physical model of a data warehouse and the logical models based on it, such as that of an OLAP tool.

The Common Warehouse Metamodel uses the Unified Modeling Language as the notation language and core of its own metamodel. Metadata descriptions created can be exchanged with the XML language XML Metadata Interchange (XMI) , or can be made accessible to various programming languages via the intermediate step of an Interface Definition Language (IDL) .


  • J.Poole, D.Chang, D.Tolbert, D.Mellor: Common Warehouse Metamodel , John Wiley & Sons, 2002
  • J.Poole, D.Chang, D.Tolbert, D.Mellor: Common Warehouse Metamodel Developer's Guide , Wiley Publishing, 2003

Web links