star schema
Fact-centered database design
A star schema is a database design where a central fact table connects to multiple dimension tables, forming a star-like pattern.
Used in data warehousing and business intelligence, it organizes data for efficient querying: the fact table holds measurable events sales transactions, while dimension tables provide context date, product, customer.
The simple structure makes analysis faster than more normalized designs.
- measuresQuantifies or evaluates
- databaseOrganized digital information collection
- data warehouseConsolidated repository for analysis
- SQLDatabase manipulation language
- hierarchiesRanked organizational structures
spokes · business intelligence · granularity · snowflake · relational database · analysis · constellation · metadata · hub · ETL · multidimensional · drill down · roll up · conformed · cube · data modeling · data aggregation · dashboard
- schemasschemas, schemata, mental models, data model
- data systemsdatabase, data warehouse, data lake, data model, data store
- data warehousingdata warehouse, ETL, extract, transform, load
- data modelingdata model, entity, attribute, relationship, normalization
- database designtables, relationships, normalization, entity, attribute
- analyticsanalytics, metrics, dashboards, KPI, dashboard