OMG CWM to MDS CWM_Metamodel Mapping
The layout of the MDS CWM_Metamodel is shown in Figure 29.
Figure 29: MDS CWM_Metamodel layoutThe 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.
CWM Package:Class |
MDS CWM_Metamodel Class |
CWMRDB:Catalog 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 Shows information related to source XML. Shows information related to source XML. 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 is a derived property value for storing the name of the catalog owning the schema. |
CWMRDB:SQLSimpleType Data type used with a SQL column. Examples are Integer, Varchar, LOB, CLOB, and so on. |
CWMRDB_SQLSimpleType charLength shows the maximum length of character data type associated with table columns, view columns, SQL parameters, and so on. 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 is a derived property value to store the name of the schema owning this table. |
CWMRDB:Column Column in a result set, a view, or a table. |
CWMRDB_Column Shows the name of associated element owning this column. (For example: table, view, and so on) Either table or view. This is in place to aid in searches, as it is derived from existing information. Shows the Column data type. Shows the Column data type. |
CWMRDB:View 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 shows the DML/DDL for the View object. |
CWMRDB:Procedure Relational DBMS Stored procedures and functions. |
CWMRDB_Procedure Stores the expression body of a procedure. |
CWMRDB:SQLParameter Relational DBMS stored procedures and functions. Parameters of stored procedures. |
CWMRDB_SQLParameter Shows the Parameter data type name. Shows the Parameter data type name. Specifies the type of SQLParameter. Valid values are in, out, inout and return. |
CWMRDB:SQLIndex An index on a table. |
CWMRDB_SQLIndex Shows the name of the table referenced by the index. |
CWMRDB: SQLIndexColumn Columns that constitute the index. |
CWMRDB_SQLIndexColumn Shows the name of the column referenced by the indexColumn. |
CWMRDB:PrimaryKey Stores the uniqueness information of the table. |
CWMRDB_PrimaryKey Shows the name of the column that constitutes this key. If more than one, they are stored in the PrimaryKeyHasStructuralFeatures collection. Shows the name of the constraint referring to the primary key. If more than one, they are stored in the PrimaryKeyHasKeyRelationships collection. |
CWMRDB:ForeignKey Stores the association of a table with columns of another table. |
CWMRDB_ForeignKey Shows the name of the referenced column. Shows the name of the parent (referenced) Table. Shows the name of the primary key referenced by the foreign key. |
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 Holds the name of the simple data type referenced by the distinct data type. 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 Stores mapping of level/hierarchy-oriented dimension attributes to one or more physical deployments. |
CWMOLAP_HierarchyLevelAssociation |
CWMOLAP:Level Stores assignment information for each member of a dimension to a specific hierarchical level within the dimension. |
CWMOLAP_Level |
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 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 Shows the xmi.id of the Cube class that owns the measure. Holds the data type for the measure. 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 Represents a mapping of source classifiers to target classifiers. A ClassifierMap may consist of a group of FeatureMaps. |
CWMTFM_ClassifierMap |
CWMTFM:FeatureMap Represents a mapping of source features to target features. |
CWMTFM_FeatureMap |
CWMTFM:ClassifierMap Source classifiers of ClassifierMap. |
CWMTFM_ClassifierMapSource Refers to the source of ClassifierMap. |
CWMTFM:ClassifierMap Target classifiers of ClassifierMap. |
CWMTFM_ClassifierMapTarget Refers to the target of ClassifierMap. |
UML:TaggedValue Allows information to be attached to any model element in the form of a “tagged value” pair (that is, name = value). |
CWM_TaggedValue |
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 Shows information related to source XML. Shows information related to source XML. 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 Holds the owner xmi.id of the package. |
CWM:Class Namespace for contained elements. |
CWM_Class |
CWM:Association Declaration of a semantic relationship between objects in the Classifier class. |
CWM_Association |
CWM:AssociationEnd Specifies the connection of an association to another classifier. |
CWM_AssociationEnd Holds the values of class and association names. |
CWM:Multiplicity Defines a non-empty set of non-negative integers. |
CWM_Multiplicity |
CWM:DataType Instances of primitive values of data types, such as integers and strings. |
CWM_DataType |
CWM:StructuralFeature Instances of the StructuralFeature class map PrimaryKey instances to the Class(es) that constitute the key. |
CWM_StructuralFeature Stores the xmi.id of the referenced column. |
CWM:KeyRelationship 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 Stores the xmi.id of the key constraint referring to the primary key. |
CWM:Description Stores business or technical descriptions of the Tables and Columns classes. |
CWM_Description Stores the name of the object for which the description is defined. |
CWM:Attribute A named slot within a classifier feature that may hold a value. |
CWM_Attribute Identifies the associated DataType xmi.id for an object from the Attribute class. Specifies whether the feature appears in every instance of the classifier or only once for the entire classifier. |