|
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. The specification is released and owned by the Object_Management_Group, which also claims a trademark in the use of "CWM" [1] Metadata (Greek meta after and Latin data information) are data that describe other data. ...
A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by Edgar F. Codd. ...
It has been suggested that this article or section be merged with Dimensional database. ...
This article or section does not cite any references or sources. ...
Object Management Group (OMG) is a consortium, originally aimed at setting standards for distributed object-oriented systems, and is now focused on modeling (programs, systems and business processes) and model-based standards in some 20 vertical markets. ...
The active version of the CWM specification is v1.1 with a supplementary specification, Common Warehouse Metamodel (CWM) Metadata Interchange Patterns (MIP) that further refines the requirements for tools to smoothly interoperate.
Purpose of CWM The Common Warehouse metamodel 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: - UML - Unified Modeling Language, an OMG modeling standard
- MOF - Meta Object Facility, an OMG metamodeling and metadata repository standard
- XMI - XML Metadata Interchange, an 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. XMI (XML Metadata Interchange) is an Object Management Group standard for exchanging metadata information via XML. It can be used for any metadata whose metamodel can be expressed in MOF. The most common use of XMI is as an interchange format for UML, although it can also be used for...
Initially, CWM contained a local definition for a data translation facility. It not clear how the QVT final adopted specification [2] will affect CWM. In the model-driven architecture, QVT (Queries/Views/Transformations) is a standard for model transformation defined by the Object Management Group. ...
Support for the Common Warehouse Metamodel (CWM)
Submitters of Common Warehouse Metamodel 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: International Business Machines Corporation (known as IBM or Big Blue; NYSE: IBM) is a multinational computer technology and consulting corporation headquartered in Armonk, New York, USA. The company is one of the few information technology companies with a continuous history dating back to the 19th century. ...
Compliance to 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. Others 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. S
The the Object Management Group has a list of CWM implementations, but it is unclear how this list is maintained [3].
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 [4]
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. - 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...[5]
- Oracle_Corporation Oracle Warehouse Builder
- Informatica produces Superglue, an ETL tool with a Metadata extension (Metadata Manager formerly known as SuperGlue). Informatica is one of the members of the OMG
- IBM
- Dimension EDI
- Genesis Development
- PrudSys - XELOPES library for embedded data mining
- UBS
SAS Institute logo SAS Institute Inc. ...
Oracle Corporation (NASDAQ: ORCL) is one of the major companies developing database management systems (DBMS), tools for database development, middle-tier software, enterprise resource planning software (ERP), customer relationship management software (CRM) and supply chain management (SCM) software. ...
Informatica Corporation provides data integration software and services for various businesses, industries and government organizations, including telecommunications, health care, insurance, and financial services. ...
International Business Machines Corporation (known as IBM or Big Blue; NYSE: IBM) is a multinational computer technology and consulting corporation headquartered in Armonk, New York, USA. The company is one of the few information technology companies with a continuous history dating back to the 19th century. ...
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. - Hyperion_Solutions
- Pentaho Pentaho Open Source Business Intelligence Project has recently added "Pentaho Metadata" which supports CWM
- Cognos 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 OMG specification. [[6][7] 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] .
Hyperion Solutions Corporation is a business performance management software company, located in Santa Clara, California, USA. Many of its products are targeted at the Business Intelligence and Business performance management market. ...
Cognos (TSX: CSN, NASDAQ: COGN) is an Ottawa, Ontario based company which makes business intelligence (BI) and performance planning software. ...
Object Management Group (OMG) is a consortium, originally aimed at setting standards for distributed object-oriented systems, and is now focused on modeling (programs, systems and business processes) and model-based standards in some 20 vertical markets. ...
See also This article or section does not cite any references or sources. ...
Metadata (Greek meta after and Latin data information) are data that describe other data. ...
A Metadata Registry is a central place where metadata definitions are stored and maintained. ...
The Extensible Markup Language (XML) is a general-purpose markup language. ...
XMI (XML Metadata Interchange) is an Object Management Group standard for exchanging metadata information via XML. It can be used for any metadata whose metamodel can be expressed in MOF. The most common use of XMI is as an interchange format for UML, although it can also be used for...
A domain-specific language (DSL) is a programming language designed to be useful for a specific set of tasks, in contrast to general-purpose programming languages. ...
Domain-specific modelling (DSM) is a higher level of CASE, a way to model data structures and logic in domain concepts independent from programming languages and thus also syntax details. ...
Model-based testing is software testing in which test cases are derived in whole or in part from a model that describes some (usually functional) aspects of the system under test (SUT). ...
To meet Wikipedias quality standards, this article or section may require cleanup. ...
In the field of software engineering, the Unified Modeling Language (UML) is a standardized specification language for object modeling. ...
ATL is a QVT model tranformation language developed at INRIA. It can be used to do Syntactic or Semantic translation. ...
The VIATRA (VIsual Automated model TRAnsformations) framework is the core of a transformation-based verification and validation environment for improving the quality of systems designed using the Unified Modeling Language by automatically checking consistency, completeness, and dependability requirements. ...
XMI (XML Metadata Interchange) is an OMG standard for exchanging metadata information via XML. It can be used for any metadata whose metamodel can be expressed in MOF. The most common use of XMI is as an interchange format for UML models, although it can also be used for serialization...
Object Constraint Language is a declarative language for describing rules that apply to UML models developed at IBM and now part of the UML standard. ...
// The notion of Model transformation is of central importance to Information Technology. ...
The Meta-Object Facility (MOF), is an Object Management Group (OMG) standard for Model Driven Engineering. ...
In the model-driven architecture, QVT (Queries/Views/Transformations) is a standard for model transformation defined by the Object Management Group. ...
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
External links | 
Feeds |
Contact