[prev] 30 [next]

Assignment 2 (cont)

./select RelName 'Query' SigType
  • finds all matches for pmr query in relation RelName
  • queries are expressed using ? for unknown attributes, e.g. 

    ?,?,?,?,?         # matches all tuples
1234567,?,?,?,?   # matches single tuple with this ID
?,?,a3-101,?,?    # matches tuples with a3-101 as 3rd attr
?,?,a3-101,a4-200,a5-013

  • should enclose Query in single quotes   (to avoid problems with zsh)
  • prints one tuple per line   (note: order of tuples is not important)
  • prints page read statistics at end of output