Logical entity

This is the class in UML and describes the logical structure of the relevant entities in the logical model based on attributes and associations

Package Logical data model viewpoints
Author Bert Dingemans
Alias --
Stereotypes --

Attributes

Name Type Cardinality Description
Optionele Eigenschap Variant 0 - 1--
Verplichte Eigenschap Variant 1 - 1--
Eigenschap met enumeratie Enumeration 1 - 1--
Eigenschap met complex datatype Complex Datatype 1 - 1--

Mappings

NameSourceSource attributeTargetTarget attribute
Optionele Eigenschap TableOptional ColumnLogical entityOptionele Eigenschap
Verplichte Eigenschap TableRequired ColumnLogical entityVerplichte Eigenschap
Optionele Eigenschap Lookup_Logical entityOptionele EigenschapLogical entityOptionele Eigenschap
Verplichte Eigenschap Lookup_Logical entityVerplichte EigenschapLogical entityVerplichte Eigenschap

Diagrams

Primary Logical datamodel viewpoint

The logical data model consists mainly of logical entities and these are modeled as classes based on UML. A class in UML consists of:

  • A class name and explanation

  • Attributes of which we at least keep track of the name, the data type and the cardinality (the datatype can also be a different class, an enumeration or an interface)

  • The associations, these can be all UML allowed associations but in the base they are the normal associations, specialization and aggregation (be careful with too many association types in data modeling)



In addition to the logical entities, enumerations can be used for the use of domains with attributes. In that case, the data type of the attribute is the enumeration.

Complex data types can be used for complex models. These are explained in more detail in the example and include a breakdown of generic structures for a simpler manageable model

Secundary trace viewpoint

This is an extension of the primary viewpoint which describes a link between the layers. This trace viewpoint is relevant in the situation where the model is used to generate program code based on classes and tables.

In that situation you would like to have lookups and a trace between the logical and physical data modeling.

Primary Logical data model viewpoint Conceptueel - Logisch

In this viewpoint we see the relationship of the logical model with the conceptual model. An association is therefore made between two modeling languages and that is a specific extension for IDEA and is not part of both standards.

Within EA there are three standard association types for modeling between modeling languages. Within IDEA we opt for the trace association for an association between the three modeling layers.

Linked elements

Conceptual model viewpoints

Logical data model viewpoints

Physical data model viewpoints



Links 2 Tags