# Oracle OLAP

> Mediated Wiki article. Canonical URL: https://mediated.wiki/source/Oracle_OLAP
> Markdown URL: https://mediated.wiki/source/Oracle_OLAP.md
> Source: https://en.wikipedia.org/wiki/Oracle_OLAP
> Source revision: 1329264023
> License: Creative Commons Attribution-ShareAlike 4.0 International (https://creativecommons.org/licenses/by-sa/4.0/)

The '''Oracle Database OLAP Option''' implements [On-line Analytical Processing](/source/OLAP) (OLAP) within an [Oracle database](/source/Oracle_database) environment. [Oracle Corporation](/source/Oracle_Corporation) markets the Oracle Database OLAP Option as an extra-cost option to supplement the "Enterprise Edition" of its database. (Oracle offers [Essbase](/source/Essbase) for customers without the Oracle Database or who require multiple data-sources to load their cubes.) 

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 and can take the place of multi-dimensional materialized views, simplifying Oracle data-warehouse management and speeding up query response.

== Logical components ==

The Oracle Database OLAP Option offers:

* an OLAP analytic [engine](/source/software_engine)
* [workspace](/source/workspace)s
* an analytic workspace manager (AWM)<ref> [http://download.oracle.com/docs/cd/B28359_01/olap.111/b28127/intro.htm#sthref19 "Introduction to the OLAP Java API"] in ''Oracle OLAP Java API Developer's Guide, 11g Release 1 (11.1)'', 2007. Chapter 1.</ref>
* a [worksheet](/source/worksheet) environment
* OLAP DML for [DDL](/source/Data_Definition_Language) and [DML](/source/Data_Manipulation_Language)
* an interface from [SQL](/source/SQL) 
* an analytic workspace [Java](/source/Java_(programming_language)) [API](/source/Application_programming_interface)
* a Java-based OLAP API

== Physical implementation ==

The Oracle database tablespace <code>CWMLITE</code> stores OLAPSYS [schema](/source/logical_schema) [object](/source/Object_(computer_science))s and integrates Oracle Database OLAP Option with the [Oracle Warehouse Builder](/source/Oracle_Warehouse_Builder) (OWB).<ref>{{cite web|url=http://download.oracle.com/owsf_2003/36921_Claterbos.doc |title=Using Oracle Warehouse Builder to create OLAP warehouses |format=DOC |accessdate=31 March 2011 }}</ref> 
The CWMLITE name reflects the use of CWM — the [Common Warehouse Metamodel](/source/Common_Warehouse_Metamodel), which [Oracle Corporation](/source/Oracle_Corporation) refers to as "Common Warehouse Metadata".

== See also ==
* [Business intelligence](/source/Business_intelligence)
* [Comparison of OLAP servers](/source/Comparison_of_OLAP_servers)
* [Essbase](/source/Essbase)

== External links ==
* [https://www.oracle.com/database/technologies/olap.html Oracle OLAP], retrieved 2023-05-28

== References ==
<References/>

OLAP
Category:Online analytical processing

{{Database-software-stub}}

---
Adapted from the Wikipedia article [Oracle OLAP](https://en.wikipedia.org/wiki/Oracle_OLAP) by Wikipedia contributors ([contributor history](https://en.wikipedia.org/wiki/Oracle_OLAP?action=history)). Available under [Creative Commons Attribution-ShareAlike 4.0 International](https://creativecommons.org/licenses/by-sa/4.0/). Changes may have been made.