SitePoint Sponsor

User Tag List

Results 1 to 9 of 9
  1. #1
    SitePoint Enthusiast
    Join Date
    Sep 2010
    Posts
    63
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    graph database for social network

    I am doing a system similar to a social network. The number max of users must be eventually 50.000 or 70.000 at best.

    At the moment i am using mysqli+prepared statments. The ERD have now 30 tables, eventually may reach to 40 tables.

    So, my question is: i never used a graph database...i have the ERD done by mysql workbench and some code already developed. For the number expected of the users in this project, is recommended change from MySQL to a graph database? my sql code and database model can be availed? there is any advantage with this change?

    what do you think ?

    thanks

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    what's a graph database?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Enthusiast
    Join Date
    Sep 2010
    Posts
    63
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    well i never use a graph database.

    So, if i will have some advantage i will choose one of them.

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    where did you hear about a graph database?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    SitePoint Enthusiast
    Join Date
    Sep 2010
    Posts
    63
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i read that facebook, twitter, google, amazon, they use graph databases.

    my question is in my case, there is some advantage over mysqli and prepared statements ?

  6. #6
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    oh, that

    sorry, i have no experience with this

    does this help? -> Need a graph database like Twitter is built on? (YouTube)

    i would say for you to try using a graph database would be quite ambitious

    the first thing you're going to want to do is define your requirements for the relationships
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  7. #7
    SitePoint Enthusiast
    Join Date
    Sep 2010
    Posts
    63
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    at the moment i have a big problem. Some people recommend me move to Allegrograph (i never used), other people to use PostgreSQL because the recursive queries (i never used) and other tells to me to read Joe Celko's Trees and Hierarchies in SQL for Smarties (Morgan Kaufmann, 2004)


    i am completely lost.

  8. #8
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    like i said, i don't know any graph databases

    but i do know about celko's nested set model, and it's intended for a hierarchy

    you didn't mention what you're doing, but if it's not actually a graph but just a hierarchy, then that'd be the way to go -- you get to use mysql, too
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  9. #9
    SitePoint Enthusiast
    Join Date
    Sep 2010
    Posts
    63
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i have the database diagram in Attach.

    Actually normal users can fallow other users and can fallow company's, and can answer to job offers. A company can fallow a normal user too.

    In future, users can may belong to a department x or y belongs to a group.

    this part is the problem.
    Attached Images Attached Images


Bookmarks

Posting Permissions

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