Skip Headers

Oracle9i OLAP User's Guide
Release 2 (

Part Number A95295-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page Go to next page
View PDF

The Oracle9i Integrated Relational-Multidimensional Database

Oracle provides multidimensional technology within the database. Organizations no longer need to choose between a multidimensional OLAP database and a relational database. By integrating OLAP into the database, Oracle provides the power of a multidimensional database while retaining the manageability, scalability, and reliability of the Oracle database and the accessibility of SQL. The Oracle database provides the functionality of a specialized analytic database while eliminating the need for a separate database system.

The advantages of a single integrated relational-multidimensional database when compared to two separate relational and multidimensional databases are many:

The Oracle relational database and Oracle OLAP provide complementary functionality to support the most versatile and high performance applications. The database and SQL engine provide detail data, summary management, and one-dimensional calculations using the SQL-99 OLAP extensions. Oracle OLAP expands these capabilities to provide forecasting, modeling, what-if scenarios, and multidimensional calculations.