Slide 44
Slide 44 text
Ϩίϝϯυ.BUSJY'BDUPSJ[BUJPO
SELECT
idx,
array_avg(u_rank) as Pu,
array_avg(i_rank) as Qi,
avg(u_bias) as Bu,
avg(i_bias) as Bi,
min(mu) as mu
FROM (
SELECT train_mf_sgd(account_id, creator_id, rating,
'-factor 20 -iter 50 -update_mu') AS (idx, u_rank,
i_rank, u_bias, i_bias, mu)
FROM training
) t
GROUP BY idx;