View source

This page documents the database table "aggquery" as used by [[Inverse Search]] and [[Woogle4MediaWiki]] for the aggregate query logging.

See also [[Aggclick table]]

{| {{table}}
| align="center" style="background:#f0f0f0;"|'''field'''
| align="center" style="background:#f0f0f0;"|'''description'''
| align="center" style="background:#f0f0f0;"|'''Test'''
| align="center" style="background:#f0f0f0;"|'''fix/upd'''
| align="center" style="background:#f0f0f0;"|'''change on'''
| align="center" style="background:#f0f0f0;"|'''issue/info'''
| align="center" style="background:#f0f0f0;"|'''usage (vs. IS)'''
| align="center" style="background:#f0f0f0;"|'''db_opt*/TST'''
|-
| id||id||||||||||||PK
|-
| qid||hashed, normalized query string||||x||||(unique)||||UNIQUE_IDX
|-
| needstring||query string||||x||||(normalized)||||UNIQUE_IDX
|-
| needexec ||overall query executions||hash||U||query||(without browsing)||redlinks(rq), ws(in)||
|-
| needexecclick||overall query executions without at least on following result click||hash||U||click||Session!||ws(in)||
|-
| recency ('''!''')||'''XXXX'''||||U||query||!!!||||
|-
| firstdate ||date of the first time, the query was executed||||x||||||||
|-
| lastdate ||date of the last time, the query was executed (now)||||U||query||||redlinks(rq), ws(rq)||
|-
| resulthits ||number of result hits for query||||U||query||Visibility!, Dyn?||||
|-
| sizequeryusers ||size of queryusers||||U||query||User!||redlinks(rq), ws(in)||
|-
| needexecpages||number of query executions for which at least one further result page was browsed||||U||browse||Session!||ws(in)||
|-
| needexecavgpage||average number of result pages users browsed for this query||hash||U||query, browse||Session!||||
|-
| resultclicks ||total number of result clicks following this query (e.g. 1*result1 + 3*result2 = 4)||||U||click||||ws(in)||
|-
| uniqueresults||number of unique results clicked following this query (e.g. result1 + result2 = 2)||||U||click||||||
|-
| queryusers ||CSV-list of all anonymized user ids who executed this query at least once||||U||query||User!||||
|-
| publicusers ||subset of queryusers who agreed to be publicly associated with this query||||U||query||User!||||
|-
| 
|}