Re: 8i or 9i for Data Warehouse

From: <Prasada.Gunda1_at_hartfordlife.com>
Date: Tue, 30 Oct 2001 13:08:11 -0800
Message-ID: <F001.003B89B8.20011030130018@fatcity.com>

Very good white papers/technical articles related to DW enhancements/new features in 9i are available on Oracle Technet. They are pretty good. Please take a look at those and see whether you can use those in your DW project.

Hope this helps.
Regards

                                                                                       
                            
                    YTTRI  Lisa                                                        
                            
                    <lisa.yttri_at_c        To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>       
                    nh.com>              cc:                                           
                            
                    Sent by:             Subject:     8i or 9i for Data Warehouse      
                            
                    root_at_fatcity.                                                      
                            
                    com                                                                
                            
                                                                                       
                            
                                                                                       
                            
                    10/30/2001                                                         
                            
                    03:05 PM                                                           
                            
                    Please                                                             
                            
                    respond to                                                         
                            
                    ORACLE-L

Hi everyone -

I have been asked to do the database planning for a fairly large data warehouse. The warehouse is currently in Sybase and is about 160 GB. They are planning to move to Oracle very soon.

My questions - does it make more sense to spin it up on 8.1.7 or 9? (This will be a pretty good size Solaris machine). Are there newer features in 9i
that would really benefit them? I am looking at partitioning tables and using some bit-mapped indexes - something they don't have today. I was originally looking at 8.1.7, but now that 9 has been around for a little bit, I'm wondering if any of you have some advice (good or bad) regarding version 9.

Any and all comments are appreciated.

Thanks -
lisa

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: YTTRI  Lisa
  INET: lisa.yttri_at_cnh.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_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.com
-- 
Author: 
  INET: Prasada.Gunda1_at_hartfordlife.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_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 Tue Oct 30 2001 - 15:08:11 CST