Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Choices for a data warehouse dB
How big the DW ? Do you need partitionning ?
Oracle and DB2 has proven it can handle large volume, SQL Server not yet.
Since your data sources are Oracle than you can do the ETL in PL/SQL because all DBs are Oracle.
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 925-7187
stephane.paquette_at_standardlife.ca <mailto:stephane.paquette_at_standardlife.ca>
-----Original Message-----
Somani
Sent: Monday, April 28, 2003 4:12 PM
To: Multiple recipients of list ORACLE-L
We are trying to evaluate our choices for a database for a new data warehouse.
We currently have an Oracle 8.1.7.0.0 for production on AIX, another Oracle instance on W2K Server to support EDI and DB2 for WebSphere and Tivoli. The hardware we would be acquiring is probably an IBM x-Series with W2K Server as a platform.
I realize the breadth and depth of this question but if anyone would like to point out papers or books to read/study, or is willing to share their experiences, I'd be most grateful.
Thanks,
Saira
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: saira_somani_at_yahoo.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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-LReceived on Mon Apr 28 2003 - 17:07:02 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: stephane.paquette_at_standardlife.ca Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).