Which schema model is widely used in traditional data warehouse design for…

Concept

A data warehouse is modelled using a dimensional schema, in which numeric, measurable business events are stored in a central fact table while the descriptive context (time, product, customer, location, etc.) is stored in surrounding dimension tables. The schema is named after the geometric shape its tables form when the fact table is joined to its dimensions.

Application

The arrangement in which one central fact table is directly connected to several denormalised dimension tables - so the diagram resembles a central point with rays radiating outward - is the Star Schema. Each dimension is a single table joined to the fact table by a foreign key, which keeps queries simple and joins shallow. This is the most widely used model in traditional warehouse design precisely because it maps fact tables and dimension tables exactly as the question describes.

Contrast

• Mesh Schema: not a recognised data-warehouse modelling pattern; "mesh" describes a network topology, not a fact/dimension layout.

• Hierarchical Schema: a legacy database data model (parent-child tree, as in IMS), used to structure records in general - not a warehouse design for organising fact and dimension tables.

• Graph Schema: the model behind graph databases that store nodes and edges; it targets relationship traversal, not the central-fact-with-dimensions arrangement.

• None of the above: cannot apply, since a listed option already names the standard warehouse schema.

A close variant, the snowflake schema, normalises the dimension tables, but the plain central-fact-with-denormalised-dimensions form named in this question is the star schema.