<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=484090101-20082006><FONT face=Arial size=2>I just read the
relatedness article on Tagschema about users, ideas and tags. While
interesting, I am still failing to see the SQL translation of this
analysis.</FONT></SPAN></DIV>
<DIV><SPAN class=484090101-20082006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=484090101-20082006><FONT face=Arial size=2>I have two tables:
</FONT></SPAN></DIV>
<DIV><SPAN class=484090101-20082006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=484090101-20082006><FONT face=Arial size=2>USERS (user_id,
username)</FONT></SPAN></DIV>
<DIV><SPAN class=484090101-20082006><FONT face=Arial size=2>TAGS (tag_id,
user_id, tag)</FONT></SPAN></DIV>
<DIV><SPAN class=484090101-20082006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=484090101-20082006><FONT face=Arial size=2>What I need to do is
find all users with similar tags to the user I care about. So assume that
I am looking at User A's tags and I want to query the database to find all users
with tags LIKE User A. What I clearly need to do (simplistically speaking)
is find all users with all User A's tags, then all user's with All-1, All-2,
All-3, etc until I reached the max number of users that I want.
Technically, I would also want to "rank" each tag with some weight so tags that
are used less often that User A has in common with others is worth more then
common tags, but I want to leave that out of it for now.</FONT></SPAN></DIV>
<DIV><SPAN class=484090101-20082006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=484090101-20082006><FONT face=Arial size=2>Ideally I would like
to be able to create a SQL query that can be run as called by the user instead
of running some form of a batch process. </FONT></SPAN></DIV>
<DIV><SPAN class=484090101-20082006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=484090101-20082006><FONT face=Arial size=2>How are others
tackling this problem? It also applies to anything else that might be
tagged other then users (e.g. items, whatever).</FONT></SPAN></DIV>
<DIV><SPAN class=484090101-20082006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=484090101-20082006><FONT face=Arial size=2>Thank you for your
suggestions.</FONT></SPAN></DIV>
<DIV><SPAN class=484090101-20082006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=484090101-20082006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=484090101-20082006><FONT face=Arial size=2>Josh
Lippiner</FONT></SPAN></DIV>
<DIV><SPAN class=484090101-20082006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=484090101-20082006><FONT face=Arial size=2>IdeaDisco.com -
Express yourself (c)<EM> Coming
Soon</EM></FONT></SPAN></DIV></BODY></HTML>