dbTalk Databases Forums  

Apriori ranking algorithm in Pick

comp.databases.pick comp.databases.pick


Discuss Apriori ranking algorithm in Pick in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ed Sheehan
 
Posts: n/a

Default Apriori ranking algorithm in Pick - 05-07-2010 , 08:53 AM






The XML saga takes a turn...

My client is looking into the algorithm that some web sites use to rank
their recommended products, and would like to do the process in Universe.

Has anybody used this Apriori algorithm in Pick? I'm trying to rank products
according to category, so that when a person clicks on a pink beedy.widget,
he'll get other beedys, other widgets, and other pink things, ranked with a
confidence level using this algorithm.

I know it's available as a webservice, but do you think bringing it inside
would improve response times?

I'm thinking this may not be a widely known subject, but I've been surprised
before (and lately!)

Thanks,

Ed

Reply With Quote
  #2  
Old   
dawn
 
Posts: n/a

Default Re: Apriori ranking algorithm in Pick - 05-09-2010 , 08:33 AM






On May 7, 8:53*am, "Ed Sheehan" <NOedsS... (AT) xmission (DOT) com> wrote:
Quote:
The XML saga takes a turn...

My client is looking into the algorithm that some web sites use to rank
their recommended products, and would like to do the process in Universe.

Has anybody used this Apriori algorithm in Pick? I'm trying to rank products
according to category, so that when a person clicks on a pink beedy.widget,
he'll get other beedys, other widgets, and other pink things, ranked witha
confidence level using this algorithm.

I know it's available as a webservice, but do you think bringing it inside
would improve response times?
I looked into this breifly when deciding whether to assign a student a
data mining project that was directly relevant to my software. I
decided against it due to the complexity of the algorithm and that I
preferred he looked at bigger variety of data mining techniques. I
thought when I looked into it that there were new algorithms, so you
might check if Apriori is still the algorithm of choice before you
would try to implement it.

My not-really-well-read and no-experience guess on what a good
strategy would be is to use a web server and just make sure it is done
asynch, so users do not wait on response times. If you do get a
strategy on this, I would be interested in knowing what you come up
with. --dawn

Quote:
I'm thinking this may not be a widely known subject, but I've been surprised
before (and lately!)

Thanks,

Ed

Reply With Quote
  #3  
Old   
Ed Sheehan
 
Posts: n/a

Default Re: Apriori ranking algorithm in Pick - 05-09-2010 , 10:07 AM



I've since done some looking, and Apriori seems to be pretty popular out
there. I think I'd start by creating a set of xrefs with the supports and
confidence levels stored, much how an index would appear. This might be done
daily for the day's previous tramsactions, and accumulated for some
meaningful period of time, say 30 days.

Then when someone clicks on a product, I should be able to hash directly
into a record which would have the products also purchased, and also
similary ranked products (clicked a keyboard, show a mouse too). I'm hoping
I can do most of the heavy lifting offline, so the recommendations can be
retrieved quickly. Time is much more important than space here.

I'll take your suggestion and look for other methods as well. Thanks Dawn.

Ed

"dawn" <dawnwolthuis (AT) gmail (DOT) com> wrote

On May 7, 8:53 am, "Ed Sheehan" <NOedsS... (AT) xmission (DOT) com> wrote:
Quote:
The XML saga takes a turn...

My client is looking into the algorithm that some web sites use to rank
their recommended products, and would like to do the process in Universe.

Has anybody used this Apriori algorithm in Pick? I'm trying to rank
products
according to category, so that when a person clicks on a pink
beedy.widget,
he'll get other beedys, other widgets, and other pink things, ranked with
a
confidence level using this algorithm.

I know it's available as a webservice, but do you think bringing it inside
would improve response times?
I looked into this breifly when deciding whether to assign a student a
data mining project that was directly relevant to my software. I
decided against it due to the complexity of the algorithm and that I
preferred he looked at bigger variety of data mining techniques. I
thought when I looked into it that there were new algorithms, so you
might check if Apriori is still the algorithm of choice before you
would try to implement it.

My not-really-well-read and no-experience guess on what a good
strategy would be is to use a web server and just make sure it is done
asynch, so users do not wait on response times. If you do get a
strategy on this, I would be interested in knowing what you come up
with. --dawn

Quote:
I'm thinking this may not be a widely known subject, but I've been
surprised
before (and lately!)

Thanks,

Ed

Reply With Quote
  #4  
Old   
dawn
 
Posts: n/a

Default Re: Apriori ranking algorithm in Pick - 05-10-2010 , 05:49 PM



On May 9, 10:07*am, "Ed Sheehan" <NOedsS... (AT) xmission (DOT) com> wrote:
Quote:
I've since done some looking, and Apriori seems to be pretty popular out
there.
I did a quick search to see what I might have been thinking and I see
lots of apriori out there too, so looks like a safe bet to use it.

Quote:
I think I'd start by creating a set of xrefs with the supports and
confidence levels stored, much how an index would appear. This might be done
daily for the day's previous tramsactions, and accumulated for some
meaningful period of time, say 30 days.
makes sense not to do this on the fly

Quote:
Then when someone clicks on a product, I should be able to hash directly
into a record which would have the products also purchased, and also
similary ranked products (clicked a keyboard, show a mouse too). I'm hoping
I can do most of the heavy lifting offline, so the recommendations can be
retrieved quickly. Time is much more important than space here.
Makes sense to me. I'm not looking forward to it, but I'll have to do
this at some point too, I suspect, so good luck with it. --dawn

Quote:
I'll take your suggestion and look for other methods as well. Thanks Dawn..

Ed

"dawn" <dawnwolth... (AT) gmail (DOT) com> wrote in message

news:885ff862-283f-4c22-b6e3-eec764068547 (AT) l31g2000yqm (DOT) googlegroups.com...
On May 7, 8:53 am, "Ed Sheehan" <NOedsS... (AT) xmission (DOT) com> wrote:

The XML saga takes a turn...

My client is looking into the algorithm that some web sites use to rank
their recommended products, and would like to do the process in Universe.

Has anybody used this Apriori algorithm in Pick? I'm trying to rank
products
according to category, so that when a person clicks on a pink
beedy.widget,
he'll get other beedys, other widgets, and other pink things, ranked with
a
confidence level using this algorithm.

I know it's available as a webservice, but do you think bringing it inside
would improve response times?

I looked into this breifly when deciding whether to assign a student a
data mining project that was directly relevant to my software. I
decided against it due to the complexity of the algorithm and that I
preferred he looked at bigger variety of data mining techniques. I
thought when I looked into it that there were new algorithms, so you
might check if Apriori is still the algorithm of choice before you
would try to implement it.

My not-really-well-read and no-experience guess on what a good
strategy would be is to use a web server and just make sure it is done
asynch, so users do not wait on response times. If you do get a
strategy on this, I would be interested in knowing what you come up
with. *--dawn



I'm thinking this may not be a widely known subject, but I've been
surprised
before (and lately!)

Thanks,

Ed

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.