hoo created this task. hoo claimed this task. hoo added subscribers: Lydia_Pintscher, Aklapper, Lucie, hoo, jcrespo. hoo added projects: Wikidata-Sprint-2016-01-19, ArticlePlaceholder, MediaWiki-extensions-WikibaseClient, Wikidata. Herald added a subscriber: StudiesWorld.
TASK DESCRIPTION I just took a quick look at the ORES database schema an noticed a few things. Maybe not all of them are applicable, but please have a look at them. This is especially important as ORES is going to create multiple rows for each revision in Wikidata's recent changes table (thus many rows and especially a lot of writes/ reads). * `ores_classification` and `ores_model` should probably have a primary key * `ores_classification.ores_model` and `ores_classification.ores_model_version` could probably be removed in favor of a key pointing to `ores_model`. (Especially in case there are significantly less rows expected in `ores_model` than in `ores_classification`) ** For that you probably want to have one table in `ores_model` for each version of each model (and not just one for the current versions). ** If you don't do that, please still make sure you rename one of them to not have the same field names in more than one table. * `ores_classification` should be unsigned to match rev_id * You might want to use different name prefixes for fields in both tables (and not just the generic `ores_`). See also my point about `ores_model` and `ores_model_version` above. * The index `ores_is_predicted` probably is not of much use alone and should be dropped (queries will use `ores_winner` wont they?). This obviously depends on what queries you plan to do. TASK DETAIL https://phabricator.wikimedia.org/T124443 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: hoo Cc: StudiesWorld, jcrespo, hoo, Lucie, Aklapper, Lydia_Pintscher, Wikidata-bugs, aude, Ricordisamoa, Mbch331 _______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
