Facebook database schema

Comments and faves

1. ★

   layalk, danieljsanders, jeffmicklos, [nivs], and 39 other people added this photo to their favorites.

2. 

   heavydave (48 months ago | reply)

   Hi. What software application did you use to generate this image?

3. 

   shagrath123123 (40 months ago | reply)

   good work !

4. 

   royalchaos (35 months ago | reply)

   I'm sure this has been created using Visual Studio class designer.

5. 

   Alex Seif (27 months ago | reply)

   How is this known to be the facebook scheme??

6. 

   chitttybang (22 months ago | reply)

   cannot read :|

7. 

   TTownMan (19 months ago | reply)

   With a tool like VirtualMagnifyingGlass, one can read parts of this schema.

   I think this is a great attempt to deduce the basic object-relationship structure of Facebook. Kudos to the author for putting this on paper for people to think about.

   But as complex as it looks, I don't think it's anywhere near the complexity of the actual Facebook schema.

   For example, at the top right there is a class (or table) called AffiliationType, with the pre-defined values College, High School, Work, Geography. But AffiliationType should really be a dynamic list. I.e. someone should be able to define an AffiliationType (e.g. "Grade School", "Pen Pal") and add it to the table.

   Then, can anyone define an AffiliationType? Then there'd be potentially redundant definitions. So, someone's got to have the rights to define those entries. An admin person, perhaps. And if an AffiliationType is never used, it should be removed at some point. With a system this large, you have to find places where you can clear out truly unused data. So there should be a process collecting AffiliationType usage, with that info stored in a table.

   etc.

8. 

   @documentalista_ | Fernando Leandro (18 months ago | reply)

   Rami Shedom Very good job! congratulations, can you help me? I would like to show your design to my students in class, but the tables come out pixelated and not seen. ¿Could you send an image a little bigger?, Thank you!!!. docucumentalistadigital@gmail.com

9. 

   drew.politique (17 months ago | reply)

   That is not a database schema, this is a class schema diagram. It not quite the same thing. @TTownMan, I totaly agree with you : actually, even the class schema of facebook should be at least a little bit more complex.

10. 

    parkmenen1 (15 months ago | reply)

    could you please send me a bigger copy of this picture on parkmenen@hotmail.com
    Thank you Martin

11. 

    parkmenen1 (15 months ago | reply)

    I'm just a little bit confused bcse I can see the feed class in the schema:-(

12. 

    khumalo2011 (13 months ago | reply)

    This looks interesting. Please send me a bigger image at sithembisophp@hotmail.com

13. 

    mantap27 (13 months ago | reply)

    I'm very interested in seeing this photo, but i can't do that because it is very small.. Can u send me a bigger one? Email: azlans27@gmail.com

14. 

    Demin3m (12 months ago | reply)

    I am also very interested in this photo, can you please send me a bigger version. Thanks.
    d3minem@gmail.com

15. 

    ronnyldinho (11 months ago | reply)

    And the LIKE's table?

16. 

    kadirgul (11 months ago | reply)

    could you pls send me bigger one kadirgul@gmail.com .. thank you

17. 

    usman_bajwa (10 months ago | reply)

    please send me bigger picture, bajwa345@gmail.com

18. 

    ilesh21190 (10 months ago | reply)

    plz send me a big copy of this image on ilesh21190@gmail.com... thankx in anticipation

19. 

    alexgenovese (8 months ago | reply)

    Can you send me a big copy of this image, please !? genolale@yahoo.it!
    Thank you so much!

20. 

    afsincelik (8 months ago | reply)

    Here is the big one, farm2.static.flickr.com/1296/533233247_d8ac5a fbec_o.jpg

21. 

    Mukiii (5 months ago | reply)

    easy thing to do ( :

22. 

    mallook2012 (5 weeks ago | reply)

    hi everyone can anyone help me to get the E-R diagram for the facebook and it's MAP ?!!

Want to format your comment?