Appendix A Teradata Metadata - Database Information Metamodel - Teradata Meta Data Services

Teradata Meta Data Services User Guide

Product
Teradata Meta Data Services
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
Product Category
Teradata Tools and Utilities

DIM

The Database Information Metamodel (DIM) represented in Figure 26 and Figure 27 provides the base model in which to store database metadata in the MDS repository.

Figure 26: Database Information Metamodel (DIM) (Sheet 1 of 2)
Figure 27: Database Information Metamodel (DIM) (Sheet 2 of 2)

Other warehouse applications can reference the Teradata metadata in the DIM instead of maintaining the identical metadata in their own metadata. This will reduce metadata redundancy and the number of places that a change must be made.

You can extend the DIM with new relationships, classes, or properties to meet your metadata management needs.

A Teradata Database System is initially loaded into the MDS repository using the metaload utility or MetaManager. Metadata elements loaded into the DIM are referred to as DIM objects. DIM objects are readable by any MDS User that has the appropriate read permission.

Table 25 on page 147 and Table 62 on page 169 contain descriptions of the DIM classes and relationships respectively.