RE: Experiences / Notes on Data Warehousing on 9iRAC on Linux

From: Leslie Tierstein <Leslie.Tierstein_at_visionchain.com>
Date: Wed, 19 May 2004 11:51:50 -0400
Message-ID: <MBEKKMMKENFAJFKKNHDOGEEDCEAA.Leslie.Tierstein@visionchain.com>

We have had major performance problems with Business Objects running on top of a multi-gigatype data warehouse. Granted, we've been using full-client BO, rather than WEBI, but I think the architectural drawbacks are the same -- that is, BO wants to build a cube on the Business Objects server, so it ends up bringing masses of data to that server from the database. We are still trying to do some diagnosis, but our current suspicions are that the BO server is, in fact, memory-bound. (And here the IT department was trying to blame the Oracle database.)

Another issue is that the end users don't like the user interface provided for building adhoc queries and have basically declared they don't think they'll ever use it. As of now, I'm not quite aure what the objections are, just that it is "too complicated". The BO repository has been pre-populated with filters, metrics, etc, for their use, but it's still "too complicated".

Leslie
Leslie Tierstein
Senior Consultant
Vision Chain, Inc.
The Standard for Demand Data Networks
phone: 202-261-3549

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Hemant K Chitale Sent: Wednesday, May 19, 2004 10:18 AM
To: oracle-l_at_freelists.org
Subject: Experiences / Notes on Data Warehousing on 9iRAC on Linux

My organisation is planning to migrate the current DWH [8i on Solaris] to 9iRAC on Linux. The initial load will be 50GB, growing to 500GB in 6 months.

I am looking for notes / "how-tos" / tips / traps on implementing a DWH on 9iRAC on Linux.
Current extraction from the ODS is by combinations of FTP and PLSQL jobs. We would be looking at products like Ascential DataStage or BusinessObjects DataIntegrator
or the like for ETL and BusinessObjects WebIntelligence for Reporting/Querying.

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional http://web.singnet.com.sg/~hkchital

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

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

Received on Wed May 19 2004 - 10:46:44 CDT