Home >  Term: star schema
star schema

(1) A type of relational database schema that is composed of a set of tables comprising a single, central fact table surrounded by dimension tables. See also dimension table, star join.
(2) A type of relational database schema that is made up of a fact table and a set of dimension tables. In Tivoli Enterprise Data Warehouse, the fact table holds the values of the component's metrics, and the dimension tables hold the values of the attributes of a component or a metric.

0 0

Δημιουργός

  • Peteh
  •  (V.I.P) 14225 points
  • 100% positive feedback
© 2025 CSOFT International, Ltd.