Re: OLAP again

I'm no OLAP expert, but you may want to resarch ROLAP products, ROLAP being Relation Online Analytical Processing.

These tools are designed to allow OLAP functionality from your relational database.

Jared

On Mon, 26 Mar 2001, Witold Iwaniec wrote:

> Hi
>
> Our product uses quite complex data model and we are looking for
> ways to speed up data access, especially large reports in the
> range of 25,000+ records.
> One of the ideas was to look into OLAP, or now Business
> Intelligence, tools. After some reading it seems to me that OLAP is
> completely separate product - it is the Express Server that runs its
> own database, and tools like Express Objects, Express Analyzer
> that use the Oracle 9iAS and Express Server technology. You can
> still connect to your Oracle database or import/export the data for
> analysis, reporting, etc. but you have to set up completely new
> environment.
>
> We hoped that we could use OLAP tools to point to Oracle 8i
> database and use it to provide faster access to our complex data
> model but it does not seems so straightforward. Or maybe I
> missed a tool. Could someone, please, correct me?
>
> Thanks
>
> Witold
> ======================================
> Witold Iwaniec
> Senior Software Developer
> NovaLIS Technologies
> wiwaniec_at_novalistech.com
> http://www.novalistech.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Witold Iwaniec
> INET: wiwaniec_at_novalistech.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address jkstill_at_teleport.com - private

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).