Inflection Tables

• Tables:

  Inflection
  Name	Type	Properties	Notes
  ifTermLC	CHAR(105)	PRIMARY KEY	Lowercase of Inflected Term
  ifTerm	CHAR(105)	.	Inflected Term
  termCat	INT	.	Category
  termInfl	LONG	.	Inflection
  eui	CHAR(8)	NOT NULL, Indexed	EUI: Unique ID
  unTerm	CHAR(105)	.	Uninflected Term
  unTermLC	CHAR(105)	Indexed	Lowercase of Uninflected Term
  ctTerm	CHAR(105)	.	Citation Term

  Notes:
  The maximum length for ifTerm, ifTerm is 103. We use CHAR(105) for those columns.
  The maximum length for unTerm, ifTerm is 103. We use CHAR(105) for those columns.

• SQL Examples:

  • Find inflected terms for "XXX"
    1. SELECT * FROM Inflection WHERE ifTermLC = "xxx"
    2. Filter out records if EUIs are duplicated
    3. SELECT * FROM Inflection WHERE eui = "xxxeui" AND unTerm = "xxxunTerm
    4. Add the ifTerms from all records.
    5. If none found, use trie (rules).

  • Find uninflected terms for "XXX"
    1. SELECT * FROM Inflection WHERE ifTermLC = "xxx"
    2. Add the unTerm if it does not exist in the output list.
    3. If none found, use trie (rules).

  • Find EUI of a term for "XXX"
    1. SELECT EUI FROM Inflection WHERE ifTermLC = "xxx"

  • Find EUI of an uninflected term for "XXX"
    1. SELECT EUI FROM Inflection WHERE unTerm = "xxx"

  • Find citation terms for "XXX"
    1. SELECT * FROM Inflection WHERE ifTermLC = "xxx"
    2. Add the ctTerm if it does not exist in the output list.