Dimension: dimensions provide structured labeling information to otherwise unordered numeric measures; date is a common dimension
Dimension tables: contain descriptive attributes; rows are uniquely identified by a single key field
Fact table: consists of the measurements, metrics or facts of a business process; provide the additive values that act as independent variables by which dimensional attributes are analyzed; has no hierarchy
Slowly changing dimension: