by Burleson Consulting
The Data Warehouse Development Life Cycle
Online Analytical Processing and Oracle
Data Warehouses And Multidimensional Databases
There is also a difference between the presentation style of OLAP
systems and multidimensional databases. OLAP engines generally have
an SQL-like interface that allows ad hoc queries to be processed
against the warehouse data, using SQL select operations, and
producing output lists of query results. Multidimensional databases
use a spreadsheet metaphor as the front end, and the end user models
the dimensions and views the resulting summary as a cross-tabulation
in the spreadsheet. Table 5.3 shows the differences between the
presentation and display styles for OLAP and MDDB servers.
Series variable dimensions
Table 5.3 Differences between OLAP and MDDB presentations.
The base rule is simple: If the data looks like it will fit well
into a spreadsheet, it is probably well-suited to an MDDB--or at
least an MDDB representation. However, it is not always best to
apply this general rule to data warehouse architectures. Many
techniques exist for allowing Oracle databases to appear to be OLAP
servers or multidimensional databases.
This is an excerpt from "High Performance
like Oracle tuning, you may enjoy the book
Oracle Tuning: The Definitive
Reference , with
over 900 pages of BC's favorite tuning tips &
You can buy it
directly from the publisher and save 30%, and get
instant access to the code depot of Oracle tuning
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today.