Dimensional Modelling

Больше похоже на это

One Child Policy

от Dawood Ahmad

Edward De Bono's thinking hats

от Aly Vermont

Brand Personality

от Luis Felipe Acosta

Roan Sumilang's World View: The worldview I have built throughout this class greatly differs from the worldview beforehand. I pride myself on being someone who thinks and questions a lot even before this class, and Philosophy allowed me to clarify these questions and understand how I think. This is the Worldview built upon what I've learned in this course.

от Roan Sumilang

Terminologies used in Multi-Dimensional Data Modeling (MDDM)

Grain

Lowest level at which members of an attribute are stored.

Hierarchies

Arranging Attributes in different levels

Ragged Hierarchies

Whichever path you may traverse the number of levels remains the same however nodes may not be present at every level(except root and leaf nodes)

Natural Hierarchies

Every child has a single parent

Dimensions

Descriptive objects used to view the fact

Role Playing Dimension

A dimension represented more than once in the fact table

Slowly Changing Dimension

one or more attributes changes over time

Members

Labels of the attributes

Attributes

Detailed Information about dimensions

Facts

Numeric values used for analysis

Types

Non-Additive fact

Not Additive across any dimension

Factless Fact

Intersection of dimensions indicative of a fact

Semi-Additive fact

Additive across most dimensions

Additive fact

Additive across all dimensions