Social Networking querys

2005-02-02 Thread listsql listsql
Since I read about Foaf [ http://www.foaf-project.org/ ], I become interested with Social Networking, and readed a lot about it. I 've been playing as well with mysql and join querys to represent network's of people. As I made some queries in google and didn't came with a lot interesting info

Re: Social Networking querys

2005-02-02 Thread Peter Brawley
is, there is some method to iterate in this relation to avoid joining the table in itself each time ? Exactly the problem with trying to model an anything-goes network, a world of ends, in a relational model of a directed graph. I think you need an XML layer in there, eg see

Re: Social Networking querys

2005-02-02 Thread Balazs Rauznitz
On Wed, Feb 02, 2005 at 04:47:31PM +0100, listsql listsql wrote: Since I read about Foaf [ http://www.foaf-project.org/ ], I become interested with Social Networking, and readed a lot about it. I 've been playing as well with mysql and join querys to represent network's of people. As I made

Re: Social Networking querys

2005-02-02 Thread Nick Arnett
listsql listsql wrote: Since I read about Foaf [ http://www.foaf-project.org/ ], I become interested with Social Networking, What you're doing is often called link analysis -- searches on that term may yield more for you to chew on. There are software tools and visualization tools for

Re: Social Networking querys

2005-02-02 Thread Nick Arnett
Peter Brawley wrote: is, there is some method to iterate in this relation to avoid joining the table in itself each time ? Exactly the problem with trying to model an anything-goes network, a world of ends, in a relational model of a directed graph. I think you need an XML layer in there, eg

Re: Social Networking querys

2005-02-02 Thread Bruce Douglas
PROTECTED] Cc: mysql mysql@lists.mysql.com Subject: Re: Social Networking querys On Wed, Feb 02, 2005 at 04:47:31PM +0100, listsql listsql wrote: Since I read about Foaf [ http://www.foaf-project.org/ ], I become interested with Social Networking, and readed a lot about it. I 've been playing

Re: Social Networking querys

2005-02-02 Thread Michael Dykman
During a lengthy stint at a major provider of financial data, I came across this concept generic modelling.. The idea was to have one tables of 'things' and a second one of 'relationships'.. In concept, it's a very powerful and elegant idea, but it tends to be recursion-heavy. Depending on what

Re: Social Networking querys

2005-02-02 Thread Balazs Rauznitz
On Wed, Feb 02, 2005 at 09:20:28AM -0800, Bruce Douglas wrote: hi... i'm not sure who the original poster was... but, there is also an open source app (yogurt) that claims to be used to deal/implement a version of a foaf system, much like okurt/google. i'm not sure how the underlying

Re: Social Networking querys

2005-02-02 Thread Bruce Douglas
[EMAIL PROTECTED] Cc: listsql listsql [EMAIL PROTECTED], mysql mysql@lists.mysql.com Subject: Re: Social Networking querys On Wed, Feb 02, 2005 at 09:20:28AM -0800, Bruce Douglas wrote: hi... i'm not sure who the original poster was... but, there is also an open source app (yogurt

Re: Social Networking querys

2005-02-02 Thread Bruce Douglas
@lists.mysql.com Subject: Re: Social Networking querys listsql listsql wrote: Since I read about Foaf [ http://www.foaf-project.org/ ], I become interested with Social Networking, What you're doing is often called link analysis -- searches on that term may yield more for you to chew on. There are software

RE: Social Networking querys

2005-02-02 Thread Dathan Pattishall
DVP Dathan Vance Pattishall http://www.friendster.com -Original Message- From: Balazs Rauznitz [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 02, 2005 9:06 AM To: listsql listsql I work at a social networking company. We store the social network as an edge

RE: Social Networking querys

2005-02-02 Thread Bruce Douglas
- From: Dathan Pattishall [EMAIL PROTECTED] Sent: Feb 2, 2005 10:04 AM To: Balazs Rauznitz [EMAIL PROTECTED], listsql listsql [EMAIL PROTECTED] Cc: mysql mysql@lists.mysql.com Subject: RE: Social Networking querys DVP Dathan Vance Pattishall http://www.friendster.com -Original

Re: Social Networking querys

2005-02-02 Thread Balazs Rauznitz
On Wed, Feb 02, 2005 at 10:19:45AM -0800, Bruce Douglas wrote: dathan... given that you work at friendster, aren't you kind of restricted from commenting on how one would go about creating/implementing this kind of system?? I thought about this too when describing my company's solution

RE: Social Networking querys

2005-02-02 Thread Dathan Pattishall
DVP Dathan Vance Pattishall http://www.friendster.com -Original Message- From: Bruce Douglas [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 02, 2005 10:20 AM To: Dathan Pattishall Cc: mysql@lists.mysql.com Subject: RE: Social Networking querys dathan... given

Re: Social Networking querys

2005-02-02 Thread Bruce Douglas
: Feb 2, 2005 10:44 AM To: Bruce Douglas [EMAIL PROTECTED] Cc: Dathan Pattishall [EMAIL PROTECTED], mysql@lists.mysql.com Subject: Re: Social Networking querys On Wed, Feb 02, 2005 at 10:19:45AM -0800, Bruce Douglas wrote: dathan... given that you work at friendster, aren't you kind

Re: Social Networking querys

2005-02-02 Thread Mark Papadakis
We have implemented a system which uses 'swappable' in-memory data, binary trees and hashtables to do things like: o Return 'best' possible route from one person to another based on weight of relationships between links o Return 'shortest' possible route from one person to another o Return total

Re: Social Networking querys

2005-02-02 Thread Balazs Rauznitz
On Wed, Feb 02, 2005 at 10:55:41AM -0800, Bruce Douglas wrote: balazs... cool... makes sense. then if that's the case, share away how's the weather over in fl. i noticed on your site that you guys are fairly small, makes for a good environment when getting work done! One thing I

Re: Social Networking querys

2005-02-02 Thread listsql listsql
i'm not sure who the original poster was I'm Fasani, I work in a spanish telecommunications company on the statistics department as a DBA/developer. I'm on this list because we use mysql for the online statistics and I'm always reading this when I have some free time. Thanks all who commented on