Logical Data Modeling - Additive Attribute

Data System Architecture

About

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 and the results of their aggregation is called a metrics
  • A label attribute are used to label, filter and/or group on.

Example

  • the sales of a product
  • counter example: a ratio or a stock is not an additive attribute because you can't add them.




Discover More
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
Logical Data Modeling - Classifier (Label, Class, Tag) - Descriptif Attribute

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...
Data System Architecture
Relational Data Modeling - Aggregate Table (Summary Table)

An Aggregate table is a persistence unit of aggregate data. Aggregate tables are also known as summary table (from summary) materialized view A aggregate is a table that contains the result of a query...



Share this page:
Follow us:
Task Runner