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.

Download White Paper

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher
IBM
File Format
PDF
Date Published
Apr 9, 2008
Format
White Papers
Topics
Business Intelligence - Data Warehousing, Database Management

Similiar White Papers

The ROI of Data Governance - A Revenue Generation Perspective

The ROI of Data Governance - A Revenue Generation Perspective

"Concentrating on increasing revenue necessarily means paying attention to metrics such as return on investment (ROI). T

Publisher: DataFlux  |  Tags: data, metadata

Building a Hybrid Data Warehouse Model

Building a Hybrid Data Warehouse Model

This paper discusses the hybrid design and provides a fully functional reference implementation. The system runs on Orac

Publisher: Oracle  |  Tags: data, database, warehouse

MDM Components and the Maturity Model

MDM Components and the Maturity Model

Any effective master data management program requires a mix of technologies to achieve success. This white paper by Davi

Publisher: DataFlux  |  Tags: data, data management, management, mdm

Building a Data Quality Scorecard for Operational Data Governance

Building a Data Quality Scorecard for Operational Data Governance

" Operational data governance is the manifestation of the processes and protocols necessary to ensure that an acceptable

Publisher: DataFlux  |  Tags: data, management

SQL Server: A practical guide to Backup, Recovery and Troubleshooting

SQL Server: A practical guide to Backup, Recovery and Troubleshooting

This e-book provides working scenarios, policy/procedure and best practice for database backup and recovery. It is for

Publisher: Imceda  |  Tags: database, disaster recovery, management, service management

IBM White Papers

Integrated Change & Release Management

Integrated Change & Release Management

Short deadlines and constant change epitomize the challenges of software and systems development. Routine change increas

Publisher: IBM  |  Tags: software

Webcast: Introducing IBM Lotus Quickr -- The Fastest Way to Share Content with Your Teams

Webcast: Introducing IBM Lotus Quickr -- The Fastest Way to Share Content with Your Teams

Have you heard the buzz about Lotus Quickr? Lotus Quickr is IBM's new Web 2.0-based team collaboration software that is

Publisher: IBM  |  Tags: collaboration software, software

An examination of server consolidation: the trends that can drive efficiencies and help businesses gain a competitive edge

An examination of server consolidation: the trends that can drive efficiencies and help businesses gain a competitive edge

This white paper provides a starting point for organizations contemplating server consolidation. It includes an overview

Publisher: IBM  |  Tags: cost savings, server

Build Strong, Flexible J2EE apps With a WebSphere Cluster Environment

Build Strong, Flexible J2EE apps With a WebSphere Cluster Environment

When building a strong, extensible, and flexible J2EE application, one needs to consider several factors. One important

Publisher: IBM  |  Tags: application server, management, server

Deploying Oracle ASM With Oracle 10g RAC on AIX With IBM System Storage DS8000 and DS6000 Advanced Features

Deploying Oracle ASM With Oracle 10g RAC on AIX With IBM System Storage DS8000 and DS6000 Advanced Features

The IBM System Storage DS8000 and DS6000 Disk Storage systems are both high performance storage systems that offer expan

Publisher: IBM  |  Tags: data, database, server