[prev in list] [next in list] [prev in thread] [next in thread]
List: odtug-warehouse-l
Subject: Re: New project
From: shaik sajid <shaiksajid_sks () yahoo ! com>
Date: 2005-03-04 12:21:47
Message-ID: F001.005F3D45.20050304042147 () fatcity ! com
[Download RAW message or body]
Thanks for your kind information
Amin Adatia <amin_adatia@hotmail.com> wrote:How about doing a model for the DW?
Regards
Amin Adatia (amin@knowtech.ca)
KnowTech Solutions Inc. (www.knowtech.ca)
(613) 226-8378 Mobile (613) 864-8378
----- Original Message -----
To: Multiple recipients of list ODTUG-WAREHOUSE-L
Sent: Wednesday, March 02, 2005 10:26 PM
Greetings,
I am new to data warehousing and have just joined a company that is looking to set up \
a data warehouse/data marts/storefronts to port out data to various consumers.
Looking to me as the new "Oracle guy", my boss has dumped this project in my lap. I'd \
appreciate some pointers, if you feel inclined.
Here's the situation:
We're a publishing company. Our back end databases are mainly on Oracle 9i with all \
kinds of front ends - mostly Foxpro and Java. There are four main OLTP systems that \
are interrelated - editorial (from which the publications get sourced), advertising \
(additional advertising content and features in the published information), sales \
(contracts for advertising), and financials. Each system is home-grown, no third \
party systems.
The idea is to take the OLTP system information once a day, aggregate/transform the \
information through a business rules system, and then further transform it depending \
on the target audience. Other requirements are that it should be available 24/7, that \
the OLAP system should have no effect on the OLTP system, and that only changes to \
the source data should be ported across not exporting the entire OLTP system once a \
day.
I've seen the article about Oracle Discoverer in the last ODTUG journal, which was \
helpful in imagining what goes into this type of system. Other Oracle-specific \
features I'm interest in are advanced queuing (covered in the last Oracle \
Professional journal), replication, materialized views, and the Oracle \
Datawarehousing tool.
At the ODTUG conference last summer I attended several presentations about other \
datawarehousing tools. Are there other options out there I should be looking at? \
Papers that might provide a framework?
Thanks in advance for your comments,
Tom Berthoff
Thomcomp, Inc.
Work e-mail: tberthoff@thomcomp.com
---------------------------------
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
[Attachment #3 (text/html)]
<DIV>Thanks for your kind information<BR><BR><B><I>Amin Adatia \
<amin_adatia@hotmail.com></I></B> wrote: <BLOCKQUOTE class=replbq \
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"> <META \
content="MSHTML 6.00.2900.2604" name=GENERATOR> <STYLE></STYLE>
<DIV><FONT face=Arial size=2>How about doing a model for the DW?</FONT></DIV>
<DIV><BR>Regards<BR>Amin Adatia (<A \
href="mailto:amin@knowtech.ca">amin@knowtech.ca</A>) <BR>KnowTech Solutions Inc. (<A \
href="http://www.knowtech.ca/">www.knowtech.ca</A>)<BR>(613) 226-8378 \
Mobile (613) 864-8378 </DIV> <BLOCKQUOTE dir=ltr style="PADDING-RIGHT: 0px; \
PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: \
0px"> <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> <A \
title=tom.berthoff@verizon.net href="mailto:tom.berthoff@verizon.net">Tom \
Berthoff</A> </DIV> <DIV style="FONT: 10pt arial"><B>To:</B> <A \
title=ODTUG-WAREHOUSE-L@fatcity.com \
href="mailto:ODTUG-WAREHOUSE-L@fatcity.com">Multiple recipients of list \
ODTUG-WAREHOUSE-L</A> </DIV> <DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, \
March 02, 2005 10:26 PM</DIV> <DIV style="FONT: 10pt arial"><B>Subject:</B> New \
project</DIV> <DIV><BR></DIV>
<DIV><SPAN class=608500403-03032005><FONT face=Arial \
size=2>Greetings,</FONT></SPAN></DIV> <DIV><SPAN class=608500403-03032005><FONT \
face=Arial size=2></FONT></SPAN> </DIV> <DIV><SPAN \
class=608500403-03032005><FONT face=Arial size=2>I am new to data warehousing and \
have just joined a company that is looking to set up a data warehouse/data \
marts/storefronts to port out data to various consumers.</FONT></SPAN></DIV> \
<DIV><SPAN class=608500403-03032005><FONT face=Arial \
size=2></FONT></SPAN> </DIV> <DIV><SPAN class=608500403-03032005><FONT \
face=Arial size=2>Looking to me as the new "Oracle guy", my boss has dumped this \
project in my lap. I'd appreciate some pointers, if you feel \
inclined.</FONT></SPAN></DIV> <DIV><SPAN class=608500403-03032005><FONT face=Arial \
size=2></FONT></SPAN> </DIV> <DIV><SPAN class=608500403-03032005><FONT \
face=Arial size=2>Here's the situation:</FONT></SPAN></DIV> <DIV><SPAN \
class=608500403-03032005><FONT face=Arial size=2></FONT></SPAN> </DIV> \
<DIV><SPAN class=608500403-03032005><FONT face=Arial size=2>We're a publishing \
company. Our back end databases are mainly on Oracle 9i with all kinds of front ends \
- mostly Foxpro and Java. There are four main OLTP systems that are interrelated - \
editorial (from which the publications get sourced), advertising (additional \
advertising content and features in the published information), sales (contracts for \
advertising), and financials. Each system is home-grown, no third party \
systems.</FONT></SPAN></DIV> <DIV><SPAN class=608500403-03032005><FONT face=Arial \
size=2></FONT></SPAN> </DIV> <DIV><SPAN class=608500403-03032005><FONT \
face=Arial size=2>The idea is to take the OLTP system information once a day, \
aggregate/transform the information through a business rules system, and \
then further transform it depending on the target audience. Other \
requirements are that it should be available 24/7, that the OLAP system should \
have no effect on the OLTP system, and that only changes to the source data should be \
ported across not exporting the entire OLTP system once a day.</FONT></SPAN></DIV> \
<DIV><SPAN class=608500403-03032005><FONT face=Arial \
size=2></FONT></SPAN> </DIV> <DIV><SPAN class=608500403-03032005><FONT \
face=Arial size=2>I've seen the article about Oracle Discoverer in the last ODTUG \
journal, which was helpful in imagining what goes into this type of system. Other \
Oracle-specific features I'm interest in are advanced queuing (covered in the last \
Oracle Professional journal), replication, materialized views, and the Oracle \
Datawarehousing tool.</FONT></SPAN></DIV> <DIV><SPAN class=608500403-03032005><FONT \
face=Arial size=2></FONT></SPAN> </DIV> <DIV><SPAN \
class=608500403-03032005><FONT face=Arial size=2>At the ODTUG conference last summer \
I attended several presentations about other datawarehousing tools. Are there other \
options out there I should be looking at? Papers that might provide a \
framework?</FONT></SPAN></DIV> <DIV><SPAN class=608500403-03032005><FONT face=Arial \
size=2></FONT></SPAN> </DIV> <DIV><SPAN class=608500403-03032005><FONT \
face=Arial size=2>Thanks in advance for your comments,</FONT></SPAN></DIV> <DIV><SPAN \
class=608500403-03032005><FONT face=Arial size=2></FONT></SPAN> </DIV> \
<DIV><SPAN class=608500403-03032005><FONT face=Arial size=2>Tom \
Berthoff</FONT></SPAN></DIV> <DIV><SPAN class=608500403-03032005><FONT face=Arial \
size=2>Thomcomp, Inc.</FONT></SPAN></DIV> <DIV><SPAN class=608500403-03032005><FONT \
face=Arial size=2>Work e-mail: <A \
href="mailto:tberthoff@thomcomp.com">tberthoff@thomcomp.com</A></FONT></SPAN></DIV> \
<DIV><SPAN class=608500403-03032005><FONT face=Arial \
size=2></FONT></SPAN> </DIV></BLOCKQUOTE></BLOCKQUOTE></DIV><p> <hr \
size=1>Celebrate Yahoo!'s 10th Birthday! <br> <a \
href="http://birthday.yahoo.com/netrospective/">Yahoo! Netrospective: 100 Moments of \
the Web</a>
Desktop 2005 - You're Virtually There! February 15-17, 2005
Visit http://www.odtug.com for details. Computer + internet required.
Keynote Speakers: Bill Inmon, Sohaib Abbasi and Thomas Kurian.
--
Author: shaik sajid
INET: shaiksajid_sks@yahoo.com
Fat City Hosting, San Diego, California -- http://www.fatcity.com
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-WAREHOUSE-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).
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic