Query Sample 2:

Word-forms unique to one work
This is a list of all words which according to the lexicographical information contained in the Shakespeare Database are unique word-forms to the Sonnet sand do not occur in other works of Shakespeare. Most of these word-forms occur only once, the lemma unrespected occurs in SON 43.2 and 54.10.

Of course, each of these word-forms has to be interpreted with care and the necessary background knowledge of the Shakespeare Database information architecture. This will be done in detail in a forthcoming monograph on Shakespeare's language. Nevertheless, this list may be of interest both for the specialist and Shakespeare amateurs.

Each unique word-form is listed in the context of theSonnetline. A selection of further lexicographical information, such as the date of first occurrence, can be displayed using the respective links to the Vocabulary Display frame-window on the right side. This display uses the lemmatization relation of the Shakespeare Database linking each word-token in the Shakespeare texts to its respective lexicographical word-form and corresponding dictionary entry (lemma).

SQL Query Commands

1. The first SQL script retrieves all word-forms occurring in the sonnets:

Select  

wordform_name

from  

wordform, token, parsed, text, works

where  

wordform.wordform_no = token.wordform_no
and token.token_no = parsed.token_no
and parsed.text_no = text.text_no
and text.works_no = works.works_no
and short_title = 'SON'
;



2. This resulting list of word-forms is amended by the respective total frequencies in the Shakespeare text:

Select  

wordform_name, works_no, count(*)

from  

wordform, token, parsed, text

where  

wordform.wordform_no = token.wordform_no
and token.token_no = parsed.token_no
and parsed.text_no = text.text_no
and wordform_name = '<wordform_name from (1)>'

group by  

wordform_name, works_no  
;



3. A filter selects those word-forms unique to the sonnets.

4. Finally these word-forms together with a selection of relevant lexicographical information are displayed:

Select  

short_title, scene, line_no, text_line, variant_no, position_in_line, token_in_line, wordform_no, wordform_name, inflection, wordform_alphasort, lemma_name, lemma_homograph_no, word_class, lemma_dating, lemma_dating_remark, etymology_comment, etymology_languages, ultimate_source, immediate_provenance

from  

lemma, wordform, token, parsed, text, works

where  

lemma.lemma_no = wordform.lemma_no
and wordform.wordform_no = token.wordform_no
and token.token_no = parsed.token_no
and parsed.text_no = text.text_no
and text.works_no = works.works_no
and wordform_name = '<wordform_name from (3)>'
;

 

View query result