'dimension table' is a correct and usable phrase in written English.
It is a data modeling technique used in databases to create a multi-dimensional view of data. For example: The data analyst populated the dimension table with customer information.
In this paper, we propose an algorithm that achieves the above goal because it incorporates two features, namely, grain preservation and the minimal distance from each dimension table to the fact table.
However, the AHP method produces performance alternatives for each dimension (Table 7).
Age showed negative associations with FCCHL but not with the communicative dimension (Table 3).
In our data warehouse, the relationship between a dimension table and an auxiliary table is 1 N.
Samples of IR64 from the irrigated treatment formed a distinct cluster in the first axis, with indole as the compound most strongly correlated with that dimension (Table 2).
We can furthermore look at patterns of correlations among the students' estimated abilities based on the items in each dimension (Table 3).
The dimensional model consists of star joins and dimension tables.
Based on this concept, we propose the imageDW, an extended data warehouse with dimension tables specifically designed to support one or more perceptual layers.
Sixteen of the tables are dimension tables for storing general descriptive information, and the other ten are fact tables for detailing various facts that are captured in the lifecycle of construction projects.
The snowflake schema represents a dimensional model which is composed of a central fact table and a set of constituent dimension tables which can be further broken up into subdimension tables.
Star queries and star query transformations are used to transparently change the way queries are executed, typically between a single very large fact table and multiple much smaller dimension tables in a data warehouse.
