Encyclopedia

dimension table

Also found in: Dictionary, 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-2025 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
Key words: fact table, dimension table, star schema, star join, SQL query, multi-column index, and cardinality.
Star schema and star join processing in garment relational database environment
Copyright © 2003-2025 Farlex, Inc Disclaimer
All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional.