Home > Applications Gallery > By Data Source > Oracle Solutions: Unique Optimizations

Solutions: MicroStrategy and Oracle

JD Edwards · Peoplesoft · Siebel

Overview | Unique Optimizations | Certifications & Memberships

Unique Optimizations

The MicroStrategy BI platform takes full advantage of Oracle’s highly parallel query processing architecture to deliver the highest performance and efficiency levels.

MicroStrategy's open architecture truly leverages the capabilities of the Oracle Application Server and OracleAS Portal. MicroStrategy's deployment-ready portlets require no additional programming when delivering detailed reports and run seamlessly on OracleAS Portal server. This allows users to integrate insight from the MicroStrategy platform into both enterprise portals, with complete OLAP manipulations, as well as sophisticated visualizations via Dynamic Enterprise Dashboards™.

Oracle-specific SQL syntax

Analytic functions (OLAP functions)
CASE expressions
Full outer joins
Set operators
Sub queries

Multi-pass SQL for analytical sophistication

Use of no logging tables
Use of global temp tables
Use of inline views
Use of WITH clause
Statistics collection on intermediate results

Integration with key Oracle features

Real Application Clusters
Materialized views
Bit mapped indexes
Oracle OLAP option
Oracle advanced data types: XML, spatial

Extensions to Oracle functionality

Aggregate awareness with physical summary tables
Middle-tier caching via Intelligent Cubes
Middle-tier report caching
Application-level partitioning

Oracle Application Server

Web Universal on Oracle Application Server
Java SDK on Oracle Application Server
Oracle AS 9.0.3 is certified

OracleAS Portal

PIK integration with OracleAS Portal

Supported Web Servers

Apache 2.0
Apache 1.3.26