这一页有部分内容暂时无法显示，其余内容完整。

Weekly topic

• Concepts of bridge tables in data warehousing
• Snowflake schemas
• Hierarchy dimension modelling

• 数据仓库中桥接表（bridge tables）的概念
• 雪花模型（Snowflake schemas）
• 层级维度建模

Learning Objectives:

1. On completion of this topic you should be able to:

   • be able to implement a star schema using SQL
   • know when and why Bridge Tables are necessary to be used
   • be familiar with the concepts of Weight Factor and ListAgg in Bridge Tables
   • understand the concept of snowflakes and bridge table
   • understand the concept of hierarchy.

学习目标

此处有一段内容暂不支持显示。

Seminar

讲了一个半小时Chapter 5，然后讲Chapter 4

Lab