MDC 101: A Simple Contrast between Traditional and Multidimensional Clustering Tables

To best understand the advantages of MDC tables and what they can offer your environment, a contrast and comparison with traditional tables is beneficial. Let's look at a business that is most interested in three specific dimensions of data: an associated stock keeping unit (SKU) that represents a sold product, the store location where the product was sold, and the date the sale took place.

Figure 2.1 illustrates a sample of data stored in a traditional table.

Figure 2.1. A traditional table.

Assuming you want to organize your data across these multiple dimensions ...

Get DB2® Version 8: The Official Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.