Algorithm: Build a recommendation for movies you might like
- by Faruz
I need help designing an algorithm for recommendations on movies.
Every user in the system grades movies on a score between 1-100.
Tables consist of:
Table Movies
ID Name Year Rating Runtime
Table Con_MoviesToGenres
MovieID GenreID
Table Con_MovieToUser
MovieID UserID Grade
I'm trying to build a SELECT query to return 5 most recommended movies for a specific movie.
Bearing in mind, I want to integrate in some way, similar genres, highest grades & movie Rating (so you want be recommended an R rated movie for a PG rated movie, unless it's really recommended in every other aspect). Also, if movie matches more than one genre, it will increase its recommendation ratio.
Bonus: If a user gives a low grade to a movie - it will lose recommendation ratio.