Video statistics database
This database is a derived database, which aims to respond efficiently to queries on Tournesol.
A video's statistics is tuple < video_id, reliability_score, reliability_percentile, important_score, important_percentile, engaging_score, engaging_percentile, habit_score, habit_percentile, pedagogical_score, pedagogical_percentile, layman_score, layman_percentile, diversity_score, diversity_percentile, backfire_score, backfire_percentile, entertaining_score, entertaining_percentile, n_contributors, n_ratings, pareto_optimal, public_contributors >.
Currently, the list of public_contributors contains a random set of 20 of the public contributors to the video.
Once all the scores are registered in the database, for each quality criterion, we rank the videos according to the criterion, and we convert the rank of a video into its percentile ranking. This percentile is then saved in the video statistics database.
Every hour, the entries n_contributors, n_ratings, pareto_optimal and public_contributors are updated.
To do so, we go through all the video ratings
Upon new rating.