Hvězdy

In computer science, „Hvězdy“ translates to „Stars“ in English, but it typically refers to „star notation“ or „star schema“ in the context of database design and data warehousing. A star schema is a type of database schema that is optimized for data retrieval and analysis, particularly in the context of Online Analytical Processing (OLAP).

In a star schema, data is structured around a central fact table that contains quantitative data (metrics) related to a specific business process, such as sales or inventory. This fact table is surrounded by dimension tables that provide descriptive attributes related to the facts, like time, geography, products, or customers. The layout resembles a star, with the fact table at the center and dimension tables radiating outward.

This schema simplifies complex queries and improves performance for analytic queries by reducing the number of joins required to fetch data. It also enhances the usability and understanding of the database structure, making it easier for analysts and business users to navigate and extract insights from the data.