Track entity redirects in a database table (associated with the wb_entity_per_page table).
Closed, ResolvedPublic
Actions

Assigned To

None

Authored By

	daniel
	Jun 13 2014, 12:24 PM

Description

When recording redirects in wb_entity_per_page, we need a column (or separate table) to hold the redirect target. This will also allow us to efficiently identifry and filter redirects when iterating over all entit

Version: unspecified
Severity: major
Whiteboard: u=dev c=backend p=0 s=2014-07-15

Details

Reference: bz66582

Related Objects
Search...

Status	Assigned	Task
Open	None	T88728 Improve Wikimedia dumping infrastructure
Open	None	T88991 improve Wikidata dumps [tracking]
Open	None	T46581 Partial dumps
Resolved	Smalyshev	T46580 Script for creating RDF dumps of all entities
Duplicate	None	T211495 Dump(s) of Wikidata classes
Duplicate	None	T211497 Dump(s) of Wikidata instances of Q5
Open	None	T162351 Create a "page prop" RDF dump for Wikidata entities ("pagePropertiesRdf")
Open	None	T98320 [Task] Create dump of entity redirects (JSON or n-triples)
Open	None	T285307 Create randomly split partial entity dumps
Open	None	T44063 [Epic] Provide a plain linked data interface for accessing entities
Resolved	hoo	T101837 [Story] switch default rdf format to full (include statements)
Open	None	T50143 Implement complete RDF mapping for entities (tracking)
Resolved	• Deskana	T96579 EPIC: Deploy Wikidata Query 0.1 Release in labs as official service
Resolved	Smalyshev	T98037 Release Wikidata Query 0.0.1 software package
Resolved	Smalyshev	T95933 Fix unrecognized subjects error on redirects
Open	None	T68067 Support Redirects between Items (tracking)
Resolved	None	T68971 Don't treat referenced entities that are redirects as deleted in the UI
Resolved	None	T68972 Allow redirects to be detected/resolved in bulk via the EntityInfoBuilder class
Resolved	daniel	T69033 Include redirects in RDF rendering.
Resolved	None	T68582 Track entity redirects in a database table (associated with the wb_entity_per_page table).

Event Timeline

• bzimport raised the priority of this task from to High.Nov 22 2014, 3:25 AM

• bzimport added a project: MediaWiki-extensions-WikibaseRepository.

• bzimport set Reference to bz66582.

• bzimport added a subscriber: Unknown Object (MLST).

daniel created this task.Jun 13 2014, 12:24 PM

...when iterating over all entity IDs.

Bug 66074 has been marked as a duplicate of this bug. ***

After some thought, it seems that it's more sensible to have redirect in a separate table, and remove them from wb_entity_per_page. This will assure compatibility with existing code that uses wb_entity_per_page to iterate over all entities, and it generally makes for a nicer database layout.

Adjusting the description accordingly.

We are not going to track them for now.

Needed after all.

After some back-and-forth, we decided to add a column to entity_per_page after all, see the thread on wikidata-tech startwing with http://lists.wikimedia.org/pipermail/wikidata-tech/2014-July/000540.html.

Change 147137 had a related patch set uploaded by Daniel Kinzler:
Tests for redirect handling in EntityRevisionLookup

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

Change 147118 merged by jenkins-bot:
Track redirects in EPP table

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

Change 147137 merged by jenkins-bot:
Tests for redirect handling in EntityRevisionLookup