Slash query response time for BI and DW applications

The Oracle OLAP option has built-in data compression and on-the-fly calculation features that work so fast you may not need to maintain Materialized Views for summary information anymore.

In a new white paper, Escendo Corp shows the equivalent of a star schema with 5 dimensions and 2 million rows in the fact table giving 1 second query response time for any of the possible 42 million summary rows that are not materialized. With performance this fast, there is no need to
adjust an MV when users ask for different slices of data.

This 1 second response time is available through a standard Oracle SQL view to any application or tool that can access the database - Discoverer, APEX, OBIEE, SQL Developer, etc. Creating that view is done with the click of the mouse using Escendo Analytics.

To download the paper, go to http://www.escendo.com.
Under News Headlines, the link is under the article:

Read about how to Dramatically Optimize BI Queries using an important part of Oracle OLAP:
Compressed Composites.

Or, use this link:

http://www.escendo.com/dc/Escendo_Compressed_Composites_WP_032210.pdf

Escendo has released Version 1.1 of Escendo Architect.

This release includes full conversion capabilities for almost all objects from existing Express OFA applications in addition to enhancements to release 1.0.

Escendo Architect now provides full access to the entire suite of Oracle OLAP objects and functionality.