Star Schema
- This schema consists of a central fact table surrounded by dimension tables. The fact table contains quantitative data, while the dimension tables provide descriptive attributes. The star schema is easy to understand and query, making it popular for OLAP applications.
- Description: A simple and widely used form of dimensional modeling where a central fact table is connected to multiple dimension tables.
- Advantages: Easy to understand and query, with straightforward joins between fact and dimension tables.