Video statistics database

From Tournesol
Revision as of 15:50, 1 May 2021 by imported>Le science4all (Created page with "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, important_scor...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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, important_score, engaging_score, habit_score, pedagogical_score, layman_score, diversity_score, backfire_score, entertaining_score, 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.

Daily update

Every day, the Tournesol learning algorithm computes the Tournesol scores of all videos, and update the database with the results.

Hourly update

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

Hook

Upon new rating.

Upon contributor