Tell me about Schemas?

Question Posted / arkchowdary

4 Answers
10845 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Tell me about Schemas?..

Answer / arkchowdary

Hi,
There are 4 types of schemas are there.

Star Schema,
Snowflake Schema,
Starflake Schema,

Galaxy Schema.

Satar Schema---------------- In a starshema a central
facttable connects a number of individual dimension tables
this is called as a starschema.
------------ It contains lessjoins so perfomance will be
increase.
------------ Starschema contains denormalized data.

Snowflake Schema------------- One dimension table split into
more than one dimension this is known as snowflakeschema.

---------------- Snowflake contains normalized data. There
are more joins in snowflake schema. so the performance is
degrade.

Galaxy Schema-------- Galaxyschema is known as a
Factconstollation schema. It requires number of facttables
and Dimension tables this is known as a Galaxyschema.

I hope it willbe helpful.

Is This Answer Correct ?

10 Yes

1 No

Tell me about Schemas?..

Answer / krishna

Schema is nothing but logical structure of data.
there of four types
1.star schema
2.snowflake schema
3.star flake schema
4.galaxy schema

Is This Answer Correct ?

2 Yes

0 No

Tell me about Schemas?..

Answer / swan

There are 2 types of schemas
1)star schema
2)snowflake schema

star schema is amiddle of the fact table it connects to the
no.of individual dimention tables.It containd de-normalized
data

snowflake schema is is a set of tables comprised of a
single, central fact table surrounded by normalized
dimension hierarchies. Each dimension level is represented
in a table. Snowflake schema implements dimensional data
structures with fully normalized dimensions. Star schemas
are an alternative to snowflake schema

Is This Answer Correct ?

0 Yes

1 No

Tell me about Schemas?..

Answer / satya

There are two types of schemas are there
1) Star schema
2) snow flake schema

Is This Answer Correct ?

4 Yes

6 No

Post New Answer