Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Model?

Status
Not open for further replies.

astra1

Programmer
Sep 17, 2002
38
US
Hi,

We are in the process of creating a Data Warehouse which will involve data in Tera Bytes. Client's requirement is to use SQL 2K as the RDBMS. Can any one tell me as to which is the Data Model we shall use (star/ Snow Flake etc) and why?

Thanx in Adv.

Vish
 
the data model all depends on the nature of the data

(by the way, a star model is a type of snowflake)

it's like asking "client's requirement is to use a Lexus for the car, can anybody tell me where we should drive it?"

well, not exactly like that, but...

in general, you will be trading off denormalization for access speed

modelling is not really a science, more of an art


rudy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top