Teradata recommends pSALSA for recommending products to similar users when the product line has limited pairwise history or changes frequently. An example of a product line that changes frequently is apparel, which is subject to seasons and trends.
The input tables for this example represent a graph of customers and the clothes that they buy. The input vertices table, user_product_nodes, contains customer names. The edges table, women_apparel_log, reflects customer shopping patterns. The goal is to find customers who are similar and thus determine product recommendations.
nodeid | nodename |
---|---|
1 | Sandra |
2 | Susan |
3 | Stacie |
4 | Stephanie |
5 | Sally |
6 | coats |
7 | sweaters |
8 | jackets |
9 | blazers |
10 | pants |
11 | pajamas |
username | product | frequency |
---|---|---|
Sally | blazers | 2 |
Sally | coats | 10 |
Sally | jackets | 8 |
Sally | sweaters | 9 |
Sandra | coats | 10 |
Sandra | jackets | 8 |
Sandra | sweaters | 9 |
Stacie | pajamas | 9 |
Stacie | pants | 9 |
Stephanie | blazers | 5 |
Stephanie | jackets | 4 |
Stephanie | pajamas | 7 |
Stephanie | pants | 6 |
Susan | blazers | 5 |
Susan | jackets | 2 |
Susan | pajamas | 5 |
Susan | pants | 4 |
Susan | sweaters | 4 |