Oracle OLAP

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.

Logical components

Oracle OLAP offers:

• an OLAP analytic engine
• workspaces
• a workspace manager
• 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). (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

---