Dimensional Modelling

Więcej takich

Computational Concept Map

przez Devyn W Slaven

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.

przez Roan Sumilang

DEMAND IN MARKETING

przez Carlota Portillo

Basics of Art

przez Skylar Scott

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