Chapter 1. An OLAP-aware DB2 9
know what SQL to generate in order to respond to queries that are outside of the
MOLAP database.
All styles of OLAP need the same basic metadata: the cube model and a
mapping of that model to the relational source. A common factor in most of these
scenarios is that at some point, a query against the relational database is going
to be generated. However, up till now the relational database, unlike the other
tools described above, has had no metadata at all describing the nature of the
OLAP structure within the database.
1.2 DB2 UDB V8.1 becomes OLAP-aware
This chapter started by discussing the evolution of technologies in order to meet
the ever increasing demands of the business intelligence market place. This ...