InfoSphere Warehouse: Cubing Services and Client Access Interfaces

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.