Understanding Oracle OLAP Enhancements
From
the bestselling Oracle10g
book,
Oracle Database 10g New
Features.
by Mike Ault
Oracle 10g introduces new OLAP capabilities, using
the built-in analytical workspaces of the Oracle database.
There are many new PL/SQL and XML-based interfaces that aid in
the creation of workspaces, based on the cubes, dimensions,
measures, and calculations defined in the OLAP database
catalog. These new interfaces can be used by the new packages
provided or by Oracle Enterprise Manager to define and build
analytical workspaces. This removes the need for the user to
learn OLAP DML commands. Now you are in the familiar territory
of PL/SQL Packages and OEM!
See:
OLAP
Analytic Workspace XML objects
Oracle 10g also provides significant help with
performance enhancements. New parallel capabilities are
provided for aggregate and sql import operations, making it
much faster to load and materialize analytical workspaces from
relational database information. And 10g also
provides many hierarchy-related improvements.
We
will examine some of these improvements next.
Oracle OLAP Hierarchical
Tools
Oracle OLAP
dbms_aw_xml
