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 |
[edit] 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
[edit] Physical implementation
The Oracle database tablespace CWMLITE
stores OLAPSYS schema objects and integrates Oracle OLAP with the Oracle Warehouse Builder (OWB). [1] (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, retrievced 2006-11-30
[edit] References
- ^ 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