Database Management White Papers
Best Practices IBM DB2 Multi-Dimensional Clustering in SAP NetWeaver Business Intelligence (BI)
Overview Multi-Dimensional Clustering (MDC) is a unique feature of IBM DB2 for Linux, UNIX and Windows (DB2 LUW) that allows physically clustering the data in a table along multiple dimensions. This feature is especially beneficial for query performance in business intelligence applications that use star and snowflake schemas and process large amounts of data with restrictions on several dimensions. MDC has been integrated in SAP NetWeaver Business Intelligence (BI) applications. This paper provides an overview of MDC and its implementation in SAP NetWeaver BI. It gives guidelines and recommendations for selecting MDC dimensions for SAP NetWeaver BI objects and it shows the performance improvements that can be achieved with MDC.
| Publisher | IBM | File Format | |
|---|---|---|---|
| Date Published | November 2006 | Downloads | 14 |
| Format | White Papers | ||
| Topics | |||



