10.6. CHAPTER SUMMARY

  • The components of the dimensional model are derived from the information packages in the requirements definition.

  • The entity-relationship modeling technique is not suitable for data warehouses; the dimensional modeling technique is appropriate.

  • The STAR schema used for data design is a relational model consisting of fact and dimension tables.

  • The fact table contains the business metrics or measurements; the dimensional tables contain the business dimensions. Hierarchies within each dimension table are used for drilling down to lower levels of data.

  • STAR schema advantages are: easy for users to understand, optimizes navigation, most suitable for query processing, and enables specific performance schemes.

Get DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.