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.

  Tutorials
  What Are Dimensions?
  Learn about the Time Dimension
  What Are Surrogate Keys?
  Learn Levels of Summarization
  Learn about FACT(s)
  Learn Quantitative Measures
  Learn Qualitative Measures