[Wikidata-bugs] [Maniphest] [Commented On] T215902: Investigate normalization of data stored in wb_terms table

[Addshore]

Addshore added a comment.

Queries end up going from something like this:

SELECT term_full_entity_id FROM wb_terms
WHERE term_text = 'Berlin'
AND (term_type = 'label' OR term_type = 'alias')
AND term_language = 'en';

To something like this:

SELECT entity_id, wb_entity_term_type.type as type, wb_term_search_langs.language as lang, wb_term_search_strings.term_text as text
FROM wb_page_to_entity
INNER JOIN wb_entity_terms_2 ON wb_page_to_entity.page_id = wb_entity_terms_2.page_id
INNER JOIN wb_term_search_langstringtype ON wb_entity_terms_2.langstringtype = wb_term_search_langstringtype.id
INNER JOIN wb_term_search_langstring ON wb_term_search_langstringtype.langstring = wb_term_search_langstring.id
INNER JOIN wb_term_search_langs ON wb_term_search_langstring.term_language = wb_term_search_langs.id
INNER JOIN wb_term_search_strings ON wb_term_search_langstring.term_text = wb_term_search_strings.id
INNER JOIN wb_entity_term_type ON wb_term_search_langstringtype.type = wb_entity_term_type.id
WHERE wb_term_search_strings.term_text = 'Berlin'
AND (wb_entity_term_type.type = 'label' OR wb_entity_term_type.type = 'alias')
AND wb_term_search_langs.language = 'en';

TASK DETAIL

https://phabricator.wikimedia.org/T215902

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Addshore
Cc: Lucas_Werkmeister_WMDE, alaa_wmde, JeroenDeDauw, Ladsgroup, Marostegui, Aklapper, Addshore, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs