Home > Getting Started with Oracle... > What is Oracle OLAP?
![]() Previous |
![]() Next |
Oracle Database offers the first and only embedded OLAP server. Oracle OLAP provides native multidimensional storage and speed-of-thought response times when analyzing data across multiple dimensions. The database provides rich support for analytics such as time series calculations, forecasting, advanced aggregation with additive and nonadditive operators, and allocation operators. These capabilities make Oracle Database a complete analytical platform, capable of supporting the entire spectrum of business intelligence and advanced analytical applications.
Oracle OLAP is fully integrated into Oracle Database:
Cubes and other dimensional objects are first class database objects represented in the Oracle data dictionary.
The OLAP engine runs within the kernel of Oracle Database.
Dimensional objects are stored in Oracle Database in their native multidimensional format.
Security is administered in the standard way, by granting and revoking privileges to Oracle Database users and roles.
Applications query multidimensional objects using standard SQL SELECT
statements.
Because Oracle OLAP is integrated into Oracle Database, you employ one database and use standard administration, security, and development tools. You have the power of multidimensional analysis along with the reliability, availability, security, and scalability of Oracle Database.