| ERD or STAR SCHEMA [message #139517] |
Wed, 28 September 2005 07:45  |
singhsanjay
Messages: 2
Registered: September 2005
Location: london
|
Junior Member |
|
|
hello ,
i am designing a decision support system for the retail store, for that i need a database that will cantain all the information about the products ,sales etc.
as a usuall practice of designing a database is based on the ERD
i.e. we follows the ERD for creating the tables , but if u see the all the queries need to be answered are answered by the star schemma that means your tables would be different from the ones that were used in ERD . so
can anyone please help me out from this confussion which one should i follow for creating the datbase ERD or STAR SCHEMA.
regards
sanjay
|
|
|
|
| Re: ERD or STAR SCHEMA [message #144335 is a reply to message #139517] |
Wed, 26 October 2005 01:40  |
kiran
Messages: 503
Registered: July 2000
|
Senior Member |
|
|
In designing of any datawarehouse (or) datamart the most commonly used schema types are Star Schema and Snowflake Schema.
Star Schema: In the star schema design, a single object (the fact table) sits in the middle and is radially connected to other surrounding objects (dimension lookup tables) like a star.
Snowflake Schema: The snowflake schema is an extension of the star schema, where each point of the star explodes into more points. The main advantage of the snowflake schema is the improvement in query performance and joining smaller lookup tables.
You can use any of these schemas for your data model.
Can you be bit clear on your post.
--Kiran.
[Updated on: Wed, 26 October 2005 01:40] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
