Definition - What does Star Schema mean?
A star schema is a data warehousing architecture model where one fact table references multiple dimension tables, which, when viewed as a diagram, looks like a star with the fact table in the center and the dimension tables radiating from it. It is the simplest among the data warehousing schemas and is currently in wide use.
Techopedia explains Star Schema
The fact tables in a star schema usually have two columns: the first is for the foreign keys pointing to the dimension tables, and the second is for the measures that contain numeric facts, hence, the name fact table. The dimension tables are actually structures that are usually composed of multiple hierarchies that categorize data.
Join thousands of others with our weekly newsletter
Free Whitepaper: The Path to Hybrid Cloud:
Free E-Book: Public Cloud Guide:
Free Tool: Virtual Health Monitor:
Free 30 Day Trial – Turbonomic: