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).