Wikibase/Schema/wbs_propertypairs

From MediaWiki.org
Jump to navigation Jump to search

The wbs_propertypairs table stores statistics on property usage. It has statistics for 1) properties used for a given class/subclass, 2) properties used as qualifiers for a given property and 3) properties used as references for a given property. The statistics include a count and percentage of items/subclasses/qualifiers/references that have the given property pair.

Fields[edit]

row_id[edit]

auto-increment row ID for internal use. Primary key.

pid1[edit]

  • context item: 31 (instance of) or 279 (subclass of)
  • context qualifier/reference: Property that has a qualifier or reference

qid1[edit]

  • context item: QID of class
  • context qualifier/reference: Not used

pid2[edit]

Property that counts are for.

count[edit]

Count of instances/subclasses that have pid2.

probability[edit]

Percentage of instances/subclasses that have pid2.

context[edit]

What type of pair is this (item (class/subclass -> property), qualifier (property -> qualifier property) or reference (property -> reference property).

Schema[edit]

mysql> describe wbs_propertypairs;
+-------------+---------------------+------+-----+---------+----------------+
| Field       | Type                | Null | Key | Default | Extra          |
+-------------+---------------------+------+-----+---------+----------------+
| row_id      | bigint(20) unsigned | NO   | PRI | 0       | auto_increment |
| pid1        | int(10) unsigned    | NO   | MUL | NULL    |                |
| qid1        | int(10) unsigned    | YES  |     | NULL    |                |
| pid2        | int(10) unsigned    | NO   |     | NULL    |                |
| count       | int(10) unsigned    | NO   |     | NULL    |                |
| probability | float               | NO   |     | NULL    |                |
| context     | varbinary(32)       | NO   |     | NULL    |                |
+-------------+---------------------+------+-----+---------+----------------+
7 rows in set (0.01 sec)

See also[edit]