Star Schema

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 star schema is the simplest form of a dimensional model used in business intelligence and data warehousing wherein data is arranged in dimensions and facts. In the star schema, there is a single fact table, which is usually expressed in the third normal form (3NF), and multiple de-normalized dimension tables connected to it, radiating out like the points of a star. The star schema has been optimized for querying large data sets and is generally used in data marts and warehouses in order to support OLAP cubes, ad hoc queries, analytic applications and business intelligence.

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.
Share this:

Connect with us

Email Newsletter

Join thousands of others with our weekly newsletter

The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.