Logical Data Modeling - Entity (Row | Tuple | Member | Unit | Instance )

Data System Architecture


An entity is one thing which can be distinctly identified.


  • A specific person
  • A specific company
  • A specific group of persons,
  • A specific place,
  • A specific event

It's a concept to abstractly group similar things.

An entity is a single occurrence of an entity set, it's also known as an instance

Example of entity implementation by domain

An entity would be represented:



An attribute is a descriptive property or characteristic of an entity.


The value about an entity is expressed by a set of attribute-value pairs

<math> \begin{array}{rrr} att1 & \mapsto & Foo \\ att2 & \mapsto & Blue \\ att3 & \mapsto & 20 \\ att4 & \mapsto & Sunny \\ \end{array} </math>


An id is attribute that describes the identity of an entity.


Entities are associated via relationship



A permanent entity is always part of the system, never entering or leaving.


A temporary entity is not always present in a system. It enters the system at some point in time, stays for a while, and then leaves again at some other point in time.

A transaction, a customer in a restaurant is an example of a temporary entity.

There is a constant flow of temporary entity.


An active entity (also known as dynamic model components) are entities that follow a process lifecycle (hence active and not passive).

Dimension are generally not an active component whereas a transaction is.


Asynchronous communication between entities is based on signal and reception

Discover More
Data System Architecture
(Relation|Table) - Tabular data

This section is based on the relation data structure must well known under the term of table. The system that manages this structure are called Relational databases (or RDMS) . They are founded on Set...
Card Puncher Data Processing
(Statistics|Machine Learning|Data Mining) - (Unit|Individual|Case|Subject|Observation|Instance|Input)

in Statistics. Each member of a sample is also known as: a unit an individual a case a subject an instance an observation input data Data contains values grouped into variables and observations....
Data Modeling Chebotko Logical
Cassandra NoSql Database

Cassandra is a NoSql database for transactional workloads that require high scale and maximum availability. Cassandra is suited for transactional workloads at high volume and shouldn’t be considered...
Venn Diagram
Collection - Set

A set is: a data structure of the set theory a collection ofdistinct objects (then without duplicate) an unordered collection of objects The objects element of the set have the same type (the type...
Data System Architecture
Data Modeling - Canonical Form

A canonical form is a unique representation such that every object can be uniquely identified in the global scope object (entity)normal form In computer science, the equality of two objects can easily...
Data System Architecture
Data Modeling - Reference (connect, link to)

Reference is the name of a relationship that is directed where an entity (source, first) refers to another entity (target, second) We say that the source entity references, cites, or otherwise points...
Dataquality Metrics
Data Quality - Entity (Resolution|Disambiguation) - Record (linkage|matching) - Conflation

Entity Resolution, or Record linkage is the process of (joining|matching) records from one data source with another that describe the same Entity. Also known as : entity disambiguation/linking,duplicatidentificatioidentifiedata...
Utah Teapot
Data Visualization - ( Chart | Graph | Graphic)

A chart, also called a graph (in mathematics for instance), is a graphical representation of data, in which the data is represented by symbols, such as: bars in a bar chart, lines in a line chart,...
Utah Teapot
Data Visualization Foundation

The Utah Teapot. Data visualization is the process of mapping quantitative data to visuals (shapes, color, position, etc) to create a graph made of geometric object. Information visualization: ...
Star Schema
Dimensional Data Modeling - Relationship

In a dimensional data model, you have mostly a one-to-many relationship between the dimension and the fact table between each level in a hierarchy man-to-many relationship are modeled with a bridge...

Share this page:
Follow us:
Task Runner