Are you looking to squeeze the most out of IBM InfoSphere Warehouse’s Cubing Services?
If so, you’ll definitely want to get a copy of the new IBM Redbook, InfoSphere Warehouse: Cubing Services and Client Access Interfaces. Best of all, you can download the entire book for free.
Here’s the abstract below:
Formerly known as DB2® Warehouse, InfoSphere™ Warehouse enables a unified, powerful data warehousing environment. It provides access to structured and unstructured data, as well as operational and transactional data. In this IBM® Redbooks® publication, we provide a brief overview of InfoSphere Warehouse, but the primary objective is to discuss and describe the capabilities of one particular component of the InfoSphere Warehouse, which is InfoSphere Warehouse Cubing Services.
InfoSphere Warehouse Cubing Services is designed to provide a multidimensional view of data stored in relational databases, for significantly improved query and analysis capabilities. For this, there are particular schema designs that are typically used for these data warehouse and data mart databases, called dimensional, or cube, models. Optimization techniques are used to dramatically improve the performance of the OLAP queries, which are a core component of data warehousing and analytics.
InfoSphere Warehouse Cubing Services works with business intelligence (BI) tools, and clients, such as Cognos® , Alphablox, and Microsoft® Excel® , through client interfaces, to accelerate OLAP queries from many data sources. We describe these interfaces and provide examples of how to use them to improve the performance of your OLAP queries.
Here’s the chapter outline:
- The cubing lifecycle
- Modeling using IBM InfoSphere Warehouse Design Studio
- Creating the Cube Model
- Designing Cubes
- Deploying and managing the cube
- Cube server performance
- Using the Excel Client Interface
- Cognos and the cube model
- Using the Alphablox Client Interface
- MDX Overview
- Best Practices
IBM Redbooks are technical “how-to” guides. The IBM International Technical Support Organization (ITSO) has been developing and publishing these popular guides for over 40 years. To see more Redbooks, visit http://www.redbooks.ibm.com/.