Logical Data Modeling - Attribute

Data System Architecture

About

An attribute is a property or characteristic of a primary element (entity, relationship)

An attribute is just a shortcut for an entity that has only one characteristic and a one-to-one relationship with its entity.
For example, a color attribute could have been modeled also as an entity with several attributes (warm, cold, …)

The values for each attribute are defined in terms of properties.

An attribute is known as a:

Functionality

The value of an attribute may have one of this functionalities:

Properties

Each attribute are defined in terms of properties (metadata attributes):

  • Name:
    • It provides a semantic meaning for the values.
    • the name of the attribute may contain a prefix of its element
  • Description
  • Attribute Source Category:
  • Data type (what class of data can be stored in that attribute)
  • Length and/or precision
  • Domain: enumeration, range of permitted, legal values / Format patterns (what values an attribute can legitimately take on)
  • Default value or algorithm (what default value are recorded if not specified by the user)
  • Optionality: Mandatory or optional
  • Density / Sparsity
  • analytical property - descriptive or measure

Attribute Source Categories

Basic

An Attribute Value that cannot be deduced or calculated. Examples:

  • Student name
  • Birthday

Derived / Calculated

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

Designed

The Attribute is created to overcome the system constraints. The value of a Designed Attribute does not change. Attribute does not change.

Examples:

  • Student ID,
  • Course number.




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...
Data System Architecture
Collection - Priority Queue

A priority queue is a queue where the first element to be retrieved is an element that has the highest priority attribute. An element with high priority is served before an element with low priority....
Star Schema
Dimensional Data Modeling - Attribute

in dimensional modeling. Attribute values in a dimension are called members.
Star Schema
Dimensional Data Modeling - Dimension (Perspective)

A dimension is a part of a dimensional schema and provide the basis for analyzing data through slicing and dicing A dimension is just a set of descriptif attribute that are generally grouped: in a...
Star Schema
Dimensional Data Modeling - Dimensional Schemas

This section is dimensional data modeling, That is the building of a cube (hypercube) A dimensional schema is a schema based on dimension. The dimensional schema can modeled: in a relational database...
Ebs Flexfield
EBS - Flexfield

A flexfield is a field made up of sub-fields, or segments. A flexfield appears on your form as a pop-up window that contains a prompt for each segment. Each segment has: a name and a set of valid...
Graph
Graph - (Node) Attribute

Node Attributes are descriptive attribute of a node or edge in a graph Egde attribute: weights, costs, distances, ratings, time intervals, or strengths
Data System Architecture
Key Value (or Property)

Key value data (known also as Property) are value that have a direct relation with their key. They can be seen as a set of data modeling attribute. This kind of data is stored: in code as: an collection...
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 - Business Key

A business key is a key that use the business users to identify uniquely an entity. It's then also a unique key. The business key is a meaningful/business code based generally on the concatenation of...



Share this page:
Follow us:
Task Runner