Tech moves fast! Stay ahead of the curve with Techopedia!
Join nearly 200,000 subscribers who receive actionable tech insights from Techopedia.
A dimension table is a database table referencing defining pieces of information or attributes for particular records in a primary database table. Experts may describe a dimension table as part of a "database schema" or a database conceptual map that shows the logical construction of the database. Typically, any dimension table has a primary key that links all of the dimension records to the individual primary records.
The idea with dimension tables is that users can do specific and precise queries to filter and group dimension information for research and business intelligence purposes. The use of a surrogate key helps to join the dimension data to the data from the primary record.
For example, a dimension table may hold certain "measurements" or attributes about a company's products, such as weight, size, shipping protocol, bar code information or warehouse location information. Enterprise users would then use SQL to search for records meeting particular attributes. In many cases, dimension tables are de-normalized, a process that involves adding redundant data after normalization. De-normalization of dimension tables can be done to reduce the necessity of join commands, or for other purposes.