|Oracle9i OLAP User's Guide
Release 2 (9.2)
Part Number A95295-01
Oracle9i Release 2 provides multidimensional analysis within the Oracle database. Oracle OLAP is the next generation of analytical engines and related software, providing an upgrade path from Oracle Express Server release 6.3.
The following sections describe the new features in Oracle9i OLAP:
The following list briefly describes the new features of Oracle OLAP.
The OLAP engine runs in the Oracle kernel, and analytic workspaces are stored as LOBs in relational tables.
The Oracle DBA uses one set of management tools for both the Oracle database and Oracle OLAP.
SQL applications can use the database table functions to access and manipulate data directly in the multidimensional OLAP data cache. Alternatively, relational views can be created for multidimensional data, which provides access to standard SQL.
Tools are available to help move data from relational tables into multidimensional objects in an analytic workspace, and to generate views of these objects so that applications can access workspace data using standard SQL.
OLAP applications that used SNAPI communications in Express Server 6.3 and earlier can upgrade to Oracle OLAP without substantially changing the application's Express language-based architecture.
The Oracle OLAP API is an all-Java application programming interface that is designed specifically to support multidimensional analysis.
PL/SQL interfaces to the OLAP catalog allow developers to query and update the logical multidimensional metadata model and map it to physical relational and analytic workspace data.
The Oracle OLAP catalog metadata supports star, snowflake, and multidimensional schema. The metadata supports level-based, parent-child, and complex dimension hierarchies.
Oracle Globalization Support provides the Oracle standard for internationalizing and localizing Oracle products. The character set encoding supports Unicode using the UTF-8 standard, which is a format that transforms all Unicode characters into a variable-length encoding of bytes. Its use in the database and Oracle OLAP allows text data in native languages to be passed between them without data loss or performance degradation.