Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
Oracle OLAP
open-in-new
<h2 id="logical-components">Logical components</h2> <p>The Oracle Database OLAP Option offers: </p> <ul><li>an OLAP analytic <a href="/facts/Software_engine/QhIAMMBg"> engine</a></li> <li><a href="/facts/Workspace/S0kLVSke">workspaces</a></li> <li>an analytic workspace manager (AWM)<a class="footnote-ref" id="fnref:1" href="#fn:1"><sup>1</sup></a></li> <li>a <a href="/facts/Worksheet/IHTfRyEQ">worksheet</a> environment</li> <li>OLAP DML for <a href="/facts/Data_Definition_Language/Hx7aNozV"> DDL</a> and <a href="/facts/Data_Manipulation_Language/eeJRDUEl"> DML</a></li> <li>an interface from <a href="/facts/SQL/UjQLJcYm">SQL</a></li> <li>an analytic workspace <a href="/facts/Java_(programming_language)/9ScgFyAL"> Java</a> <a href="/facts/Application_programming_interface/GMlN4vUr"> API</a></li> <li>a Java-based OLAP API</li></ul> <h2 id="physical-implementation">Physical implementation</h2> <p>The Oracle database tablespace CWMLITE stores OLAPSYS <a href="/facts/Logical_schema/K0EbrogL">schema</a> <a href="/facts/Object_(computer_science)/eX99dtAw"> objects</a> and integrates Oracle Database OLAP Option with the <a href="/facts/Oracle_Warehouse_Builder/r1rWbdXj">Oracle Warehouse Builder</a> (OWB).<a class="footnote-ref" id="fnref:2" href="#fn:2"><sup>2</sup></a> The CWMLITE name reflects the use of CWM — the <a href="/facts/Common_Warehouse_Metamodel/LMLXyAub">Common Warehouse Metamodel</a>, which <a href="/facts/Oracle_Corporation/0z14FygH">Oracle Corporation</a> refers to as "Common Warehouse Metadata". </p> <h2 id="see-also">See also</h2> <ul><li><a href="/facts/Business_intelligence/ftThn7Wf">Business intelligence</a></li> <li><a href="/facts/Comparison_of_OLAP_servers/lbSpe9vz">Comparison of OLAP servers</a></li> <li><a href="/facts/Essbase/ppp99hMX">Essbase</a></li></ul> <h2 id="external-links">External links</h2> <ul><li><a href="https://www.oracle.com/database/technologies/olap.html">Oracle OLAP</a>, retrieved 2023-05-28</li></ul> <h2 id="references">References</h2> <ol> <li id="fn:1"><p>"Introduction to the OLAP Java API" in Oracle OLAP Java API Developer's Guide, 11g Release 1 (11.1), 2007. Chapter 1. <a href="http://download.oracle.com/docs/cd/B28359_01/olap.111/b28127/intro.htm#sthref19" target="_blank">http://download.oracle.com/docs/cd/B28359_01/olap.111/b28127/intro.htm#sthref19</a> <a href="#fnref:1" class="footnote-back-ref">↩</a></p></li> <li id="fn:2"><p>"Using Oracle Warehouse Builder to create OLAP warehouses" (DOC). Retrieved 31 March 2011. <a href="http://download.oracle.com/owsf_2003/36921_Claterbos.doc" target="_blank">http://download.oracle.com/owsf_2003/36921_Claterbos.doc</a> <a href="#fnref:2" class="footnote-back-ref">↩</a></p></li> </ol>