Star Schema

A star schema is a database schema used in data warehousing and analytics.

It is characterized by a central fact table that contains numerical or measurable data (such as sales) and is connected to multiple dimension tables.

Dimension tables provide descriptive attributes related to the data in the fact table (such as time, products, and customers).

The star schema's design simplifies querying and reporting, as it allows for efficient data aggregation, navigation, and analysis by reducing the number of joins needed compared to more normalized database structures.