SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 DB Design New Application
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

alxtech
Yak Posting Veteran

66 Posts

Posted - 05/29/2013 :  23:04:36  Show Profile  Visit alxtech's Homepage  Reply with Quote
Hello Forum,
I am in the process of designing the database of a new application that It will be a web application, language/framework not yet defined.
The application will:
register users into the system (personal information)
all users will have the option in the application to select/unselect 500+ values yes/no and that value will be store in the database for later retrival by the web application.

Question, the challenge on this application is to design the DB in a way that will be efficient for the future, Example, when the count of users gets to 1000 users, each user over 500 values in its record.

i dont know if i am making my self clear, but to sumarrize i will say that each user will have cards from 1 - 500 some cards will be on and some off, i need to save that data for each user in the database.

thank you for any suggestion.

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 05/30/2013 :  01:44:17  Show Profile  Reply with Quote
few options
1. use EAV model ie a separate table which will have userid,property,setvalue which will store properties against set values as rows

2. Make 500 attributes as sparse columns and set 1 for true cases

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

alxtech
Yak Posting Veteran

66 Posts

Posted - 05/30/2013 :  10:58:20  Show Profile  Visit alxtech's Homepage  Reply with Quote
Thanks, i will research your suggestions, i am not familiar with EAV.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 05/31/2013 :  02:04:16  Show Profile  Reply with Quote
quote:
Originally posted by alxtech

Thanks, i will research your suggestions, i am not familiar with EAV.



See

http://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000