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