Dimension table

In data warehousing, a dimension table is one of the set of companion tables to a fact table.

The fact table contains business facts (or measures), and foreign keys which refer to candidate keys (normally primary keys) in the dimension tables.

Contrary to fact tables, dimension tables contain descriptive attributes (or fields) that are typically textual fields (or discrete numbers that behave like text). These attributes are designed to serve two critical purposes: query constraining and/or filtering, and query result set labeling.

单词	Dimension table
释义	Dimension table 英语百科 Dimension table In data warehousing, a dimension table is one of the set of companion tables to a fact table. The fact table contains business facts (or measures), and foreign keys which refer to candidate keys (normally primary keys) in the dimension tables. Contrary to fact tables, dimension tables contain descriptive attributes (or fields) that are typically textual fields (or discrete numbers that behave like text). These attributes are designed to serve two critical purposes: query constraining and/or filtering, and query result set labeling.
随便看	Sibelius的意思 Sibelius Seamount的意思 Sibenik的意思 sibeniks的意思 sib的意思 Siberan tick typhus的意思 Siberia的意思 Siberia Abyssal Plain的意思 Siberian的意思 siberian airmass的意思 Siberian alder bark的意思 Siberian Anticyclone的意思 Siberian apricot的意思 Siberian Burnet Root的意思 Siberian Cedar的意思 Siberian Chronicles的意思 Siberian clematis stem的意思 Siberian cocklebur flower的意思 siberian cocklebur fruit的意思 Siberian Cocklebur Herb的意思 Siberian cocklebur leaf的意思 Siberian cocklebur root的意思 Siberian Cocklour Fruit的意思 Siberian columbine meadowrue herb or rhizome and root的意思 Siberian Columbine Meadowrue Root or Herb的意思