Star Schema

Example(s):
- (a Star Schema Data Model).
See: Fact Table, Dimension (Data Warehouse), Snowflake Schema, Physical Data Model.

References

(Wikipedia, 2019) ⇒ https://en.wikipedia.org/wiki/Star_schema Retrieved:2019-2-28.
- In computing, the star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts. ^[1] The star schema consists of one or more fact tables referencing any number of dimension tables. The star schema is an important special case of the snowflake schema, and is more effective for handling simpler queries. The star schema gets its name from the physical model's^[2] resemblance to a star shape with a fact table at its center and the dimension tables surrounding it representing the star's points.

↑ Dedić, N. and Stanier C., 2016., "An Evaluation of the Challenges of Multilingualism in Data Warehouse Development" in 18th International Conference on Enterprise Information Systems - ICEIS 2016, p. 196.
↑ ", p. 708