Previous Topic: Foreign KeysNext Topic: SUBJECT_AREA


Analysis Tasks Related to Data.

The following table directs you to the PI table explanation that contains SQL for each Analysis task listed:

If You Want To

See

Find the attributes of an entity type or subtype

ATTRIBUTE

Find the classifying attribute of a partitioning

PARTITIONING/CLASSIFIER

Find the identifying attribute(s) of an entity type

ATTR_IDENT or IDENTIFIER

Find the entity types in a model

ENTITY_TYPE

Find the relationships between entity types

RELATIONSHIP

Find the identifying relationship of an entity type

REL_IDENT or IDENTIFIER

Find the mutually exclusive relationships of an entity type

REL_MUTL_EXCL

Find the permitted values of an attribute

PERMIT_VALUE

Select entity types, classifying attributes, and subtypes

PARTITIONING/CLASSIFIER

Select the mutually exclusive relationships from each of the entity types in a model

REL_MUTL_EXCL

Select the root subject area in a model

SUBJECT_AREA

Select the subject areas and their parent subject areas

SUBJECT_AREA

Select the entity types in a subject area

ENTITY_TYPE

Select the attributes with default permitted values

ATTRIBUTE

Select the derived attributes for a derivation algorithm

ATTRIBUTE

Select the permitted value ranges for an attribute

PERMIT_VALUE

Select the classifying value for a subtype

ENTITY_SUBTYPE