OraFAQ Forum: Data Integration

Home » Developer & Programmer » Data Integration » star schema

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

star schema [message #93216]

Sun, 23 November 2003 05:19

ramu
Messages: 82
Registered: February 2001

Member

my question is what is star schema and what is snow flake star schema.
when we go for the star schema and when we go for the snow flake star schema
please send the answer immediately

Report message to a moderator

Re: star schema [message #93219 is a reply to message #93216]

Sat, 29 November 2003 03:09

anil kumar
Messages: 16
Registered: August 2002

Junior Member

Star Schema is a multidimensional model where each of its disjoint dimension is represented in single table.

Snow flake schema is similler to a star schema.
Snow flake schema is normalized multidimension schema where each of disjoint dimention is represented in multiple tables.
Star Schema can become a snow flake schema.

Report message to a moderator

Re: star schema [message #93250 is a reply to message #93216]

Sun, 22 February 2004 09:06

umair khan
Messages: 1
Registered: February 2004

Junior Member

my question is what is star schema and what is snow flake star schema.
when we go for the star schema and when we go for the snow flake star schema
please send the answer immediately

Report message to a moderator

Re: star schema [message #93267 is a reply to message #93216]

Tue, 30 March 2004 04:35

bashir
Messages: 3
Registered: May 2002

Junior Member

I want to know the difference between star schema VS snowflake.
thanks

Report message to a moderator

Re: star schema [message #93276 is a reply to message #93216]

Wed, 14 April 2004 13:33

Anonymous
Messages: 39
Registered: March 2002

Member

Check this out. A snowflake star schema is the same thing, but contains dimension rollups making it look like a snowflake in an ER Diagram.

Stars: A Pattern Language for Query Optimized Schema

[Updated on: Mon, 24 April 2006 02:03] by Moderator

Report message to a moderator

Re: star schema [message #93313 is a reply to message #93219]

Sun, 04 July 2004 23:54

VijaySarathi
Messages: 1
Registered: July 2004

Junior Member

Hi,
Is there anything like star flake schema..We know snow flake schema. But got confused about this star flake schema.
Anybody, any idea on the same would be appreciated.

Thanx and regards
Vijay

Report message to a moderator

Re: star schema [message #93371 is a reply to message #93216]

Fri, 24 September 2004 19:34

farook
Messages: 6
Registered: September 2004

Junior Member

my question is what is star schema and what is snow flake star schema.
when we go for the star schema and when we go for the snow flake star schema
please send the answer immediately

Replies:

Report message to a moderator