112 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
multidimensional expressions (MDXs) as the query language. However, the data
is not copied or persisted in another storage mechanism, but remains in the DB2
relational database.
Cubing Services thus is what we refer to as a “multidimensional OLAP hot
cache.” That is, InfoSphere Warehouse Cubing Services loads data into a
multidimensional structure in memory.
That partial MOLAP structure can then deliver fast response times for the data
that is in memory cache. If a user of a query tool requests data that is not in the
cache, the Cubing Services engine generates queries to the relational database
to retrieve the data and builds a partial in-memory cube-lik ...