Oracle OLAP
Oracle OLAP Database Option implements On-line Analytical Processing (OLAP) within an Oracle database environment. Oracle Corporation markets Oracle OLAP as an extra-cost option to supplement the "Enterprise Edition" of its database.
As of Oracle Database 11g, the Oracle database optimizer can transparently redirect SQL queries to levels within the OLAP Option cubes. The cubes are managed like and can take the place of multi-dimensional materialized views simplifying Oracle data warehouse management and improving speed of query response.
Logical components
Oracle OLAP offers:
- an OLAP analytic engine
- workspaces
- an analytic workspace manager (AWM[1]
- a worksheet environment
- OLAP DML for DDL and DML
- an interface from SQL
- an analytic workspace Java API
- a Java-based OLAP API
Physical implementation
The Oracle database tablespace CWMLITE stores OLAPSYS schema objects and integrates Oracle OLAP with the Oracle Warehouse Builder (OWB).
[2]
(The CWMLITE name reflects the use of CWM — the Common Warehouse Metamodel, which Oracle Corporation refers to as "Common Warehouse Metadata".
External links
- Oracle Technology Network on Oracle OLAP, retrieved 2006-11-30
References
- ^ "Introduction to the OLAP Java API" in Oracle OLAP Java API Developer's Guide, 11g Release 1 (11.1), 2007. Chapter 1.
- ^ http://72.14.253.104/search?q=cache:w-t40Ql_C-4J:ftp.oracle.com/owsf_2003/36921_Claterbos.doc+%2Bcwmlite+%2B+%22common+warehouse%22&hl=en&ct=clnk&cd=2
 | This software article is a stub. You can help Wikipedia by expanding it. |