Dimensional Data Modeling - Fact

Star Schema

About

A fact is a row in a fact table and represents an events.

A fact table represents a serie of facts.

Facts

The term fact comes from a joint research conducted by General Mills and Darmouth Univeristy in the 1960s.

Architecture

  • In an event driven architecture, the events are facts.
  • In a database shared architecture, the tables store only the last version of the facts (ie mostly in dimensional/entity table)





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...
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...
Star Schema
Dimensional Data Modeling - Fact Table

A fact table is a table that stores fact where a fact can be seen as the representation of an event. It's also known as: Transactional history Unalterable fact. (The content of this kind of table...
Star Schema
Dimensional Data Modeling - Measure

In a dimensional model, a measure is a quantitative attribute of a fact (in a fact table) that is not a foreign key that creates a relationship to a dimension. A measure permits to quantify. A calculated...
Event Conceptual Model
Event (Timed Measure|Action)

An event is a timed observed physical reality described by: space (location) participant. The observations describing the event are defined by the nature or physics of the observable, the observation...
Card Puncher Data Processing
What is an Event-Driven processing model?

An event-oriented model is a system that is driven from an event point of view, not from a state point of view. Ie: when an event occurs, transformation happens to the entities that change their...



Share this page:
Follow us:
Task Runner