RE: Datawarehouse Sizes.....informal poll.

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Thu, 06 Dec 2001 19:25:50 -0800
Message-ID: <F001.003D7111.20011206190017@fatcity.com>

 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: ORACLE-L_at_fatcity.com
Cc: MohanR_at_STARS-SMI.com
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_at_STARS-       To:     Multiple recipients of
list ORACLE-L <ORACLE-L_at_fatcity.com>        
                    SMI.com>             cc:

                    Sent by:             Subject:     Datawarehouse
Sizes.....informal poll.                        
                    root_at_fatcity.c

                    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: MohanR_at_STARS-SMI.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: Mohan, Ross
  INET: MohanR_at_STARS-SMI.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).

Received on Thu Dec 06 2001 - 21:25:50 CST