**Progress 2019**
[x] Early 2019, investigate normalization of wb_terms
[] T219175 - March 2019 Trail blaze #1 - Migrating data from wb_terms to a new schema.
[] TBD - Read from new schema in production
- TBA tickets for reading for each usecase (for wikidata & wikibase), T198866 will be relevant here?
[] TBD - Use Elastic search for some bulk term lookups?
- {T194158}
- TBA elasticsearch investigation ticket & details / spec
[] TBD - Drop the wb_terms table in production
**Tickets that can be closed once the table is dead**
* Any open tickets on this board: https://phabricator.wikimedia.org/tag/wikidata-ugly-cat-trailblaze_wb_terms_trail_blazing/
* {T86530} - Follows the same sort of idea as this ticket, but has lots of cruft surrounding it, so bets to leave it where it is rather than pull it into a subtask of this task.
* {T197161} - Part of old trail blaze investigation
* {T205194}
* {T198868}
* {T199833}
* {T198866}
* {T142691} - This will technicaly not be an issue, as we won't be using wb_terms, but this could re surface with the new schema
* {T197076}
**Potentially clossable?**
* {T194144}
* {T151789}