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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.