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.

Further White Paper Details
PublisherIBM File FormatPDF
Date PublishedNovember 2006 Downloads14
FormatWhite Papers   
Topics
  • Featured White Papers
Thin clients switch on digitally excluded

Thin clients switch on digitally excluded

Case study: Digital inclusion project tackles social exclusion in Liverpool more

Renault goes multilingual

Renault goes multilingual

Case study: Translation tech turns docs into 23 languages… more


Quick Sitemap Links: