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
> [EMAIL PROTECTED]
> http://www.novalistech.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Witold Iwaniec
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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
[EMAIL PROTECTED] - Work - preferred address
[EMAIL PROTECTED] - private
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
