January 28, 2011 at 11:44 pm
hello to everyone, i want to design database for a small social networking site which i am developing in ASP.NET and C#.please help me for designing the structure of database..and queries required for designing it..:-)
January 29, 2011 at 3:07 pm
shitaljagtap610 (1/28/2011)
hello to everyone, i want to design database for a small social networking site which i am developing in ASP.NET and C#.please help me for designing the structure of database..and queries required for designing it..:-)
Do you have business specifications?
Start by translating such business specs into a ER model then, if in doubt please post specific questions.
Hope this points you in the right direction.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 30, 2011 at 11:51 pm
thanks for suggesting for ER-DIAGRAM.but i already have drawn it..in my system i am going to store videos,photos,documents such as pdf,xls,doc,ppt ,profile info, friends,all that are used for social networking..so my question is suggest me for which system of database should be used for particulars?whether file system is necessary somewhere? or normal database can work? please help me..and also help about normalisation of database..
January 31, 2011 at 12:52 am
What version of SQL?
For normalisation, have a look at this series: http://michaeljswart.com/?p=1036. Also ask your DBA, he may know database design.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 31, 2011 at 6:17 am
I have to say, you're asking for a complete system design on a rather complicated set of requirements, which you haven't completely provided. Many of us are paid to do this kind of work. We help people here on SSC with specific questions to well-defined problems, not perform free consulting work. If you're hitting a specific problem in your design and you have a question about it, please, post it and we'll do our best to help out. But if you think we're going to design the entire system for you, free of charge, so that you can then deliver it to your business for a profit...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 31, 2011 at 9:52 am
shitaljagtap610 (1/30/2011)
thanks for suggesting for ER-DIAGRAM.but i already have drawn it..in my system i am going to store videos,photos,documents such as pdf,xls,doc,ppt ,profile info, friends,all that are used for social networking..so my question is suggest me for which system of database should be used for particulars?whether file system is necessary somewhere? or normal database can work? please help me..and also help about normalisation of database..
wow wow wow... that's a lot of questions in a very small number of words
1- If you have your ER Model you should be able to translate it into (let's say) a 3NF model - isn't it?
2- "which system of database should be used?" This is a SQL Server forum, which answer as you expecting to get? Any rdbms database would do, would you tell us about volume?
3- Please define "normal database"
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.February 7, 2011 at 8:39 am
good luck, i've read that most social sites are designed for use on noSQL databases
February 7, 2011 at 8:47 am
alen teplitsky (2/7/2011)
good luck, i've read that most social sites are designed for use on noSQL databases
MYSpace is the notable exception which uses SQL Server.
here's how they did it incase the OP wants to replicate their setup
February 7, 2011 at 8:58 am
does anyone still use myspace?
i read the summary and facebook gets a lot more density per server with the noSQL version they are using. I think it's Hadoop, but not sure. unless you need ACID there is no real reason to use SQL server over something else
February 7, 2011 at 9:17 am
alen teplitsky (2/7/2011)
does anyone still use myspace?
compared to facebook no, but it is still a massive site in its own right.
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy