Ross,
A DW is defined by purpose and design, not by size.
A collection of Data Marts, ( tables for star joins ) is not
a DW either. DW's are used to create data marts.
If you don't already have the database books from
Kimball, I suggest you acquire them.
Data Warehouse Toolkit
http://www.amazon.com/exec/obidos/ASIN/0471153370/ref=pd_sim_books/104-7669992-7054323
Data Warehouse Lifecycle Toolkit
http://www.amazon.com/exec/obidos/ASIN/0471255475/ref=pd_sim_books/104-7669992-7054323
These are must haves for understanding and designing DW.
Jared
"Mohan, Ross"
<MohanR@STARS- To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
SMI.com> cc:
Sent by: Subject: Datawarehouse Sizes.....informal
poll.
[EMAIL PROTECTED]
om
12/06/01 01:55
PM
Please respond
to ORACLE-L
Informal survey: Datawarehousing.
Limiting Assumption: "A necessary and sufficient condition for defining
something
to be a datawarehouse is the
amount of data
to be stored."
Question/Poll: Given the above ridiculous constraint, at/above what size
can something
be considered a data warehouse?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan, Ross
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).