Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Warehouse design: snowflake vs star schemas

Warehouse design: snowflake vs star schemas

From: Alexandre Gorbatchev <alexandre.gorbatchev_at_avermann.de>
Date: Mon, 07 Oct 2002 04:54:02 -0800
Message-ID: <F001.004E209A.20021007045402@fatcity.com>


Dear Data Warehouse Experts,

Could you please share you experience with snowflake and star data models. How do you choose between them?
What problems may arise?
Is star schema preferred for Oracle?
What is users' experience with those schemas? Which one they like more and why?
Which one is easier to implement and easier ETL? Are there other patterns for DW?

I would like to check/confirm/change my possibly subjective point of view to more objective perspective. I would appreciate your thoughts or links where I can review practical conclusions.

TIA,
Alexandre

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Alexandre Gorbatchev
  INET: alexandre.gorbatchev_at_avermann.de

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Mon Oct 07 2002 - 07:54:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US