Logical Data Modeling - Classification (Taxonomy | Categorization) - Transversal Data Organization

Data System Architecture


Classification is an naming technique for organization where entity or relationship gets classified by giving them a nominal attribute known as a classifier.

The classification of organisms in an ordered system that indicates natural relationships; The science, laws, or principles of classification; systematics; Division into ordered groups or categories.

The American Heritage Dictionary of the English Language. Fourth Edition. Boston, MA: Houghton Mifflin Company, 2006.

The output of classification process is an aggregate binary relationship (ie is part of relationship).

In dimensional data, you will find this attributes in dimension.

Design rule

The magical number may be applied to limit:

  • the number of member in a class
  • the number of class that classify an entity or a association

Number of Class member

According to magical number, the number of value that can be choose for every class attribute should be in the range <math>7 \pm 2</math>

Example of bad class for a department

  • Admin Support Center
  • Development
  • Computer Science
  • Data Services
  • Digital Media Innovation Program
  • Events Center
  • Engineering
  • Infrastructure
  • Enterprise System Integration
  • Project Management

If this is the case, you should create a new level in your package (hierarchy)

Number of Class

According to magical number, the number of value that define a association or an entity should be in the range <math>7 \pm 2</math>

For instance, a fact table should not have more than <math>7 \pm 2</math> dimension.


Classification can be performed during data processing operations

Documentation / Reference

Discover More
Data Mining - (Classifier|Classification Function)

A classifier is a Supervised function (machine learning tool) where the learned (target) attribute is categorical (“nominal”) in order to classify. It is used after the learning process to classify...
Thomas Bayes
Data Mining - Grouping (Classification)

Classification in data mining
Card Puncher Data Processing
Data Processing - Operations / Operator

A data processing function takes an input and creates an output in a pipeline. transition in Automata functional interface in Functional Programming Filter in Data Processing (Shell and Log Pipeline)...
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...
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...
Devtool Chrome Event Listener
Event - Category

event type are categorized further in category. Form Event Focus Event Input Devices Event View Events Example non-normative. Category Event Type Form Event submit Focus Event focus,...
Data System Architecture
Logical Data Modeling

A data model in software engineering is a graph of entity that try to represent the reality and describes how data are represented and accessed. the real world consists of entities and relationships....
Data System Architecture
Logical Data Modeling - Binary Relation

A binary relation is a relationship between two elements that is implemented via a binary function. Binary relations are used in many branches of mathematics to model concepts like: order relation...
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 Model Ontology
Logical Data Modeling - Ontology

Data modeling is a sort of ontology. Ontology is the philosophical study of the nature of being, existence or reality in general which deals with questions concerning what entities exist or can be said...

Share this page:
Follow us:
Task Runner