Understand the concepts behind dimensional schema design,
such as star schemas, snowflake schemas, and starflake schemas. Learn
more about the relationship between the database structure and the
dimensional model hierarchies.
Dimensional schemas
A database is comprised of one or more tables, and the
relationships among all the tables in the database is collectively
called the database schema. Although there are many different
schema designs, databases that query historical data usually use a
dimensional schema design.
Logical dimensional data models
A logical data model is a model that is not specific to
a database that describes things about which an organization wants
to collect data, and the relationships among these things.
Physical dimensional data models
When you create a physical data model, you map the logical
data model to the physical structures of a database that hosts the
data warehouse.