One
part of the datamart or data warehouse is a star schema. A star schema
is composed of a fact table, which contains the actual data that you want to
analyze, and dimension tables, which contain data that define the dimensions.
In a star schema, the relationships between the components resemble a star.
At the center of the star is the fact table, which contains actual data such
as product sales figures. Radiating from the fact table are dimension tables,
which contain data about the dimensions, such as account numbers, months, product
names, and so on.