Cognitive Scaffold

Preparing your thinking workspace

arrow_back_ios_new
MENTAL MODEL · M10238

Star Schema

Star Schema
BehaviorHigh supportOrganizational Behavior
Included
account_tree

Updated 2026-08-13

Loading revision record…

INTRODUCTION

English translation pending.

CORE DEFINITION

The fact table sits at the center holding measurable data, while dimension tables surround it to provide descriptive context such as time, place, and product. The structure is deliberately simple, queries stay efficient, and the model remains readable to analysts. It is the classic paradigm for organizing business data so that it becomes genuinely queryable and analyzable rather than merely stored in normalized tables.

SCAFFOLDING EFFECT

psychology

Reduce cognitive load

- Organizes data for analysis: measurable facts are separated cleanly from descriptive context - Keeps queries simple: the star shape keeps joins predictable and query performance fast - Stays readable: analysts can understand the whole model at a single structured glance

anchor

Anchor fast decisions

Facts and dimensions are separated so that each measure is stored once and described many times through small, denormalized tables. Because each dimension joins to the fact table in a single hop, queries stay cheap and predictable, and analysts can reason about the model structurally instead of decoding nested views each time.

MINIMUM ACTION

In progress 0/1

Practice this model in one real situation:

Check to track your progress (stored locally)
Learning progress0%
account_treeGenealogyexpand_more
menu_bookReferencesexpand_more

Source support: Explicit

  • link
    en.wikipedia.orghttps://en.wikipedia.org/wiki/Star_schemaZH · Explicit
    verified

RELATED MODELS

Related model

Two-Factor Theory

The two-factor theory (also known as motivation–hygiene theory, motivator–hygiene theory, and dual-factor theory) states that there are certain factors in the workplace that cause job satisfaction while a separate set of factors cause dissatisfaction, all of which act independently of each other. It…

arrow_forwardRelated model

Glass Walls

Distinct from the 'glass ceiling' (vertical promotion barrier), it refers to women or minority groups being isolated in certain functional departments (e.g., HR, administration), making it difficult to move laterally to core business departments (e.g., sales, R&D), thereby lacking the key experience needed for promotion.

arrow_forwardRelated model

Inertia

Inertia is the natural tendency of objects in motion to stay in motion and objects at rest to stay at rest, unless a force causes its velocity to change. It is one of the fundamental principles in classical physics, and is described by Isaac Newton in his first law of motion (also known as The Principle of Inertia). It is one of the primary manifestations of mass, one of the core quantitative properties of physical systems.

arrow_forward