Check out the "related stories" on this page" http://mises.org/story/3766
> The first method is basically what the proc does - measuring co-relatedness.
Yes, I think this is what we need to do better.
> Another way is defining tag tuples for each combination of tags on a document and then measuring co-relatedness of the permutations of tag tuples (so basically a multiple level co-relatedness value).
Can this be done on-demand, or does it require a scheduled task?
>What metadata is available though on documents (or items - whatever they need to be called) and what tables are they stored in?
Check out [dbo].[GetContentbyGUID]
We have all kinds of different documents - this is where I try to abstract out the schema.
Yes but can we measure that by the number of tags that documents have in common? Right now it just looks for any matching tag.
> Are the master, temp, and user DB's located on separate physical disks on separate physical controllers. I have a transaction intensive DB that had substantial performance issues until I added a controller and disks and moved the user databases to it. What is the physical layout of the MISESSATA2003 server?
It's a single server with 4 cores and a RAID 1 array. Everything is on the same drive. I think if we just optimized the worst queries, it would make a big difference. I'm not a DBA.
I have been researching tag relevance literature over the past couple of days and there seem to only be several normally exploited methods by which tag relevance is determined. The first method is basically what the proc does - measuring co-relatedness. Another way is defining tag tuples for each combination of tags on a document and then measuring co-relatedness of the permutations of tag tuples (so basically a multiple level co-relatedness value).
I think the real value would come from the document metadata. What metadata is available though on documents (or items - whatever they need to be called) and what tables are they stored in?
I will try some things starting with document data instead of a single tag passed in through the variable.