star schema

noun

A denormalized database schema consisting of one or more fact tables referencing any number of dimension tables.

Ask AI about this wordChatGPTClaudePerplexityGoogle AIGrok

Meanings

nounstar schema (plural star schemas)

plural star schemas

  1. data warehousingcomputingA denormalized database schema consisting of one or more fact tables referencing any number of dimension tables.

Origin

From the resemblance to a star shape with a fact table at its center.

Full word history & related roots →
Cite this entry
APA

star schema. (n.d.). In WatkinsX Dictionary. Retrieved November 3, 2026, from https://dictionary.watkinsx.com/word/star%20schema

MLA

“star schema.” WatkinsX Dictionary, https://dictionary.watkinsx.com/word/star%20schema. Accessed November 3, 2026.

Chicago

WatkinsX Dictionary, s.v. “star schema,” accessed November 3, 2026, https://dictionary.watkinsx.com/word/star%20schema.

Source: star schema on Wiktionary, CC BY-SA 4.0.