Multi-Dimensional Clustering Table Size Estimator for DB2

August 23, 2006

[From IBM alphaWorks]

Many applications, OLAP and data warehousing in particular, usually consider several attributes as dimensions for processing and maintenance. Performance and scalability of queries in this type of environment can be slow using the traditional relational-database approach based on one-dimensional clustering, in which an index composed of one or more key parts is identified as the basis for data clustering.

The article continues at http://www.alphaworks.ibm.com/tech/mdcsizer?open&ca=drs-aw-hom&S_TACT=106AH21W&S_CMP=AWRSSHOM