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: Data Warehouse experts, a simple question for you|

RE: Data Warehouse experts, a simple question for you|

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Thu, 23 May 2002 12:38:41 -0800
Message-ID: <F001.00469D80.20020523123841@fatcity.com>


Rachel,
 Having the same backup problems as talked about in the article, I can agree with the views and opinions of the author. The second part of the article dealt with the placement of the data and type of operation on the data in the same instance.
  I have mixed emotions about that idea.   With the proper horse power and memory and the published features of 9i, why can't the two co-exist happily on the same instance? The 9i features allow for multi database block size and auto tune is provided that should handle the data-mart and OLTP processes quite well. Partitioning is "tunable" by combining it with the LMT, and you can set the size parameters in LMT to make optimal use of the disks. The updating of the data from the current process to the datamart would be fast because the data resides on the same server and the backup procedure would automatically provide the archive data in 2 places, the archivelogs and the original source table. After backup of the warehoused data you could systematically delete the partition and create new ones for the new data.
  On the other side of the coin, if the server dies nothing at all works. At what price does the cost of the needed horse power and disks out weigh the possible advantages of one instance? The author talked about mirrored drives and splitting the mirrors to perform backups. I would rather use hot backups but I do not know the volume of data activity he was talking about. I do not think it was the datamart data he was talking about. That would be a large amount of data activity to not use hot backups. Could the archivelogs be that large if you use hot backups compared to the archivelogs generated during normal processing and split mirrors?

Just a few thoughts.
Good luck with your project,
Ron
ROR mm  

>>> wisernet100_at_yahoo.com 05/23/02 03:40PM >>>
ron,

Even without reading the rest of the article, my first instinct is to

scream NOOOOOOOOOOOOOOOOOOOOOO

and, after reading the article, it appears the author agrees with me.

I have a sane boss. an intelligent boss. He is management, not damagement.... he has the same concerns about what the end user wants and what the consultants say they/we can accomplish in the time we have.

Rachel
--- Ron Rogers <RROGERS_at_galottery.org> wrote:
> Rachel,
> This was just received from the "SearchDatabase" email and I
thought
> it might be of interest to you.
> .................
> TODAY'S BI STRATEGY: Placement of the data warehouse (Part 2)
>
> By William McKnight, SearchCRM Expert
>
> Another question I received [last week at the Data Warehousing
> Institute World Conference] had to do with placement of the data
> warehouse and the potential myriad of other databases (staging, data
> marts, ODS, etc.) in the data warehouse architecture. The
recommended
> approach by the questioner's management was to place them all on the
> same DBMS instance -- the same instance that the main operational
> source system was on...
>
> Read the rest of this strategy at:
> http://www.searchCRM.com/tip/1,289483,sid11_gci825543,00.html
>
> Read the first part of this strategy at:
>

http://searchcrm.techtarget.com/tip/1,289483,sid11_gci824982,00.html?FromTaxonomy=/pr/288366

>
>
> ....................
> Ron
> ROR mm
>
> >>> wisernet100_at_yahoo.com 05/23/02 01:43PM >>>
> Dennis,
>
> We are active participants in the process. We are also making an
> offer
> to someone with an extensive background in developing data
> warehouses,
> which will help me to sleep much more comfortably at night :)
>
> Rachel
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ron Rogers
> INET: RROGERS_at_galottery.org
>
> 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).



Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_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_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: Ron Rogers
  INET: RROGERS_at_galottery.org

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 Thu May 23 2002 - 15:38:41 CDT

Original text of this message

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