News for hackers. Stuff that matters.
Re:RecDB - Personalization Recommendation using SQL by hikao on Friday October 18, 2013 @12:11AM (#6569732)
Just came across RecDB a full recommendation engine build inside PostgreSQL.
Re:RecDB - Personalization Recommendation using SQL by dominiclee on Friday October 18, 2013 @01:32AM (#6569935)
interesting to having recommendation function as part of SQL query. Not sure how much latency/delay is added executing recommendation query vs standard query against a big dataset.
Re:RecDB - Personalization Recommendation using SQL by Heikao1 on Wednesday October 30, 2013 @04:39PM (#6643220)
I guess the latency depends on how much the recommendation data fits in main memory. However, based on my understanding RecDB implements the recommendation algorithms as a physiccal operator which expected to be much more efficient than implementing it as a stored procedure or a user defined function.
Re:RecDB - Personalization Recommendation using SQL by Naruto55 on Wednesday October 30, 2013 @05:11PM (#6643437)
A relational database system can scale to few terabytes of data, which is much more than currently available recommendation datasets. However, based on my understanding, if we are talking about Petabyte scale or more, I don't think RecDB is the right option !
Re:RecDB - Personalization Recommendation using SQL by Heikao1 on Wednesday October 30, 2013 @04:41PM (#6643232)
I am curious to know How RecDB supports SVD computation online !
Re:RecDB - Personalization Recommendation using SQL by Naruto55 on Wednesday October 30, 2013 @05:08PM (#6643407)
I don't think there is a way to train an SVD model online. I guess what they do is to materialized both the user feature and the item features matrix and query it on demand.