"dimension tables" is correct and usable in written English.
You can use it to refer to tables in a database that are used to store data related to a particular aspect, such as time, location, or product category. For example: "The data analyst created new dimension tables to track sales figures by region."
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.
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.
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.
This methodology was then demonstrated in the design of a data warehouse for data exploration in stream ecology resulting in a multidimensional data model with a fact table representing biological stream survey measurements and dimension tables representing spatial and categorical site and landscape variables.
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.
In our data warehouse, the relationship between a dimension table and an auxiliary table is 1 N.
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).
We can furthermore look at patterns of correlations among the students' estimated abilities based on the items in each dimension (Table 3).
