AI engineering glossary · Data engineering
What is star schema?
Star schema: A warehouse design with a central fact table holding measurable events, linked directly to surrounding dimension tables that describe them, such as customer, product and date. It is simple and fast for analytical queries.
Star schema: an example
A sales fact table with keys to date, store and product dimensions lets you sum revenue by month and city.
Related terms
More Data engineering terms
Where you learn it
Star schema is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.