Page MenuHomePhabricator

Write DDL sql files for creating the schema
Closed, ResolvedPublic

Description

  • use integers for entity ids
  • find better naming for the tables

source: https://commons.wikimedia.org/wiki/File:Wikibase_Terms_Store_Schema.png

Event Timeline

Change 498869 had a related patch set uploaded (by Alaa Sarhan; owner: Jeroen De Dauw):
[mediawiki/extensions/Wikibase@master] Add wb_terms replacement tables

https://gerrit.wikimedia.org/r/498869

Change 499142 had a related patch set uploaded (by Alaa Sarhan; owner: Jeroen De Dauw):
[mediawiki/extensions/Wikibase@master] Add DDL for new schema of normalized wb_terms.

https://gerrit.wikimedia.org/r/499142

Change 498869 abandoned by Alaa Sarhan:
Add wb_terms replacement tables

Reason:
Follow on 499142

https://gerrit.wikimedia.org/r/498869

@Ladsgroup I added the covering indexes on all tables with main field as first index and foreign key as the second to serve the joins.. not sure if we want the reverse order too as covering index so I didn't do it yet

@Ladsgroup I just realized that the covering index should actually have the join column first, right?

@Ladsgroup I just realized that the covering index should actually have the join column first, right?

Yes, that's true!

Change 499142 merged by jenkins-bot:
[mediawiki/extensions/Wikibase@master] Add DDL for new schema of normalized wb_terms

https://gerrit.wikimedia.org/r/499142