Multi-Dimensional Clustering Table Size Estimator for DB2

Wednesday Aug 23rd 2006 by DatabaseJournal.com Staff
Share:

A utility for determining space requirements and simplifying administration of Multi-Dimensional Clustering (MDC) tables in DB2.

[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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved