Star Schema

A star schema is the dimensional data-modeling pattern, popularized by Ralph Kimball in The Data Warehouse Toolkit (1996), where a central fact table containing measurable events (sales transactions, page views, support tickets, sensor readings) is surrounded by dimension tables containing the descriptive context (customer, product, store, date, channel). The shape — one fact table at the center with dimension tables radiating outward — gives the schema its name. The defining property: queries become straightforward star joins (fact table joined to multiple dimensions on foreign keys, filtered by dimension attributes, aggregated by dimension hierarchies), which most query optimizers handle exceptionally well, and which BI tools (Tableau, Power BI, Looker, Mode) consume natively. A typical retail example: a sales fact table with columns date_key, product_key, store_key, customer_key, units_sold, revenue_amount; dimension tables for date (with year, quarter, month, day, day_of_week, is_holiday), product (with category, brand, supplier, SKU), store (with region, district, format), customer (with segment, tenure, demographics). Star schemas trade off against snowflake schemas (normalized dimensions, more joins) and Data Vault (highly normalized for source integration). The dimensional pattern shines for read-heavy analytical workloads where ease of querying and BI-tool compatibility matter more than storage efficiency. A practical build recipe: identify the business process to model (sales, web sessions, claims), define the grain of the fact table (one row per what?), identify the dimensions that describe that grain, design conformed dimensions that are shared across multiple fact tables (one customer dimension joined to sales, support, and marketing facts), and implement slowly changing dimensions patterns for dimension attributes that change over time. For Digital Experience Platforms, star schemas are the analytical layer that powers customer 360 views, segmentation, attribution modeling, and the audience definitions served back into the experience layer.

Dimensional modeling under a Magic-Quadrant DXP: Centralpoint applies dimensional modeling — fact tables of user behavior surrounded by dimensions of user, content, channel, and time — as the analytical foundation behind the served experience. Gartner Magic Quadrant placement in Digital Experience Platforms rewards exactly this aggregate-then-serve discipline that 25 years of dimensional work informs. Schemas run on-premise, lineage is audit-graded, and the served experience deploys through one line of JavaScript.


Related Keywords:
Star Schema,Star Schema,Oxcyon, AI, AI Governance, Generative AI, Inference, Inference, Inferencing, RAG, Prompts, Skills Manager,