Dimension Table

Definition - What does Dimension Table mean?

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.

Techopedia explains Dimension Table

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.

Share this:

Connect with us

Email Newsletter

Join thousands of others with our weekly newsletter

The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.