A star schema is a data model used in data warehouses, where a fact table is connected to dimension tables in a star-like structure. In this model, the fact table contains key measures and indicators that relate to various aspects of an organization’s operations. Dimension tables represent different attributes and characteristics of these measures, which can be used for data segmentation and analysis. The star schema is popular in business intelligence due to its readability and efficiency in query processing, allowing users to quickly obtain business insights from the data warehouse.
Słownik