User:AKA MBG/Statistics:Parameters of the database created by the Wiktionary parser

Definition from Wiktionary, the free dictionary
Jump to: navigation, search

Parameters of the created (parsed) Wiktionary database[edit]

The parsed database name: enwikt20111008_parsed[1]

Table is a name of the table in the database.

Size is a number of records in the table.

The table filled automatically by wikt.stat.ParsedDB of the wiwordik project.

Table Size Table description
page 1283011 Number of words / entries
relation 227430 Number of semantic relations, e.g. synonyms, antonyms, etc.
lang_pos 1219090 Number of pairs: language & part of speech, one Wiktionary page can contain several such pairs.
wiki_text 1641186 Number of meanings / definitions + number of semantic relations phrases (divided by comma, semicolon) + number of wikified translations.
wiki_text_words 2304041 Number of wikified words (in meanings / definitions + in semantic relations + in translations).
meaning 1634749 Number of meanings, one word can have several meanings / definitions.
inflection 102322 It is extracted from wikified word definitions, e.g. [[normal form|inflection]]
quote 0 Number of quotations and examples, one meaning can have several quotes.
quot_translation 0 Number of translations of quotes (quote in foreign languages can have translation).
quot_transcription 0 Number of transcriptions of quotes.
quot_ref 0 Number of unique quote references (author, title, year,...).
quot_author 0 Number of authors of quotes.
quot_year 0 Number of unique years (and range of years) of quotes.
quot_publisher 0 Number of publishers of quotes.
quot_source 0 Number of sources of quotes.
translation 88450 Number of translation section boxes (at best: one translation box corresponds to one meaning).
translation_entry 801943 Number of different translations (pairs of translations).


  1. ^ This (or more recent) database would be available at the project site wikokit, see Download section.

See also[edit]