Tutorial Home > Storage and Networking > Storage and Drives > Data Warehousing > Learn about Star Schema
Learn about Star Schema
A Star Schema is a design where data is stored in a large central table, referred as a "FACT" table, linked to and surrounded by smaller tables, referred as a "Dimension" table. Star schema and multi-dimensional models are synonymous concepts in a data warehousing design. Star schema provides faster response (retrieval of data) time. Learn about dimensions, FACTs, surrogate keys, granularity, and, qualitative and quantitative measures.