471,354 Members | 1,396 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,354 software developers and data experts.

How to create a database for social networking?


i am trying to design a social networking site for my project.

i have to design the database for the social networking with user profile and friends contact list as like facebook and orkut.

can anyone help me to implement the database design with fast and accuracy retrieval of data from the database using the Index and Hash table techniques

Aug 16 '10 #1
1 4656
Jerry Winston
145 Expert 100+
I'm guessing that, because you are reinventing a social networking site rather than taking advantage the API's of the already existing offerings, this is more an academic project than professional.
Your initial question was very, very broad so I'll give you an answer that covers the most content.
First, this project is about indexes and hash tables. Study these topics first, the art of properly indexing tables is very simple but profoundly subtle and a proper solution may not always jump out at you right away.
Second, after you have the skill set, plan,plan,plan! Properly diagramming a project before you code will save you many HOURS and PAGES of code. Start with a verbal diagram of what your program will do. From the written description you can create a visual representation of the objects that will create your data system. With graphical representations of your objects it is often easier to see their relationships or discover new relationships that may have been missed in the initial verbal review.
Third, Revise. Take any changes from step 2 and revise them in your written description of your database.

Although it seems like a lot to do before you even open the Workbench, proper planning will save you many, many nights and long days trying to repair defective code, broken relationships, and data integrity errors.
Aug 16 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by phaedrus | last post: by
1 post views Thread by harlow.28 | last post: by
10 posts views Thread by Fenix [Youth Director] | last post: by
1 post views Thread by pmm101 | last post: by
4 posts views Thread by avh | last post: by
1 post views Thread by Grouchy.Oldgit | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.