Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    Join Date
    Nov 2008
    Posts
    8

    Question How'd they do it?

    I was wondering how sites like match.com, chemistry.com (and those other similar sites) set up their databases? I know they are huge databases and the exact setup is a secret, but I was hoping someone could give me a little insight (possibly a rough ER diagram)?
    Thanks!

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    for those of us unfamiliar with those sites, why don't you give us a best-guess sketch of what you think their ER diagram looks like

    if you have any questions about what you've done, we'll be happy to answer them
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Quote Originally Posted by r937
    for those of us unfamiliar with those sites,
    Don't play coy, Rudy. Your profile kept showing up on my list over and over until I removed the word "lederhosen" from my preferences section.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    ...and replaced it with..?
    George
    Home | Blog

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    ...and replaced it with "flump".

    But so far...no bites.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by blindman
    But so far...no bites.
    not even a mild hickey?

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Nov 2008
    Posts
    8
    Anyway, seems like those sites are too distracting. How about facebook/myspace? I am just curious how they set up their databases to keep track of members and profile info. Can anyone help me out with a rough ER diagram?

  8. #8
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Sure, where is it?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  9. #9
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    posted by someone else in some other thread today...

    http://dbdesign-sn.blogspot.com/
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  10. #10
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    My own databases has more than two tables, 'cause I have more than two friends.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  11. #11
    Join Date
    Nov 2008
    Posts
    8
    Thanks for the link r937! How would the person's profile information fit in? Would there be a third table?

  12. #12
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    no, it would be part of the Accounts table, along wit username, firstname, etc
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  13. #13
    Join Date
    Nov 2008
    Posts
    8
    Would it be bad practice to create a third table (i.e. ProfileInfo) with the profile info and have a username foreign key to identify ProfileInfo with the Account? It just seems that Account table could get really big eventually.

  14. #14
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    "could get really big eventually" leading to adding a separate table with a key relationship between them is a beautiful example of premature optimization

    certainly your objection cannot be the number of rows, because with an extra table, instead of N rows, there'd be 2N rows

    so your concern has to be row length, right?

    just how big, in your opinion, would be "too" big?

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  15. #15
    Join Date
    Nov 2008
    Posts
    8
    I guess what I was thinking is that maybe if you decided down the road that you wanted to add a new field to the user profiles it would be easy to append to a separate ProfileInfo table. I am just thinking about the large social networking sites. If they change or add a field in the user profiles, this would require a change in the Account table. Would it make more sense to have the separate ProfileInfo table? Or is it better to throw all their member info into the one Accounts table?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •