-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: googlyboy4u
Message 6 in Discussion
What I suggested was just a
straightforward approach. It is true that with my approach the table can grow
exponentially at a later date. I guess with the approach I suggested, you just
cannot avoid the repetition of User ID coulmn. The NetPointer's approach is what
I wanted to suggest initially, but it will become an overhead if all users have
their own unique preferences. But as the number of users grow, there is a
possibility that more and more users will end up sharing the same preference
order. In that case, it is advisable to go for NetPointer's approach which in
fact is more normalised than the approach I suggested. However, please note you
will not be able to avoid repetition of Preference Style column just like that
of User ID column with my approach.
By the way, I am not an expert on
databases, its just that I like playing with databases as a matter of interest.
So experts, I welcome your suggestions ...
Regards,
Sachin
----- Original Message -----
From:
DotNetSaavy (Mr.BabuRaj)
To: BDOTNET
Sent: Friday, September 12, 2003 10:15
AM
Subject: Re: SQL Server Database Design
ISSUE
New Message on BDOTNET
SQL
Server Database Design ISSUE
Reply
Reply to Sender Recommend
Message 5 in
Discussion
From: DotNetSaavy (Mr.BabuRaj)
Sachin,
This is what I've done, but the feedback I got was that
that the table can grow exponentially on a later date,
where we will end up with redundant entries for UserId in the
Preferences table.For production server is it advisable to have
this kind of a design.Please advise.
I have a junction table as below where I'm currently
storing the user preferences
Table Name :- User Preferences
UserId PropertyId
Priority Order
******
******** *****
Ind1 1 500
Ind1 2
33
Ind1 3
92
Ind1 4
101
-
-
-
-
-
-
-
-
-
Ind1
600
24
don't you think user id column has redundant (repeating)
values of userid, in this case we will end up having 100*600 =
60K entries in the table.If there is no other work around then
I'm ready to stick to this approach.Do you have any comments on
NetPointer's approach above
Thanks
BabuRaj
View other groups in this
category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
