Logical Data Modeling - Classifier (Label, Class, Tag) - Descriptif Attribute

Data System Architecture

About

A label is an attribute that describes its entity or relationship with nominal data.

A label is also known as:

  • a tag
  • a class
  • or just a nominal attribute
  • a classifier
  • a group
  • a category

Classifiers / Label can be organized in hierarchies.

They are the output of a classification process

In dimensional data, they are known as dimensional attribute.

Usage

They are used to label, filter and/or group on whereas additive numeric attribute are used to aggregate over.

They also create an aggregation relationship between entities.

Identifier

There is two kind of label identifier:





Discover More
Star Schema
Dimensional Data Modeling - Descriptif Attribute (Dimensional Attribute)

A descriptif attribute is class attribute that describe a property or characteristic of a dimension. They are used to label, filter and/or group on. measures Typical attributes for a product dimension...
Model Funny
Function - (Aggregate | Aggregation)

Aggregate functions return a single value calculated or selected from values that are in a aggregation relationship (ie a set) This values are also known as summary because they try to summarize...
Data System Architecture
How is used the name attribute in logical data modeling?

A name is a label attribute of an primary element. It's an identifier that specifies a unique key in a specific scope called a namespace. the name of file is unique in a directory. the name of...
Data System Architecture
Logical Data Modeling - Additive Attribute

An additive attribute is an attribute with a numeric value that can be logically added (You can therefore aggregate over) In dimensional data, the most command additive attribute are called measure...
Data System Architecture
Logical Data Modeling - Aggregate Data

Aggregate data are data that are in a aggregation relation (ie elements that are in a collection) An aggregate function is a function that is applied to aggregate data (ie A sum is applied to a collection...
1..*1Professor+ listOfStudents : listClass+ Students : list
Logical Data Modeling - Aggregation (Collection)

aggregation is a containment relationship where one or more entities are part of a container entity. In other word, aggregation is combining multiple pieces of data into one unit. The container entity...
Data System Architecture
Logical Data Modeling - Attribute

An attribute is a property or characteristic of a primary element (entity, relationship) one-to-one colorentity... The values for each attribute are defined in terms of properties. An attribute is...
Data System Architecture
Logical Data Modeling - Classification (Taxonomy | Categorization) - Transversal Data Organization

Classification is an naming technique for organization where entity or relationship gets classified by giving them a nominal attribute known as a classifier. relationshipsgroups or categories The output...
Data System Architecture
Logical Data Modeling - Hierarchy Relationship

A hierarchy is a composed relationship. It means that it represents a succession of one-to-many relationship that build a tree between: label values or entity A hierarchy is represented in a relational...
Data System Architecture
Logical Data Modeling - Id attribute

An id is an label attribute with a numeric representation that identify uniquely an entity or a relationship in a local scope. name If the id attribute is chosen as the local identifier, it will be:...



Share this page:
Follow us:
Task Runner