OMG CWM to MDS CWM_Metamodel Mapping

The layout of the MDS CWM_Metamodel is shown in Figure 29.

Figure 29: MDS CWM_Metamodel layout

The MDS CWM_Metamodel holds CWM/XMI metadata imported by XML Bridge. The metamodel classes are mostly a subset of the Core, Relational, Keys and Indexes, OLAP, and Transformation packages found in OMG CWM.

Abstract classes Core_ModelElement and Ref_Core_ModelElement are used by the CWM_Metamodel to hold properties common to their subclasses. The remaining classes in the CWM_Metamodel have names resembling their CWM/XMI names that map back to the OMG CWM class-package names.

The following table shows the mapping of the CWM Package classes to the MDS CWM_Metamodel classes. Some of the more prominent attributes for the classes are listed. For a complete list of all MDS CWM_Metamodel classes and their properties, including descriptions, see the metamodel as defined in the XML file, or as viewed in MetaBrowse. CWM_Metamodel Relationships (not shown here) are the natural result of the containment associations found in the CWM.

Table 179: CWM Package class mapping to MDS CWM_Metamodel classes
CWM Package:Class	MDS CWM_Metamodel Class
CWMRDB:Catalog XMI.exporter XMI.exporterVersion Contains elements comprising relational and OLAP models. Note: This class typically holds the root object of the metadata of the tool. See also “CWM:Model” on page 253 and “CWM:Package” on page 254.	CWMRDB_Catalog exporter Shows information related to source XML. exporterVersion Shows information related to source XML. xmlFileName xmlFileName holds the name of the file used to import the object and its descendents.
CWMRDB:Schema Contains elements comprising a relational model.	CWMRDB_Schema catalogName catalogName is a derived property value for storing the name of the catalog owning the schema.
CWMRDB:SQLSimpleType characterMaximumLength typeNumber Data type used with a SQL column. Examples are Integer, Varchar, LOB, CLOB, and so on.	CWMRDB_SQLSimpleType charLength charLength shows the maximum length of character data type associated with table columns, view columns, SQL parameters, and so on. typeNumber Data types in a catalog are assigned unique typeNumber values. This is how Column, SQLParameter, and Measure reference their associated data types.
CWMRDB:Table A materialized Column set.	CWMRDB_Table RDBSchemaName RDBSchemaName is a derived property value to store the name of the schema owning this table.
CWMRDB:Column owner type Column in a result set, a view, or a table.	CWMRDB_Column ownerName Shows the name of associated element owning this column. (For example: table, view, and so on) SQLSimpleTypeName SQLSimpleTypeID ownerType Either table or view. This is in place to aid in searches, as it is derived from existing information. SQLDistinctTypeID SQLSimpleTypeName Shows the Column data type. SQLDistinctTypeName Shows the Column data type. SQLDistinctTypeID
CWMRDB:View CWM:Expression.body A view is a virtual table that doesn't store information itself, but pulls it out of one or more existing tables.	CWMRDB_View queryExpression queryExpressionID queryExpression shows the DML/DDL for the View object.
CWMRDB:Procedure Relational DBMS Stored procedures and functions.	CWMRDB_Procedure procedureExpression Stores the expression body of a procedure.
CWMRDB:SQLParameter Relational DBMS stored procedures and functions. behavioralFeature type Parameters of stored procedures.	CWMRDB_SQLParameter procedureName SQLSimpleTypeName Shows the Parameter data type name. SQLSimpleTypeID SQLDistinctTypeName Shows the Parameter data type name. SQLDistinctTypeID kind Specifies the type of SQLParameter. Valid values are in, out, inout and return.
CWMRDB:SQLIndex spannedClass isUnique An index on a table.	CWMRDB_SQLIndex refTableName Shows the name of the table referenced by the index. refTableID uniqueFlag
CWMRDB: SQLIndexColumn feature index Columns that constitute the index.	CWMRDB_SQLIndexColumn refColumnName Shows the name of the column referenced by the indexColumn. refColumnID SQLIndexName SQLIndexID
CWMRDB:PrimaryKey feature keyRelationship Stores the uniqueness information of the table.	CWMRDB_PrimaryKey columnName Shows the name of the column that constitutes this key. If more than one, they are stored in the PrimaryKeyHasStructuralFeatures collection. keyRelationshipName Shows the name of the constraint referring to the primary key. If more than one, they are stored in the PrimaryKeyHasKeyRelationships collection.
CWMRDB:ForeignKey uniqueKey feature Stores the association of a table with columns of another table.	CWMRDB_ForeignKey parentColumnName Shows the name of the referenced column. parentTableName Shows the name of the parent (referenced) Table. refPrimaryKeyName Shows the name of the primary key referenced by the foreign key. childColumnName
CWMRDB:UniqueConstraint Stores conditions that define the uniqueness of rows in a table.	CWMRDB_UniqueConstraint
CWMRDB:Trigger Stores an event-based action defined for the table.	CWMRDB_Trigger
CWMRDB:SQLDistinctType Distinct datatype used with an SQL column.	CWMRDB_SQLDistinctType SQLSimpleTypeName Holds the name of the simple data type referenced by the distinct data type. typeNumber Data types in a catalog are assigned a unique typeNumber value so that column, SQLParameter, and Measure can reference their associated data types.
CWMOLAP:Schema Contains all elements comprising an OLAP model.	CWMOLAP_Schema
CWMOLAP:Dimension An ordinate within a multidimensional structure, which shares a common semantic meaning within the domain being modeled. Typical Dimensions are: Time, Product, Geography, Scenario, and so on.	CWMOLAP_Dimension
CWMOLAP:HierarchyLevelAssociation currentLevel Stores mapping of level/hierarchy-oriented dimension attributes to one or more physical deployments.	CWMOLAP_HierarchyLevelAssociation levelName
CWMOLAP:Level dimension Stores assignment information for each member of a dimension to a specific hierarchical level within the dimension.	CWMOLAP_Level dimensionID
CWMOLAP:LevelBasedHierarchy Organizational structure that imposes a parent/child ordering on the members of a dimension and describes relationships between specific levels of a dimension.	CWMOLAP_Hierarchy
CWMOLAP:Cube A collection of analytic values sharing the same dimensionality.	CWMOLAP_Cube
CWMOLAP: CubeDimensionAssociation Relates a cube to the dimensions that define it.	CWMOLAP_CubeDimensionAssociation
CWMOLAP:CubeRegion Models a sub-unit of a cube of the same dimensionality as the cube, with each dimension optionally sub-set in its list of members. A cube may or may not have CubeRegions.	CWMOLAP_CubeRegion cube Identifies associated cube xmi.id value
CWMOLAP:Measure Subclass of the CWM Attribute class, representing dimension measures such as sales, quantity, or weight.	CWMOLAP_Measure owner Shows the xmi.id of the Cube class that owns the measure. SQLDistinctTypeName Holds the data type for the measure. SQLSimpleTypeName Holds the data type for the measure.
CWMTFM:TransformationMap Represents a specialized transformation consisting of a group of ClassifierMaps, that map from a set of sources to a set of targets.	CWMTFM_TransformationMap
CWMTFM:ClassifierMap transformationMap Represents a mapping of source classifiers to target classifiers. A ClassifierMap may consist of a group of FeatureMaps.	CWMTFM_ClassifierMap transformationMapID
CWMTFM:FeatureMap classifierMap source (CWM:Feature) target (CWM:Feature) Represents a mapping of source features to target features.	CWMTFM_FeatureMap classifierMapID sourceName targetName
CWMTFM:ClassifierMap source (CWM:Classifier) Source classifiers of ClassifierMap.	CWMTFM_ClassifierMapSource xmi.idref Refers to the source of ClassifierMap.
CWMTFM:ClassifierMap target (CWM:Classifier) Target classifiers of ClassifierMap.	CWMTFM_ClassifierMapTarget xmi.idref Refers to the target of ClassifierMap.
UML:TaggedValue modelElement Allows information to be attached to any model element in the form of a “tagged value” pair (that is, name = value).	CWM_TaggedValue modelElementName modelElementID
CWM:Model A view of the physical system (for example, an analysis model, design model, or implementation model). Note: When a tool exports its model metadata only, its root element is likely to end up in this class.	CWM_Model exporter Shows information related to source XML. exporterVersion Shows information related to source XML. xmlFileName Holds the name of the file used to import the object and its descendents).
CWM:Package A grouping of model elements such as objects from the Package and Classifier classes. Note: If the export is an OLAP model, the root object may be in this class. MDS, however, will translate this object into the CWMRDB_Catalog class, and form all relationships from that class object. (That is, it retains its root-object status but in the Catalog repository class.)	CWM_Package namespace Holds the owner xmi.id of the package.
CWM:Class Namespace for contained elements.	CWM_Class packageName namespace
CWM:Association Declaration of a semantic relationship between objects in the Classifier class.	CWM_Association packageName
CWM:AssociationEnd Specifies the connection of an association to another classifier.	CWM_AssociationEnd className associationName Holds the values of class and association names.
CWM:Multiplicity Defines a non-empty set of non-negative integers.	CWM_Multiplicity multiplicityRangeID lower upper
CWM:DataType Instances of primitive values of data types, such as integers and strings.	CWM_DataType
CWM:StructuralFeature xmi.idref Instances of the StructuralFeature class map PrimaryKey instances to the Class(es) that constitute the key.	CWM_StructuralFeature xmi.idref Stores the xmi.id of the referenced column.
CWM:KeyRelationship xmi.idref Stores the identity of other related instances. Acts similarly to the relational model concept of foreign key and the object model concept of a reference.	CWM_KeyRelationship xmi.idref Stores the xmi.id of the key constraint referring to the primary key.
CWM:Description modelElement Stores business or technical descriptions of the Tables and Columns classes.	CWM_Description modelElementName Stores the name of the object for which the description is defined. modelElementID
CWM:Attribute type owner A named slot within a classifier feature that may hold a value.	CWM_Attribute type Identifies the associated DataType xmi.id for an object from the Attribute class. ownerName ownerScope Specifies whether the feature appears in every instance of the classifier or only once for the entire classifier.