Jared, Thanks. I have the main RK book. Like it. Understand what little i have read of it. I am just interested in what folks thought about "size vs. DW definition" was.
I *do* think, tho, that "size does matter". I don't consider my shared E: drive a datawarehouse because it can support a star query, one user, and 300 MB of data. There is 'something' to do with the fact of...alot of data....skewed dimensions...regular updates...data cleaning...supporting mining ( and mining for a few tiny facts in a big haystack requires, after all, the big haystack ) Anyways. I figure anything under 250 GB doesn't even merit being called a data Warehouse. Maybe a data 7-11. <shrug> Thanks for the pointers and your thoughts. Ross -----Original Message----- To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: 12/6/2001 7:32 PM 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-7 669992-7054323 Data Warehouse Lifecycle Toolkit http://www.amazon.com/exec/obidos/ASIN/0471255475/ref=pd_sim_books/104-7 669992-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: 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).
