dimension table


Also found in: Dictionary, Thesaurus, Medical, Legal, Wikipedia.

dimension table

In a data warehouse, one side of the dimensional model set up for the department or organization. For example, the product dimension would be a list of the organization's products, the time dimension would be the calendar periods represented and so on. See dimensional modeling.
References in periodicals archive ?
Snowflake schema is refinement of star schema where some dimensional hierarchy is further splitting (normalized) into a set of smaller dimension tables (Fig 7), forming a shape similar to snowflake.
Assets and liabilities statement analysis star schema mainly includes: fact table of assets and liabilities statement (including accounting time, assets and liabilities index code, opening amount, closing amount, changes, change ratio, etc.), dimension table of assets and liabilities statement (including index code, index name, etc.), dimension table of time.
To obtain the description of students' information or time dimension, the fact table can be linked to the dimension table as follows:
You should redundantly model any dimensional contact fields such as state or area code in a separate dimension table. This preserves dimensional query performance and avoids the difficult task of tracking address history (at least in the warehouse).
If users and users' query complexity is considered, a way should be found to place version numbers by grouping within a dimension table, allowing any recursion to be performed against the dimension.
Key words: fact table, dimension table, star schema, star join, SQL query, multi-column index, and cardinality.

Full browser ?