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

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 d

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 p

Re: Social Networking querys

2005-02-02 Thread Bruce Douglas
tz <[EMAIL PROTECTED]> Sent: 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

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

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 soluti

RE: Social Networking querys

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

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
Cc: mysql 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 ch

Re: Social Networking querys

2005-02-02 Thread Bruce Douglas
Sent: Feb 2, 2005 9:33 AM To: Bruce Douglas <[EMAIL PROTECTED]> Cc: listsql listsql <[EMAIL PROTECTED]>, mysql 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,

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 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 Bruce Douglas
005 9:05 AM To: listsql listsql <[EMAIL PROTECTED]> Cc: mysql 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

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 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 answerin

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 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 http://iswc2004.s

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 about