Query language exercise

1 Preliminaries

Follow the setup instructions given here, i.e. download R and RStudio, create a directory on your computer where you will store files on this course, make a note of the directory path, create an R project that accesses this directory, and install all indicated packages.

For this and subsequent tutorials, access the tidyverse,magrittr, emuR, and wrassp libraries:

library(tidyverse)

## ── Attaching packages ─────────────────────────────────────── tidyverse 1.3.1 ──

## ✓ ggplot2 3.3.5     ✓ purrr   0.3.4
## ✓ tibble  3.1.4     ✓ dplyr   1.0.7
## ✓ tidyr   1.1.3     ✓ stringr 1.4.0
## ✓ readr   2.0.1     ✓ forcats 0.5.1

## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## x dplyr::filter() masks stats::filter()
## x dplyr::lag()    masks stats::lag()

library(magrittr)

## 
## Attaching package: 'magrittr'

## The following object is masked from 'package:purrr':
## 
##     set_names

## The following object is masked from 'package:tidyr':
## 
##     extract

library(emuR)

## 
## Attaching package: 'emuR'

## The following object is masked from 'package:base':
## 
##     norm

library(wrassp)

The following makes use of the demonstration database emuDB that was also used here.

Store and access the demo database as also described here and thus:

create_emuRdemoData(dir = tempdir())
path.ae = file.path(tempdir(), "emuR_demoData", "ae_emuDB")
ae = load_emuDB(path.ae)

## INFO: Loading EMU database from /var/folders/x_/x690j1dj703f09w41vm3hxd80000gp/T//Rtmp1nz4EP/emuR_demoData/ae_emuDB... (7 bundles found)
## 
  |                                                                            
  |                                                                      |   0%
  |                                                                            
  |==========                                                            |  14%
  |                                                                            
  |====================                                                  |  29%
  |                                                                            
  |==============================                                        |  43%
  |                                                                            
  |========================================                              |  57%
  |                                                                            
  |==================================================                    |  71%
  |                                                                            
  |============================================================          |  86%
  |                                                                            
  |======================================================================| 100%

summary(ae)

## 

## ── Summary of emuDB ────────────────────────────────────────────────────────────

## Name:     ae 
## UUID:     0fc618dc-8980-414d-8c7a-144a649ce199 
## Directory:    /private/var/folders/x_/x690j1dj703f09w41vm3hxd80000gp/T/Rtmp1nz4EP/emuR_demoData/ae_emuDB 
## Session count: 1 
## Bundle count: 7 
## Annotation item count:  736 
## Label count:  844 
## Link count:  785

## 

## ── Database configuration ──────────────────────────────────────────────────────

## 

## ── SSFF track definitions ──

## 

##  name columnName fileExtension
##  dft  dft        dft          
##  fm   fm         fms

## ── Level definitions ──

##  name         type    nrOfAttrDefs attrDefNames       
##  Utterance    ITEM    1            Utterance;         
##  Intonational ITEM    1            Intonational;      
##  Intermediate ITEM    1            Intermediate;      
##  Word         ITEM    3            Word; Accent; Text;
##  Syllable     ITEM    1            Syllable;          
##  Phoneme      ITEM    1            Phoneme;           
##  Phonetic     SEGMENT 1            Phonetic;          
##  Tone         EVENT   1            Tone;              
##  Foot         ITEM    1            Foot;

## ── Link definitions ──

##  type         superlevelName sublevelName
##  ONE_TO_MANY  Utterance      Intonational
##  ONE_TO_MANY  Intonational   Intermediate
##  ONE_TO_MANY  Intermediate   Word        
##  ONE_TO_MANY  Word           Syllable    
##  ONE_TO_MANY  Syllable       Phoneme     
##  MANY_TO_MANY Phoneme        Phonetic    
##  ONE_TO_MANY  Syllable       Tone        
##  ONE_TO_MANY  Intonational   Foot        
##  ONE_TO_MANY  Foot           Syllable

2 Questions

Make segment or event lists from the ae database in the following cases. /x/ refers to annotations at the Phoneme tier, [x] to annotations at the Phonetic tier, orthographic annotations are at the Text tier. A strong (weak) syllable is coded as S (W) at the Syllable tier, and a prosodically accented (unaccented) word as S (W) at the Accent tier. A content (function) word is coded C (F) at the Word tier.

Please place your answers in the R Markdown code blocks or write the answers next to the A:

• 1: Annotations of his (from the Text tier)
• A:

# place answer code here

• 2: /p/ or /t/ or /k/
• A:

# place answer code here

• 3: The sequence /ei k/
• A:

# place answer code here

• 4: Modify the above to find /k/ preceded by /ei/
• A:

# place answer code here

• 5: All words following his
• A:

# place answer code here

• 6: The orthography of all content words
• A:

# place answer code here

• 7: The orthography of all prosodically accented content words
• A:

# place answer code here

• 8: the followed by any word, e.g., sequences of the person or the situation etc. *
• A:

# place answer code here

• 9: /ei/ in strong syllables
• A:

# place answer code here

• 10: Weak syllables containing an /ei/ phoneme
• A:

# place answer code here

• 11: All word-initial and word-medial syllables
• A:

# place answer code here

• 12: Syllables with /p/ or /t/ or /k/
• A:

# place answer code here

• 13: Word-initial /m/ or /n/
• A:

# place answer code here

• 14: All phonetic segments in strong syllables of the words amongst and beautiful
• A:

# place answer code here

• 15: Weak syllables in intonational-phrase final words
• A:

# place answer code here

• 16: The orthography of trisyllabic words
• A:

# place answer code here

• 17: /w/ phonemes in monosyllabic words
• A:

# place answer code here

• 18: Strong syllables that both contain an /s/ and precede a strong syllable
• A:

# place answer code here

• 19: Word-final weak syllables in trisyllabic content words
• A:

# place answer code here

• 20: L+H* annotations (at the Tone tier) in foot-initial syllables in feet of more than two syllables.

• A:

# place answer code here