| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data Warehouse experts, a simple question for you|
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 mª¿ªm
>>> 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 mª¿ªm
>
> >>> 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).
-- 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
 |
 |