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.
随便看	marine geography marine geological laboratory marine geological process marine geological survey marine geological tester marine geologic map marine geologic survey Marine geology marine geology and geomorphology laboratory Marine Geology Panel marine geomagnetic anomaly marine geomagnetic map marine geomagnetic survey marine geomorphology marine geomorphy marine geophysical prospecting marine geophysical survey marine geophysics marine geoscience marine geotechnical test marine geotechnique marine geotechnology marine gis database marine glue marine glue caulking