The Oracle Database OLAP Option implements
On-line Analytical Processing (OLAP) within an
Oracle database
Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation.
It is a database commonly used for running online t ...
environment.
Oracle Corporation
Oracle Corporation is an American multinational computer technology corporation headquartered in Austin, Texas. In 2020, Oracle was the third-largest software company in the world by revenue and market capitalization. The company sells da ...
markets the Oracle Database OLAP Option as an extra-cost option to supplement the "Enterprise Edition" of its database. (Oracle offers
Essbase
Essbase is a multidimensional database management system (MDBMS) that provides a platform upon which to build analytic applications. Essbase began as a product from Arbor Software, which merged with Hyperion Software in 1998. Oracle Corporation a ...
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
*
workspace
Workspace is a term used in various branches of engineering and economic development.
Business development
Workspace refers to small premises provided, often by local authorities or economic development agencies, to help new businesses to estab ...
s
* an analytic workspace manager (AWM)
* a
worksheet
A worksheet, in the word's original meaning, is a sheet of paper on which one performs work. They come in many forms, most commonly associated with children's school work assignments, tax forms, and accounting or other business environments. Softw ...
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
The word schema comes from the Greek word ('), which means ''shape'', or more generally, ''plan''. The plural is ('). In English, both ''schemas'' and ''schemata'' are used as plural forms.
Schema may refer to:
Science and technology
* SCHEMA ...
objects and integrates Oracle Database OLAP Option with the
Oracle Warehouse Builder
Oracle Warehouse Builder (OWB) is an ETL tool produced by Oracle that offers a graphical environment to build, manage and maintain data integration processes in business intelligence systems.
Features
The primary use for OWB is consolidation ...
(OWB).
The CWMLITE name reflects the use of CWM — the
Common Warehouse Metamodel, which
Oracle Corporation
Oracle Corporation is an American multinational computer technology corporation headquartered in Austin, Texas. In 2020, Oracle was the third-largest software company in the world by revenue and market capitalization. The company sells da ...
refers to as "Common Warehouse Metadata".
See also
*
Business intelligence
Business intelligence (BI) comprises the strategies and technologies used by enterprises for the data analysis and management of business information. Common functions of business intelligence technologies include reporting, online analytical pr ...
*
Comparison of OLAP servers
*
Essbase
Essbase is a multidimensional database management system (MDBMS) that provides a platform upon which to build analytic applications. Essbase began as a product from Arbor Software, which merged with Hyperion Software in 1998. Oracle Corporation a ...
External links
Oracle Technology Networkon Oracle OLAP, retrieved 2006-11-30
References
Oracle software
Online analytical processing
{{software-stub