Logical Data Modeling - (Derived|Calculated) Attribute (Derived Data)

Data System Architecture


Derived is a property of:

The value can be calculated or deduced from relationship Groupings or from the values of other variable. The value of a Derived variable changes constantly.

There is then a functional dependency between two variables.


This kind of dependency is really common in UI development when one action must refresh a part of the UI. It's often implemented with an observer pattern.


  • Student Age,
  • Account Balance,
  • Number of courses taken.

Discover More
Card Puncher Data Processing
Business - Rule

A business rule is a rule that constrains some aspect of the business process. According to the white paper by the Business Rules Group, a business...
Dataquality Metrics
Data Quality - Data Rules

Data rules are rule that can have various designations such as: business rules (in the data modeling), data test, quality screen. They follow the same concept than the rules from an event driven...
Card Puncher Data Processing
Design Pattern - Observer (Publish-subscribe model|Pub Sub)

An observer makes a observation by creating an event and passing it to a callback method of the subscriber. The observer is also called a message broker because it dispatches the event (ie message) to...
Thomas Bayes
Feature Engineering

In Feature engineering, you are: creating derived features normalize them Aggregated variables. Example: aggregated transaction count per account in last 24 hours to spot abnormal amount...
Language - Nonterminal Symbol

A symbol or token is called non terminal when it does not appear in the resulting formal language. They are derived token that are expressed via a rule with a regular expression that contains: either...
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 - Dependency (Coupling)

A dependency is a Relationship that signifies that a entity requires other entity for their specification or implementation. This means that the complete semantics of the client (the dependent) are either...
Owb Functional Dependency
OWB - Functional Dependency Rule

A functional dependency occur when : Then we say that The attribute A is the dependent The attribute B is the determinant A is then a derived attribute of B. In the data profiling tools, the...
Card Puncher Data Processing
Oracle Database - Virtual Column

Virtual column are derived column for other table.
Data System Architecture
RDBMS - Auxiliary Data Structure (ADS)

Auxiliary data structures are logical replications of data from one or more columns of a table. Auxiliary data structures contain copies of, references to, or data computed from base table data, deleting...

Share this page:
Follow us:
Task Runner