Sunday, March 28, 2010

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




2 comments:

  1. Ecorptrainings.com provides Oracle OLAP in hyderabad with best faculties on real time projects. We give the best online trainingamong the Oracle OLAP in Hyderabad. Classroom Training in Hyderabad India

    ReplyDelete
  2. Nice effort, very informative, this will help me to complete my task. Thanks for sharing it. Have a look at the process blogs to see more........................Please contact us for Oracle Fusion Financials Training

    ReplyDelete