Skip to main content
IBM Redbooks

DB2 Cube Views: A Primer

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.

thumbnail 

Published on 05 September 2003

  1. .PDF (11.2 MB)
 Order hardcopy
Share this page:
 
 

ISBN-10: 0738499730
ISBN-13: 9780738499734
IBM Form #: SG24-7002-00

Authors: Corinne Baragoin, Geetha Balasubramaniam, Bhuvaneshwari Chandrasekharan, Landon DelSordo, Jan B. Lillelund, Julie Maw, Annie Neroda, Paulo Pereira and Jo A. Ramos

menu icon

Abstract

Business Intelligence and OLAP systems are no longer limited to the privileged few business analysts: they are being democratized by being shared with the rank and file employee demanding a Relational Database Management System (RDBMS) that is more OLAP-aware.

DB2 Cube Views and its cube model provide DB2 the ability to address multidimensional analysis and become an actor in the OLAP world.

This IBM Redbooks publication focuses on the innovative technical functionalities of IBM DB2 Cube Views V8.1 to store multidimensional metadata in DB2 catalog; to build automatically model-based summary tables to speed up query performance; and to provide an advanced API to allow other Business Intelligence partners’ tools to benefit from both metadata exchange and improved query performance.

This book positions the new functionalities and their benefits, so you can understand and evaluate their applicability in your own Business Intelligence and OLAP system environment. It provides information and examples to help you to get started planning and implementing the new functionalities.

Table of Contents

Part 1. Understand DB2 Cube Views

Chapter 1. An OLAP-aware DB2

Chapter 2. DB2 Cube Views: scenarios and benefits

Part 2. Build and optimize the DB2 Cube Model

Chapter 3. Building a cube model in DB2

Chapter 4. Using the cube model for summary tables optimization

Part 3. Access dimensional data in DB2

Chapter 5. Metadata bridges overview

Chapter 6. Accessing DB2 dimensional data using Office Connect

Chapter 7. Accessing dimensional data in DB2 using QMF for Windows

Chapter 8. Using Ascential MetaStage and the DB2 Cube Views MetaBroker

Chapter 9. Meta Integration of DB2 Cube Views within the enterprise toolset

Chapter 10. Accessing DB2 dimensional data using Integration Server Bridge

Chapter 11. Accessing DB2 dimensional data using Cognos

Chapter 12. Accessing DB2 dimensional data using BusinessObjects

Chapter 13. Accessing DB2 dimensional data using MicroStrategy

Chapter 14. Web services for DB2 Cube Views

Part 4. Appendixes

Appendix A. DataStage: operational process metadata configuration and DataStage job example

Appendix B. Hybrid Analysis query performance results

Appendix C. FAQs, diagnostics, and tracing

Appendix D. DB2 Cube Views stored procedure API

Appendix E. The case study: retail datamart