All data is collected from HopAmChuan store in the Data Warehouse with the purpose is based on the playlist of the user to analyze and recommend similar songs that the user might like them. The Data Warehouse has the Entity Relationship Diagram as the following.
Aggregates the individual items for get the specific table relative to the specific user
SongID | bollero | ballad | blue | bossanova | rock | chachacha | fox | rhumba | boston | disco | pop | slow | slowrock | tango | valse |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1911 | 24 | 10 | 2 | 2 | 2 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
7073 | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 |
769 | 2 | 32 | 2 | 0 | 5 | 0 | 0 | 0 | 1 | 1 | 0 | 9 | 57 | 0 | 0 |
4618 | 1 | 25 | 8 | 1 | 3 | 2 | 2 | 3 | 0 | 0 | 4 | 74 | 11 | 6 | 14 |
9460 | 39 | 10 | 1 | 0 | 0 | 3 | 0 | 1 | 3 | 1 | 0 | 2 | 10 | 0 | 0 |
3368 | 73 | 23 | 3 | 0 | 0 | 2 | 1 | 4 | 3 | 7 | 1 | 13 | 2 | 1 | 0 |