dimension table

Also found in: Dictionary, Thesaurus, Medical, 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.

Copyright © 1981-2019 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.

Mentioned in ?

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.

An overview of data warehousing and OLAP technology

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.

Study on computer audit based on OLAP technology

To obtain the description of students' information or time dimension, the fact table can be linked to the dimension table as follows:

Intelligent system for personalizing students' academic behaviors--a conceptual framework

After defining the fact tables, dimension tables and sub dimension tables, they are designed and the relationships between them are established.

An integrated web-based data warehouse and artificial neural networks system for unit price analysis with inflation adjustment/Integruota internetine duomenu saugyklos ir dirbtiniu neuroniniu tinklu sistema, skirta vieneto kainai analizuoti atsizvelgiant I infliacija

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).

Clearing the Clutter

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.

History changes, whether we want it to or not

Key words: fact table, dimension table, star schema, star join, SQL query, multi-column index, and cardinality.