From stephane_paquette@yahoo.com Tue, 27 Mar 2001 01:12:14 -0800 From: =?iso-8859-1?q?paquette=20stephane?= Date: Tue, 27 Mar 2001 01:12:14 -0800 Subject: Re: OLAP again Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi, You are right , Oracle 8i and Oracle Express are 2 different products. In Oracle 9i, Oracle will integrated OLAP server capabilities called OLAP Services, like Microsoft ;-) I'm not sure that OLAP tools are the answer to your needs. OLAP tools are used to stored data in a cube format to slice and dice the data not to explore the data or handle massive storage. If you're looking for a tool to do industrial strenght reporting, go with Brio. It beats all the other products for massive reports, on the negative side it's not as nice looking as Business Objects or Cognos. --- Witold Iwaniec a écrit : > 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@novalistech.com > http://www.novalistech.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Witold Iwaniec > INET: wiwaniec@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@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). ===== Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant stephane_paquette@yahoo.com __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: stephane_paquette@yahoo.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@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).