Oracle OLAP

From Wikipedia, the free encyclopedia

Oracle OLAP 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.

Contents 1 Logical components 2 Physical implementation 3 External links 4 References

[edit] 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

[edit] 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".

[edit] External links

• Oracle Technology Network on Oracle OLAP, retrieved 2006-11-30

[edit] References

1. ^ "Introduction to the OLAP Java API" in Oracle OLAP Java API Developer's Guide, 11g Release 1 (11.1), 2007. Chapter 1.
2. ^ 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