Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Choices for a data warehouse dB

RE: Choices for a data warehouse dB

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 28 Apr 2003 13:21:39 -0800
Message-ID: <F001.0058AC6C.20030428132139@fatcity.com>


Saira

   My limited experience says it is far better to have the data warehouse on a separate platform, and it looks like that is what you are doing. Eventually you will probably need Oracle Partitioning Option, and you can only purchase that if you have Oracle Enterprise Edition. Past that, you'll probably have to decide whether the platform you select is beefy enough to handle your warehouse.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, April 28, 2003 3: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-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).
--

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

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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-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). Received on Mon Apr 28 2003 - 16:21:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US